Bug 155629 - Number format lost when click inside the cell
Summary: Number format lost when click inside the cell
Status: RESOLVED DUPLICATE of bug 120670
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-06-01 13:49 UTC by bingfan.ni
Modified: 2024-12-09 08:37 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Demonstration for described error (5.40 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2023-06-01 13:49 UTC, bingfan.ni
Details
Demonstration for format and comma lost (5.41 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2023-06-02 08:24 UTC, bingfan.ni
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bingfan.ni 2023-06-01 13:49:07 UTC
Created attachment 187641 [details]
Demonstration for described error

Open Libre Office Write and insert a table, insert a formular (e.g. <C3>*<D3>) into any cell, change format from "Standart" into "-1.234,56", and push "OK". Everything seem to be fine. But I you save the document in .docx and reopen it and go to C3 the format "-1.234,56" ist lost. If you view the format it shows "Standard" again.
Comment 1 bingfan.ni 2023-06-01 13:57:04 UTC
If the document was saved in .odt the format remains in "-1.234,56".
Comment 2 m_a_riosv 2023-06-01 14:48:00 UTC
Reproducible with
Version: 7.5.4.1 (X86_64) / LibreOffice Community
Build ID: 3a6a10a8a824826630ea908dcaea93b45a6a0af1
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 70fd835b4cf75e386ee115c705241a4059fb68a8
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded

At opening the format looks fine but after clicking the cell with formula, the format it's lost.
Comment 3 bingfan.ni 2023-06-02 08:24:09 UTC
Created attachment 187656 [details]
Demonstration for format and comma lost
Comment 4 bingfan.ni 2023-06-02 08:26:59 UTC
Some information of formular get also lost. I habe entered a formular with a decimal number 0,5. It seem to work, but after saving and reopening the document the formular deliveres a wrong result. The comma in the decimal number got lost. Instead there is an "|".
Comment 5 m_a_riosv 2023-06-02 21:27:32 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 6 bingfan.ni 2023-06-05 06:58:50 UTC
I used the same document and tested it in save mode, as described. Same failure, format and comma got lost also in save mode.
Comment 7 BogdanB 2024-12-09 08:37:33 UTC

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