After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 616262 - XLS: chart titles are missing
XLS: chart titles are missing
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: import/export MS Excel (tm)
git master
Other Linux
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2010-04-20 08:37 UTC by Konstantin Tokarev
Modified: 2010-04-22 08:39 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
File which is imported incorrectly (81.50 KB, application/octet-stream)
2010-04-20 08:39 UTC, Konstantin Tokarev
Details

Description Konstantin Tokarev 2010-04-20 08:37:54 UTC
In attached document Gnumeric doesn't display titles in charts. Also, it contains links to cells from another file, and Gnumeric displays them as links to the same file, which is misleading. 

Without Excel, you can open this file in OpenOffice.org Calc to see how it should look. Also, some points in the document have labels (don't know, if Gnumeric support them at all)
Comment 1 Konstantin Tokarev 2010-04-20 08:39:10 UTC
Created attachment 159143 [details]
File which is imported incorrectly
Comment 2 Jean Bréfort 2010-04-21 07:27:26 UTC
I confirm the titles issue. For the external links, please file another bug report, this is unrelated.
Gnumeric does not support data labels in charts for now. This is #164484. It is high in my priorities, but time is somehow missing.
Comment 3 Jean Bréfort 2010-04-21 13:11:20 UTC
I do not understand the contents of this file. It has chart titles, but they seem empty. What did generate that?
Comment 4 Konstantin Tokarev 2010-04-21 13:31:08 UTC
They are not empty. Did you open it in OOo of Excel?
Comment 5 Jean Bréfort 2010-04-21 14:10:16 UTC
I did open with OOo, but still there is no data. Looks like there is a default behavior which consts to use the series label in that case. I need to experiment with xl, but no chance this occurs before next week.
Comment 6 Konstantin Tokarev 2010-04-21 14:41:10 UTC
Original document has chart titles such as 'C2=2C', 'C2H6=2C+6H' etc. OOo 3.1.1 shows them.
Comment 7 Jean Bréfort 2010-04-21 15:02:13 UTC
Yes, I see that too, but the data associated in the file with the title has 0 length.
Comment 8 Andreas J. Guelzow 2010-04-21 15:53:40 UTC
Djusting the tielt since the link issue was also viled as bug #616378.
Comment 9 Andreas J. Guelzow 2010-04-21 15:55:47 UTC
Apparently I can't type or spell or read. The last comment was supposed to be:

Adjusting the title since the link issue was also filed as bug #616378.
Comment 10 Andreas J. Guelzow 2010-04-21 15:57:54 UTC
Konstantin, please answer answer the question from Comment #9: Which program generated this file initially?
Comment 11 Andreas J. Guelzow 2010-04-21 16:02:52 UTC
Some more observation: If you open the file with OOo, save it again as an xls file, and then open it in gnumeric the titles are present.
Comment 12 Konstantin Tokarev 2010-04-21 16:17:32 UTC
It was generated by Excel
Comment 13 Jean Bréfort 2010-04-21 17:02:27 UTC
Found after testing with a few xls samples that Excel automagically uses the unique series label as title.

This problem has been fixed in our software repository. The fix will go into the next software release. Thank you for your bug report.
Comment 14 Konstantin Tokarev 2010-04-22 08:39:49 UTC
It works, thanks!