https://issues.apache.org/ooo/show_bug.cgi?id=122020
Bug ID: 122020
Issue Type: DEFECT
Summary: Format modifications are return to "Standard" in spite
of change format of cells and save it in Calc.
Classification: Application
Product: Calc
Version: AOO 3.4.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 80510
--> https://issues.apache.org/ooo/attachment.cgi?id=80510&action=edit
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
