[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)".


FLOSS Engineer & Lawyer

More information about the LibreOffice mailing list