https://bugs.documentfoundation.org/show_bug.cgi?id=153993
Bug ID: 153993
Summary: FORMATTING: Calc alters custom number format on save
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: x86-64 (AMD64)
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
-- Tested on
MacOS Ventura 13.2.1
Libreoffice 7.5.1.2, build: fcbaee479e84c6cd81291587d2ee68cba099e129
-- To reproduce:
Launch LibreOffice
Click "Create/Calc Spreadsheet"
Enter the following in cells A1-A3:
123.456
1234.56
12345.6
Select these three cells
Click "Format/Cells..."
In the "Category" list, click "User-defined"
In Format code enter: "###.000 e0" ..but without the quotes
Click the 'add' button (bearing the green checkmark)
Note that:
the "Category" switches to "Scientific"
the new format appears as expected
the example is formatted as desired (with a lowercase 'e' preceeded by a
space)
Under category, click "User-defined"
Verify that the new format appears here as well.
Click OK
Verify that the three cells are formatted as desired:
123.456 e0
1.235 e3
12.346 e3
Click "File/Save," give the document a name, and click "Save"
Close the file, then close Libreoffice
Reopen the file.
Note that the cells are now formatted as:
123.456E0
1.235E3
12.346E3
Click "Format/Cells"
Note that the format has been altered to:
###.000E0" "
Note that this altered format appears in both categories: "User-defined" and
"Scientific"
-- Expected result:
Format should be saved as entered.
Or, if the format is erroneous, it should be corrected _immediately_, rather
than waiting until the document is saved/reopened.
-- Documentation
The documentation is not entirely clear on whether a space is acceptable before
the "e" in this style format. (Though this reporter would appreciate it!)
The documentation _does_ say that a lowercase "e" should be OK, but LibreOffice
does not preserve it.
-- similar bug?
Bugs 146404 and 152724 seem very similar, though this reporter can't be sure
it's the same underlying issue.
--
You are receiving this mail because:
You are the assignee for the bug.
