Bug 62502

Summary:	Formation can't be changed
Product:	LibreOffice	Reporter:	sworddragon2
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	jorendc
Priority:	medium
Version:	4.0.1.2 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

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

Hi,

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,
Joren

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