https://bugs.documentfoundation.org/show_bug.cgi?id=159930
Bug ID: 159930
Summary: Minus sign mis-placed with format ".00" until
save/reload
Product: LibreOffice
Version: 24.8.0.0 alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In calc: A number format code which does not specify any digits to the left of
the decimal for example ".00;-.00", is spontaneously changed when
saving/reloading to insert a '#' before the decimal, to ""#.00;-#.00" in this
example.
The problem is that until a save/reload is done, the format mis-behaves: The
'-' symbol is mis-placed in large negative values. For example "9999-.00" is
shown instead of "-9999.00".
I think LO should either:
1. Handle ".00;-.00" correctly (i.e. not mis-place the minus sign) and do not
alter the format when saving; or
2. Immediately force-insert the '#' instead of waiting for a Save/Reload (or
treat the format as an error and inform the user).
Either way, LO should not display wrong results, or different results after
save/reload.
Steps to Reproduce:
1. Right-click on a cell -> Format Cells -> Numbers
2. Enter ".00;-.00" (without quotes) in the "Format code" box. Click OK
3. Enter a large negative value into the cell such as -99999
(wrong display appears)
4. Save & Reload
(display is correct; inspecting the format shows it was changed)
Actual Results:
Display shows "99999-.00"
Expected Results:
It should show "-99999.00" and should not modify the format during save/reload;
OR, the format should be modified instantly when the user enters it so it will
work;
OR, the user should be informed that the format is illegal (if it is...)
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3b73071f7a7fcf80547da81e5effe4ed6018bbb4
CPU threads: 12; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
