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
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 gnumeric-list gnome org https://mail.gnome.org/mailman/listinfo/gnumeric-list