Bug 140052 - FORMATTING, FILEOPEN, FILESAVE: Custom number cell format changed after save/open file
Summary: FORMATTING, FILEOPEN, FILESAVE: Custom number cell format changed after save/...
Status: RESOLVED DUPLICATE of bug 152724
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Number-Format
  Show dependency tree / graph
 
Reported: 2021-02-01 08:42 UTC by libre
Modified: 2023-02-27 08:13 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description libre 2021-02-01 08:42:23 UTC 
Some (special) cell format is not stored correctly when saving and re-opening an ODF file.

How to reproduce:
- New calc file
- Insert value "100000.000001" in any cell
- Set number format for the cell to "#.##0,000_.000" (without quotes)
- (Value will be shown like "100.000,000 001", as expected)
- Save file (default format ODF)
- Close file
- Open saved file
- Value is now shown as "100.000,000001 " (note the blank has moved to the end)
- Open cell format dialog, format is now '#.##0,000000" "' (the _. has been removed, a blank has been inserted at the end)



Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
Comment 1 pavlog 2021-02-28 14:50:12 UTC 
I can reproduce it in

Version: 7.2.0.0.alpha0+ (x64)
Build ID: ecb916667b633f8647790e040226b093760e6cfe
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 2 m_a_riosv 2021-09-16 15:46:01 UTC 
*** Bug 144446 has been marked as a duplicate of this bug. ***
Comment 3 Laurent Balland 2023-02-27 08:13:06 UTC 
This bug is composed of 2 bugs:
- bug152724 about "_x" code to enable a blank of defined width
- bug96723 about embedded text in decimal part, which is fixed since LibO7.4

Now format "#,##0.000_.000" is saved in ODF as "#,##0.000" "000" (with , as thousand separator and . as decimal separator)

*** This bug has been marked as a duplicate of bug 152724 ***