[PUSHED][PATCH] fdo#45664 EasyHack: Calc can't export the cells formulas to CSV (only the cells values)

Eike Rathke erack at redhat.com
Mon Apr 30 04:46:59 PDT 2012


Hi Florent,

On Saturday, 2012-04-28 06:53:34 +0200, Florent Gallaire wrote:

> Probably the problem is the global calc behaviour and won't be fixed.

Wrong ;-)  It is already fixed with the locale dependent date acceptance
patterns recently implemented. Anyway, this is not really related to the
"export as shown" option that is general to all number formats. 

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

Actually no. In en_US locale it is expected that the input of 4/2
results in 04/02/12, of course that is not desired in other locales that
use a different date separator. What the fix mentioned is about. For
details see
http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html

  Eike

-- 
LibreOffice Calc developer. Number formatter stricken i18n transpositionizer.
GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20120430/018a605c/attachment.pgp>


More information about the LibreOffice mailing list