GNOME Bugzilla – Bug 355943
Time values imported from OO.org Calc .ods files are interpreted as labels
Last modified: 2006-09-15 13:15:42 UTC
Please describe the problem: Time values imported from OO.org Calc .ods files are interpreted as labels. This causes them, for example, to be displayed left-justified, and may affect calculations involving these cells. Typing the same time values replaces the cell contents with "native" time values, which are right-justified. This indicates an inconsistency between Gnumeric's handling of time values imported from OO.org Calc's .ods files and its own rendering of .ods files. Steps to reproduce: 1. Create a spreadsheet in OO.org Calc 2.0.3 with time values (e.g. in a variety of time formats) 2. Save the spreadsheet in the native .ods format 3. Open the file in Gnumeric Actual results: The imported time values are prefixed by the ' character. Expected results: ... for the times to be imported as values, not as labels. Does this happen every time? Yes Other information:
Could you attach a sample, please?
Created attachment 72782 [details] Sample .ods file created with OO.org Calc 2.0.3 Here's a sample .ods file (created with OO.org Calc 2.0.3) that exhibits the behaviour.
Ok, thanks. Confirmed.
Fixed in the development version. The fix will be available in the next major release. Thank you for your bug report. Three problems: 1. The syntax changed from "table:time-value" in old OO to "office:time-value" in ods. 2. The code imported things 24 times too big. 3. The code was not accurate enough to my tastes.
Congratulations! That was an amazingly quick fix. It makes me pleased to have taken the time to report the bug -- and grateful to be a user of Gnumeric. Out of interest: is the patch too intrusive to go into a minor 1.7.x release?
The patch is tiny and is already in what will become 1.7.1 some day.