[PUSHED][PATCH] fdo#45664 EasyHack: Calc can't export the cells formulas to CSV (only the cells values)
Florent Gallaire
fgallaire at gmail.com
Fri Apr 27 21:53:34 PDT 2012
> That behavior is only with formula cells though. Value cells without
> formulas are still affected by the option; without being checked the raw
> value is exported, when checked the value is exported as displayed by
> the number format applied.
You are right !
> If you have a good idea how that could be
> clarified for the user I'd welcome your patch :-) Maybe just some
> rewording of the option is needed?
Probably the problem is the global calc behaviour and won't be fixed.
For me "=4/2" is the number "2", and "4/2" should always be the string
"4/2" and never the evil "02/04/12", which should only be the result
of "=DATE(2012;2;4)".
Florent
--
FLOSS Engineer & Lawyer
More information about the LibreOffice
mailing list