Issue 81279 - Wrong number format exported
Summary: Wrong number format exported
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 2.3.0 RC1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-05 10:17 UTC by bjoern.milcke
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Bugdoc (7.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-09-05 10:19 UTC, bjoern.milcke 		no flags Details
How the saved file looks (1.96 KB, image/png)
2007-09-05 10:19 UTC, bjoern.milcke 		no flags Details
How the re-loaded file looks (1.91 KB, image/png)
2007-09-05 10:20 UTC, bjoern.milcke 		no flags Details
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 bjoern.milcke 2007-09-05 10:17:59 UTC 
1. Load the attached document
2. Copy the fraction format from C6 to C5
3. Save the document
4. Reload
=> The "1/2" is converted to "12:00:00"

Looking at the file, as the number for 12 o'clock is 0.5 and 1/2 is also 0.5,
the cell with the time is just repeated (number-columns-repeated="2") ignoring
the different number format. However it is still strange that the "PM" is
missing after loading.
Comment 1 bjoern.milcke 2007-09-05 10:19:24 UTC 
Created attachment 47967 [details]
Bugdoc
Comment 2 bjoern.milcke 2007-09-05 10:19:57 UTC 
Created attachment 47968 [details]
How the saved file looks
Comment 3 bjoern.milcke 2007-09-05 10:20:33 UTC 
Created attachment 47969 [details]
How the re-loaded file looks
Comment 4 anational 2007-10-30 13:07:47 UTC 
I think this may be a duplicate of 
http://www.openoffice.org/issues/show_bug.cgi?id=29101

Time appears to be stored as a double in fValue in the exporter, as with those
issues.
Comment 5 Martin Hollmichel 2007-11-09 16:51:45 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 6 Marcus 2017-05-20 11:11:32 UTC 
Reset assigne to the default "issues@openoffice.apache.org".