[Libreoffice-bugs] [Bug 129826] New: Storing language based user defined format codes of cells does not work for color code based entries.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129826
           Summary: Storing language based user defined format codes of
                    cells does not work for color code based entries.
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ralf at hendel.name

Description:
When adding a user defined format code for currency formatted fields, it works
as long as you don't close the document. After closing and reopening it, the
format code value is not contained in the list of available formats and the
format value of the field is set back to the last available entry of the list.

This problem only remains if I use color codes like "FARBE01" or "FARBE22"
instead of color names (FARBE is the German translation of COLOR). If I use
"GREEN" or "GRÜN" (GRÜN ist German translation of GREEN).

I use libre office with English surface but on a German operating system. It
works both entering color codes like "FARBE01" as well as "COLOR01". Bu when I
enter "COLOR01", store the "Format cell" form and reopen the form, I find it
translated to "FARBE01".

This brings me to the idea, that this behavior may have something to do with
the translation handling of format codes.

Steps to Reproduce:
1.
Entering a user defined format code for currency formatted cells while using a
format code like "FARBE01" or "COLOR01".

2.
Confirming that the cells will be displayed according the format code like
expected.

3.
Storing and closing the document.

4.
Reopening the document.

5.
Confirming the unexpected behavior:

5.1.
The concerned cells won't be displayed according the format code like expected.

5.2.
The user-based entry is no longer available in the list for format codes. 

Actual Results:
The concerned cells won't be displayed according the format code like expected.
The user-based entry is no longer available in the list for format codes. 


Expected Results:
Using color format codes like "FARBE01" or "COLOR01" will still work after
reopening the document.
User based entries of format codes like "FARBE01" or "COLOR01" will be
available even after reopening the document. 


Reproducible: Always


User Profile Reset: No



Additional Info:
I use libre office with English surface but on a German operating system. It
works both entering color codes like "FARBE01" as well as "COLOR01". Bu when I
enter "COLOR01", store the "Format cell" form and reopen the form, I find it
translated to "FARBE01".

This brings me to the idea, that this behavior may have something to do with
the translation handling of format codes.

-- 
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/20200106/9def458d/attachment.htm>