Issue 127274 - Style containing scientific notation changed on open after save
Summary: Style containing scientific notation changed on open after save
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.3
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-01-05 22:10 UTC by macronx
Modified: 2017-01-08 20:39 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.