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? Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD : 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
Attachment:
pgptfhk5WnUsl.pgp
Description: PGP signature