https://bugs.documentfoundation.org/show_bug.cgi?id=146404
Bug ID: 146404
Summary: Number Format Code: Not all color codes are saved
Product: LibreOffice
Version: 7.1.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mmuel...@datastreamsolutions.com
1 Description
When using special color codes in number format codes, e.g.
COLOR23¹
that aren't 1 of the 8 documented² color codes, i.e.
CYAN, GREEN, BLACK, BLUE, MAGENTA, RED, WHITE, YELLOW
the application will correctly display the color, but after saving and
reloading the document, the color code will no longer be part of the number
format, and no color will be displayed.
2 Steps to reproduce
2.1 Enter "-1234" into a cell.
2.2 Open cell formatting for that cell, and change the number format to
[COLOR23]0.0
2.3 The number in the cell will now appear green-ish.
2.4 Save the document. Close the document. Re-open the document.
2.5 The number in the cell will appear with the default font color. (NOT
green-ish) If you open the cell formatting, you will see the color code
vanished from the number format code.
3 Is this a bug?
While it is documented that there are only 8 number format code colors², the
application still reacts to input such as COLOR23. This indicates to the user
that this is an undocumented feature. The loss of these settings after
reloading the document is highly unintuitive. So either:
a) (Documentation okay, Application bug)
The bug is that the application allows undocumented color codes.
b) (Documentation bug, Application bug)
The documentation forgot to mention the COLOR{NN} codes and the
application doesn't properly save them.
4 System parameters
Operating system: Gentoo
Package manager: Portage
Package: app-office/libreoffice 7.1.7.2
- Note: Compiled from source, as opposed to the app-office/libreoffice-bin
package.
Portage flags:
- USE: bluetooth branding cups dbus gtk mariadb -accessibility -base -clang
-coinmp -custom-cflags -debug -eds -firebird -googledrive -gstreamer -java -kde
-ldap -odk -pdfimport -postgres -test -vulkan
- ELIBC: -FreeBSD
- LIBREOFFICE_EXTENSIONS: -nlpsolver -scripting-beanshell -scripting-javascript
-wiki-publisher
- PYTHON_SINGLE_TARGET: "python3_9 -python3_8 -python3_10
5 Footnotes
¹ COLOR23 is a valid Excel number format code color.
²
https://help.libreoffice.org/7.2/en-US/text/shared/01/05020301.html#hd_id3155994
--
You are receiving this mail because:
You are the assignee for the bug.
