Aw: Re: 'floor' xlsx roundtrip sometimes comes back as 'rounddown' - intentional?
newbie nullzwei via gnumeric-list <[email protected]> Thu, 21 Apr 2022 08:35:04 +0200
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <trinity-ab1dd34f-8f7f-46f6-a6ce-4007b700ad09-1650522904544@3c-app-gmx-bs65> |
--===============4134295518405396593== Content-Type: text/html; charset=UTF-8 <html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div style="font-family: Verdana;font-size: 12.0px;"> <div><br/> hello Andreas, thanks for your input,<br/> <br/> hmmmm ...<br/> <br/> not too easy to deal with excel, either i'm confused or they contradict themself.<br/> <a href="https://support.microsoft.com/en-us/office/floor-function-14bb497c-24f2-4e04-b327-b0b4de5a8886" target="_blank">support.microsoft.com - FLOOR function: </a><br/> either this: I.) 'Rounds number down, **toward zero**, to the nearest multiple of significance.',<br/> (think that's mimiced by gnumeric),<br/> or that: II.) 'If the sign of number is negative, a value is rounded down and adjusted **away from zero**.' <br/> (think that's mimiced by LO Calc),<br/> or that: III.) '=FLOOR(-2.5,-2) Rounds -2.5 down to nearest multiple of -2. **-2**'<br/> sample with behaviour like I.)<br/> <div>excel requires the input of a significance parameter, in gnumeric you can omit it, then '1' ( or partly -1 ) is taken as default, <div>elsewhere - odf export - gnumeric solves the problem by specifying a 'fake' parameter 'sign(x)'.<br/> This way seems to make more sense to me since it:<br/> 1. preserves the function name,<br/> 2. gives the possibility to get back the original expression when re-converting to gnumeric formats by omitting the added sign(x).<br/> ( Once the function name is changed there is no way to tell if the origin was a floor or rundown expression. )</div> <div>Why I am looking for a better solution to this rather small problem? In the too many messages that the tests give out,<br/> some small things get lost ( '<a href="https://www.youtube.com/watch?v=31xA9p3pYE4&t=1060s" target="_blank">Fefe calls such a 'bug wave'</a> ), or it is tedious and time consuming to check the effects of changes.<br/> In this respect, any help is welcome even if my suggestions do not always fit, I'm just searching.<br/> <br/> b.</div> </div> </div> <div> <div> <div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);"> <div> <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</p> <div class="moz-cite-prefix"> </div> <blockquote> <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/> ...</div> </div> </div> </div> </blockquote> </div> </div> </div> </div> </div></div></body></html> --===============4134295518405396593== 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 --===============4134295518405396593==--