https://bugs.documentfoundation.org/show_bug.cgi?id=64145
--- Comment #28 from Laurent BP <[email protected]> ---
For what I can understand:
Excel do not have subtitle field, but only a title field. When saving to Excel
format, the trick is to add the subtitle to the title with a '\n'. See
http://opengrok.libreoffice.org/xref/core/sc/source/filter/excel/xechart.cxx#ConvertTitle
Actually it does not work for XLSX, but only for XLS. See bug 101322
During save to XLSX, the XML representation of the chart is recreated, and a
<chart:subtitle ...> is accidentally created empty. If you save to Excel
format, then this field will be lost. Unfortunately, if you copy/paste this XML
code in Calc or Writer, or if you resaved to ODF format, the field is
preserved. A subtitle is detected and a dummy text is added for initialization
("sub-title") and never replaced as chart:subtitle is empty.
So, I see two problems:
- <chart:subtitle ...> should not be created when exporting to XLSX
- subtitle should be removed if <chart:subtitle...> contains no text
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
