Issue 127274

Summary:	Style containing scientific notation changed on open after save
Product:	Calc	Reporter:	macronx
Component:	formatting	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P5 (lowest)	CC:	oooforum
Version:	4.1.3
Target Milestone:	---
Hardware:	PC
OS:	Windows 10
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description macronx 2017-01-05 22:10:56 UTC

1) Create new spreadsheet
2) Create style with custom format code of 0.0e-0
3) Save and close
4) Open spreadsheet
5) Style format code will be 0.0E+0 (i.e., changed)

Note: the same issue occurs if you apply the format directly (no style)

Comment 1 oooforum (fr) 2017-01-06 08:46:07 UTC

What kind of format did you expect with this notation?

Comment 2 macronx 2017-01-07 14:08:57 UTC

(In reply to oooforum (fr) from comment #1)
> What kind of format did you expect with this notation?

Desired:

+1E+6 => 1.0e6
+1E-6 => 1.0e-6
-1E+6 => -1.0e6
-1E-6 => -1.0e-6

Which works as expected, but after a save/open it reverts back to 0.0E+6

After save and open:

+1E+6 => 1.0E+6
+1E-6 => 1.0E-6
-1E+6 => -1.0E+6
-1E-6 => -1.0E-6

Comment 3 macronx 2017-01-08 20:39:19 UTC

This appears due to be to a "deficiency" in the ODF specification. As far as I can tell, the formatting of scientific notation does not store case of the 'E' or the sign of the exponent.

If so, it probably should be moved to the appropriate issue section.