Issue 122020 - Format modifications are return to "Standard" in spite of change format of cells and save it in Calc.
Summary: Format modifications are return to "Standard" in spite of change format of ce...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-09 04:18 UTC by HD
Modified: 2014-03-24 06:22 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---


Attachments
Screen shots of Steps To Reproduce. (163.83 KB, application/pdf)
2013-04-09 04:18 UTC, HD
no flags Details
Sample to reproduce. (14.87 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-09 04:19 UTC, HD
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description HD 2013-04-09 04:18:18 UTC
Created attachment 80510 [details]
Screen shots of Steps To Reproduce.

[Procedure for reproducing]

1. Start Calc.
2. Input numeric values to cells A1:B10.
3. Set format codes of B1:B10 to "0.000;[RED]-0.000".
4. Select cells B1:B10, click "ChartWizard" and "Finish" it without change. (Any of these charts will do.)
5. Set format codes of A1:A10 to "0.000" .
6. Save and close the Calc.
7. Open the file again.
8. Format codes of A1:A10 are return to "Standard" from "0.000".


[In case of format codes are return to "Standard".]
--------------------------------------------------------
Format code of A1:A10		|  Format code of B1:B10
--------------------------------------------------------
0.000;[RED]-0.000		|  0.000
0.000;[RED]-0.0000		|  0.000
0.0000;[RED]-0.000		|  0.0000
0.000;[BLUE]-0.000		|  0.000
0.0000000000;[RED]-0.000	|  0.0000000000
0.000;-0.0000		|  0.000
#.0;[RED]-0.0		|  #.0
------------------------------------------------


[In case of format doesn't change.]
--------------------------------------------------------
Format code of A1:A10		|  Format code of B1:B10
--------------------------------------------------------
0.000;[RED]-0.000		|  0.00
0.00;[RED]-0.00		|  0.000
0.000;[RED]-0.000		|  0.0
0.000000000;[RED]-0.000	|  0.0000000000
0.0000;[RED]-0.000		|  0.000
#.0;[RED]-0.000		|  0.000
0.000;[RED]-0.000		|  0.000;-0.000
--------------------------------------------------------

From the above, 
format of cell which has same setting as base data of graph and format code specified only for positive number part 
is return to "Standard" when format code of data cell that referenced by the graph are;

- More than 3 decimal places and using "0" after the decimal point.
- Using "#".

I attached problem sample files. Please read these. 

Sincerely.
Comment 1 HD 2013-04-09 04:19:09 UTC
Created attachment 80511 [details]
Sample  to reproduce.
Comment 2 Edwin Sharp 2013-04-10 17:18:05 UTC
Thank you for a wonderful bug description!

Confirmed on Rev. 1458754 Debian.
Without chart - format is preserved.
Applying chart on A1:A10 - format is also preserved.