| Summary: | FILESAVE: Title appears in chart when saving in .xlsx | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Stéphane Guillou (stragu) <stephane.guillou> |
| Component: | Chart | Assignee: | Markus Mohrhard <markus.mohrhard> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | barta, lukebenes, stephane.guillou |
| Priority: | medium | ||
| Version: | 4.1.5.3 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=64145 https://bugs.freedesktop.org/show_bug.cgi?id=82216 https://bugs.documentfoundation.org/show_bug.cgi?id=119138 |
||
| Whiteboard: | BSA target:4.3.0.2 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 75057 | ||
| Attachments: |
Example spreadsheet with a chart showing the bug
ods file to test this bug |
||
tested under Win7x32 using LibO 4.2.3.3 I confirm that if you remove the title "values" from the chart in the attached .xlsx and you save and reload the title comes back. It would however important that you upload the original .odt so we can reproduce the issue about title "appearance" after saving a titleless chart from .odt to .xlsx Created attachment 98476 [details]
ods file to test this bug
Here is the original ods file with a chart without a title. Saving it in xlsx format will make a title appear when opened next.
I think it is also important to note that I have come accross this issue with charts I created with LO in an xlsx file that was created with Microsoft Excel.
confirmed under Win7x64 using LibO 4.2.3.3 It is an import and not an export problem. The exported document does not contain the title so seems like we mess this up during import. The bot has some connection troubles so here are the commits for this bug in master: http://cgit.freedesktop.org/libreoffice/core/commit/?id=113866583c5a34b9242aeb9040c4ce80e65da1ba http://cgit.freedesktop.org/libreoffice/core/commit/?id=2f74e52a6efe7a51d6575cbb9b5f30b1ad99ee7c Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e07eedd38062edfbe4998946b75f1a3d958e9615&h=libreoffice-4-3 use the correct default value, fdo#78080 It will be available in LibreOffice 4.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |
Created attachment 98181 [details] Example spreadsheet with a chart showing the bug Problem description: Steps to reproduce: 1. Create a dummy data sequence with a name for it at the beginning of the sequence (in the same column) 2. Select the whole thing (name + sequence) 3. Plot it and keep the defaults 4. Save the document as an xlsx, and save it as and ods too 5. Close the document and open both saved versions Current behavior: The xlsx version adds a title with the name of the sequence, whereas the ods version stayed the same (no title) Expected behavior: Saving in xlsx format should not add a title to the chart without the user deciding to do so. You can also try with the attached documents. Getting rid of the title does not fix it, it comes back the next time you open the document. Saving in xls format does not result in that bug. Operating System: Ubuntu Version: 4.1.5.3 release