Bug 62502 - Formation can't be changed
Summary: Formation can't be changed
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-03-19 01:37 UTC by sworddragon2
Modified: 2013-03-19 17:23 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description sworddragon2 2013-03-19 01:37:21 UTC
There is a way the formation of a cell can't be changed anymore. Here are the steps to reproduce:

1. Open a new Calc document.
2. Write in the cell A1 "-1" (without double quotes).
3. Calculate the cell B1 with "=A1".
4. Format B1 with "#,##0.00;[RED]-#,##0.00".
5. Save the document and close it.
6. Open the document.
6.1. Here is already a minor bug: The content of cell B1 hasn't a red font anymore.
7. Format B1 as General.
8. The cell contains now "-1.00" but it should contain just "-1".
Comment 1 Jorendc 2013-03-19 17:23:12 UTC

Thanks for your clear steps and time reporting.

I can reproduce your behavior, except this one:
(In reply to comment #0)
> 8. The cell contains now "-1.00" but it should contain just "-1".

I got a formatting "-1.0000", but it still isn't correct. It seems like this is a duplicate of Bug 60215

Kind regards,

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