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

Eike Rathke erack at redhat.com
Thu Apr 26 07:23:35 PDT 2012

Hi Florent,

On Thursday, 2012-04-26 04:29:03 +0200, Florent Gallaire wrote:

> Thanks for the commit Eike, I'm really proud and grateful !


> > Main change is that the "Save cell content as shown" option is
> > independent of the "Save formulas" option and should not be disabled
> > when checking that.
> I disagree, and I will try to explain myself :
> When you export a cell with =DATE(1981;9;20) by values, you have :
> 1) 20/09/81 when "Save cell content as shown" is set
> 2) 29849  when "Save cell content as shown" is not set
> When you export the same cell by formulas, you always have
> =DATE(1981;9;20), regardless the "Save cell content as shown" option.
> As this option is no more relevant in this context , for a good user
> experience, she should be disabled, this is an information for the
> user.

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. 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?


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/20120426/c9d1e3d0/attachment.pgp>

More information about the LibreOffice mailing list