[Libreoffice-bugs] [Bug 128273] FORMATTING Calc changes a number format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128273

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
(In reply to Julien Nabet from comment #7)
> (In reply to Eike Rathke from comment #6)
> > The number formatter is file format agnostic and should be.
> I don't understand why but you're the Calc expert and I trust you.
Because the number formatter does not know anything about the target file
format the number format will be stored in, storing to Excel formats for
example simply will store the format code. Reading such format code also should
not invalidate the format just because it could be stored in a different file
format. Also, with the (more empirically determined) syntax of these format
codes constructs are possible that can't be stored in all file formats. Then
again, some formats are possible that can be stored in ODF but not in OOXML.
Hence restricting the number formatter to a subset that all file formats know
even if a format code otherwise is syntactically correct would not be a good
approach. And furthermore error-prone because the format code syntax is really
twisted..

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191024/a84288cf/attachment.html>