https://bugs.documentfoundation.org/show_bug.cgi?id=97837
Bug ID: 97837
Summary: FORMATTING: General Replaces User Defined Format When
Workbook is Saved, Close and Reopened
Product: LibreOffice
Version: Inherited From OOo
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User defined custom formats may be re-arranged (normalised) by LibreOffice.
For example: {{{General "Strike"}}} is rearranged as {{{General" Strike"}}}.
You may have to save, close and reopen the workbook to see this but, yes,
the space has moved from the left to the right of the adjacent quote.
Over time, I've got the hang of this and now experience few surprises.
However there is one unwelcome one.
I know the @ symbol has special significance and must be quoted, for example:
{{{"@ "General}}}. Does what it should and survives save/close/reopen.
I do not know that the / symbol has any special significance but I quote it
anyway: {{{"/ "General}}}. This does what it should but does not survive
save/close/reopen. When the workbook is reopened, the format has been changed
to just {{{General}}}.
I don't want {{{"@ "General}}}: it's just the simplest example I can think of.
I want {{{"/ "#,##0.00}}} but that too is re-arranged to just {{{General}}}.
Actually, I want {{{[>0]"/ "#,##0.00;[<0]"/ -"#,##0.00;0}}} but this gets
rearranged to {{{[>0]General;[<0]"/ -"#,##0.00;0}}}.
This looks to me like unintended behaviour rather than aping the behaviour
of other spreadsheets.
This behaviour is present in 5.1.0. It was first noticed in 3.5.7, which I
still use on a daily basis. I've checked 3.3.0 and the behaviour is there
also so I guess it was inherited from OOo.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
