Re: 'floor' xlsx roundtrip sometimes comes back as 'rounddown' - intentional?

"Andreas J. Guelzow" <[email protected]> Wed, 20 Apr 2022 11:54:11 -0600
Newsgroups	gmane.comp.gnome.apps.gnumeric
Message-ID	<[email protected]>
This is a multi-part message in MIME format.
--===============5807157344891126291==
Content-Type: multipart/alternative;
 boundary="------------41351C92946536A58B6E480D"
Content-Language: en-CA

This is a multi-part message in MIME format.
--------------41351C92946536A58B6E480D
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Excel and so xlsx files do not understand '=floor(0.5)'. So when one 
exports to xlsx one cannot retain '=floor(0.5)'. To retain the functions 
as they are you either have to restrict yourself to excel functions os 
save in Gnumeric's own format.

Andreas

On 2022-04-20 11:12 a.m., newbie nullzwei via gnumeric-list wrote:
>
> not deeply investigated, thus more a question than an issue:
>
> t6590-samples test sends '=floor(0.5)' in an xlsx roundtrip and gets 
> back '=rounddown(0.5,0)'.
> same happens to calculating cells in a sheet.
> while '=floor(0.5,0.15)' comes back unchanged.
>
> is there any rationale in changing the function? on first sight the 
> handling is different for one vs. two argument calls.
>
> apart from the fact that the results are identical in value, the 
> following points speak for returning a formula with 'floor' instead of 
> 'rounddown':
> - the functionalities of floor and rounddown are different, the second 
> parameter of floor specifies the significance value and defaults to 1, 
> while for rounddown it means the number of decimal places and defaults 
> to 0,
>
> - unnecessary entries are created in the test logs, t6590-samples.pl.log,
> - users get irritated when they use a function and can't find it again 
> after saving,
>
> _______________________________________________
> gnumeric-list mailing list
> [email protected]
> https://mail.gnome.org/mailman/listinfo/gnumeric-list

--------------41351C92946536A58B6E480D
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Excel and so xlsx files do not understand '=floor(0.5)'. So when
      one exports to xlsx one cannot retain '=floor(0.5)'. To retain the
      functions as they are you either have to restrict yourself to
      excel functions os save in Gnumeric's own format.</p>
    <p>Andreas<br>
    </p>
    <div class="moz-cite-prefix">On 2022-04-20 11:12 a.m., newbie
      nullzwei via gnumeric-list wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:trinity-04c30e28-d64d-40af-9230-8d4a485f27ab-1650474724174@3c-app-gmx-bs65">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div style="font-family: Verdana;font-size: 12.0px;">
        <div style="font-family: Verdana;font-size: 12.0px;">
          <div style="font-family: Verdana;font-size: 12.0px;">
            <div style="font-family: Verdana;font-size: 12.0px;"> <br>
              not deeply investigated, thus more a question than an
              issue: <br>
               <br>
              t6590-samples test sends '=floor(0.5)' in an xlsx
              roundtrip and gets back '=rounddown(0.5,0)'. <br>
              same happens to calculating cells in a sheet. <br>
              while '=floor(0.5,0.15)' comes back unchanged. <br>
               <br>
              is there any rationale in changing the function? on first
              sight the handling is different for one vs. two argument
              calls. <br>
               <br>
              apart from the fact that the results are identical in
              value, the following points speak for returning a formula
              with 'floor' instead of 'rounddown': <br>
               
              <div>- the functionalities of floor and rounddown are
                different, the second parameter of floor specifies the
                significance value and defaults to 1, while for
                rounddown it means the number of decimal places and
                defaults to 0,  <br>
                  <br>
                - unnecessary entries are created in the test logs,
                t6590-samples.pl.log, <br>
                 </div>
              <div>- users get irritated when they use a function and
                can't find it again after saving, </div>
               </div>
          </div>
        </div>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <pre class="moz-quote-pre" wrap="">_______________________________________________
gnumeric-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:[email protected]">[email protected]</a>
<a class="moz-txt-link-freetext" href="https://mail.gnome.org/mailman/listinfo/gnumeric-list">https://mail.gnome.org/mailman/listinfo/gnumeric-list</a>
</pre>
    </blockquote>
  </body>
</html>

--------------41351C92946536A58B6E480D--

--===============5807157344891126291==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
gnumeric-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

--===============5807157344891126291==--