https://bugs.documentfoundation.org/show_bug.cgi?id=124860
Cor Nouws <cno@nouenoff.nl> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|6.2.2.2 release |6.2.0.3 release
Keywords| |regression
Summary|Formatting: Formula result |FileOpen: Formula result
|has different alignment |has different alignment
|than regular values |than regular values
--- Comment #27 from Cor Nouws <cno@nouenoff.nl> ---
(In reply to bugzilla2 from comment #26)
Thats because you replaced a formula value with a regular value. As noted in
my initial report of the issue (and also in the outline), its about regular
values and formula results getting different formatting with the new
settings.
Got it. (Bit late, to be honest, but I think I've reasons to forgive myself for
that ;) ) Thanks for you patience!
I think the reason is clear: formula content of cells has to be evaluated on
opening the document.
Test:
- create old settings
- open your file
> all as it was
- change settings
- File > Reload
> changes are there.
So I guess this can be achieved: if Number Recognition is off, the other two
should not be evaluated. Not sure if it's easy (*).
( @devs: any code pointers of where to look? )
If it won't be picked up (by me - agenda :( - or someone else) to change that,
I tend to say that the disadvantage of changing older files puts in more weight
than the advantage of a more logic default setting.
*) not to mention another possibility of storing table data on saving, as is
done with spreadsheets.
--
You are receiving this mail because:
You are on the CC list for the bug.
Context
- [Libreoffice-ux-advise] [Bug 124860] FileOpen: Formula result has different alignment than regular values · bugzilla-daemon
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.