GNOME Bugzilla – Bug 736656
Axis format does not roundtrip through xls
Last modified: 2014-09-19 05:42:09 UTC
There seems to be no right "edge" of the worksheet, so no amount of hovering will produce a scrollbar. The horizontal scrollbar does appear after hovering, but no right, vertical scrollbar. Seems to have changed (as did Gnumeric), once I updated the OS to 14.04. Gnumeric is 1.12.9. I have several dates in a graph on a page which now have an X-axis displayed as 5 digit numbers after the upgrade. When I correct them to a date format and apply it, the format changes...but the next time I reopen the spreadsheet (after saving it), the number format is back. Thankyou!
The first is a Ubuntu problem. Please file a report there -- we cannot control how they choose to break applications. For the second, please attach an example.
In which file format are you saving your file?
Created attachment 286216 [details] This is the problem. x-axis fails to retain date formatting when saved
It is saved as an XLS file...since I started this 7.8mb file in Excel many years ago. I will attach screenshots of the date issue, but it is simply that it seems to save the x-axis as a 5 digit numeric date (like Lotus used to do). I change it to mm/dd/yy, apply it, and it will not keep it. After I save and close the file with the Save command, the next time I open up the file, the date has reverted to the 5 digit numeric display as the formatting seems to not have been saved.
Created attachment 286217 [details] What should be saved---the date format This is the correction to the date format that I keep making, applying, and saving...but it reverts to the 5 digit number every time I reopen the file.
I am changing the component. This problem is likely somewhere between Excel import/export and charting.
Created attachment 286250 [details] sample file round trip through xls drops the format of the labels of the x-axis
This appears to be an export problem. The file produced by ./ssconvert -T Gnumeric_Excel:excel_biff8 ~/Download/Book1.gnumeric ~/af.xls does not give a formatted x axis when loaded into Excel. When I add a format in Excel, we load it correctly.
We do not save the format to xls. I have a patch but it needs some more work. I made some tests with LO, and it looks like we have problems when loading an xls file saved by LO. Looks like the chart is loaded but not attached to the sheet, and then it leaks. Another point is that LO uses the cell format as default but we do not have that option.
> Another point is that LO uses the cell format as default but we do not > have that option. We don't have that in the gui, but don't we have the fmt==NULL in the code with the same meaning?
Seems that we just don't have, or I'm missing the obvious.
Created attachment 286501 [details] [review] Proposed patch Looks a bit dirty but works.
Looks fine to me.
This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.
Thank YOU for the speedy resolution!