Bug 104249 - Pie charts created in Writer - data labels format settings reset upon opening a saved and closed .docx file
Summary: Pie charts created in Writer - data labels format settings reset upon opening...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:docx
Depends on:
Blocks:
 
Reported: 2016-11-29 09:28 UTC by laughswith
Modified: 2018-12-10 16:04 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
This is how the default setting for the data labels in the pie chart looks like when I reopen the file. (23.80 KB, image/jpeg)
2016-11-29 10:28 UTC, laughswith
Details
Made a test document, where I inserted data labels, formatted the labels to be bold and white and show percentage without two decimals (5.09 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2016-12-03 00:43 UTC, laughswith
Details
Screenshot of an example file in Writer master and Word (102.02 KB, image/png)
2018-12-10 15:49 UTC, Gabor Kelemen (allotropia)
Details
Example odt from LO 6.3 master (15.55 KB, application/vnd.oasis.opendocument.text)
2018-12-10 15:52 UTC, Gabor Kelemen (allotropia)
Details
The example file saved as docx from LO 6.3 master (5.43 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2018-12-10 15:54 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description laughswith 2016-11-29 09:28:47 UTC
Description:
I'm working on page 26 of a document that will most likely surpass 50 pages.

I format data labels for the pie charts, save the settings, then at some point close the .docx file after a day's work. Every time I open the saved document to progress further, I need to reformat every pie chart because the data labels have been reset and have defaulted to original settings.

Disappointed that my formatting changes have been reset, I have to reformat the pie charts every time I open the .docx file to progress further. I have to right click and click on "Format Data Labels."
Then click on the "Font" tab to click on "Bold" for a Typeface that has been reset to "Regular."

In the same data label formatting window, I need to click on the "Font Effects" tab to select the different "Font Color" I specified from the default setting of "Black."

Thirdly, in the same data label formatting window, I need to click on the "Data Labels" tab, click on "Percentage format..." to uncheck "Source format" so that I can select the percentage format to be whole numbers ("-13%" is the example given) instead of going by the default percentage format with two decimals spaces after ("-12.95%" is the example given).

I save the settings, work on the file some more, then close it after a satisfying day's work -- only to find upon reopening the file that the data labels on the pie charts have reverted to original settings and I have to go in there again.

To say that this is exasperating is an understatement, as I have been working on this document for the past two weeks, adding to it on a more or less daily basis. 

I hope you can come up with a fix for this bug in time for me to complete this report.

Actual Results:  
Data label formatting of pie charts reset to original settings, even after formatting in the .docx file has been saved. Upon opening the .docx file, I have to go in there every time to reformat the data labels to the pie charts.

Expected Results:
I would expect that after I have saved the settings that upon reopening the .docx file I would be able to see that the formatting of the data labels for the pie charts would remain saved.


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.98 Safari/537.36
Comment 1 Xisco Faulí 2016-11-29 10:15:48 UTC
Hello,

Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 laughswith 2016-11-29 10:28:02 UTC
Created attachment 129107 [details]
This is how the default setting for the data labels in the pie chart looks like when I reopen the file.
Comment 3 Buovjaga 2016-12-02 19:39:17 UTC
Attach the actual document, not a screenshot.

Setting back to NEEDINFO.
Comment 4 laughswith 2016-12-03 00:43:15 UTC
Created attachment 129267 [details]
Made a test document, where I inserted data labels, formatted the labels to be bold and white and show percentage without two decimals

After saving the document as a .docx, I reopened the file and sure enough everything is back to the default format of black font, regular (not bold) text, and the percentages were showing with two decimal places. Although my data was saved, none of my formatting prior to saving the document was saved.
Comment 5 Buovjaga 2016-12-03 19:17:20 UTC
(In reply to laughswith from comment #4)
> Created attachment 129267 [details]
> Made a test document, where I inserted data labels, formatted the labels to
> be bold and white and show percentage without two decimals
> 
> After saving the document as a .docx, I reopened the file and sure enough
> everything is back to the default format of black font, regular (not bold)
> text, and the percentages were showing with two decimal places. Although my
> data was saved, none of my formatting prior to saving the document was saved.

Repro.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.2.3.3
Build ID: 5.2.3-1
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group

Arch Linux 64-bit, KDE Plasma 5
Version: 5.4.0.0.alpha0+
Build ID: 8a238809ba861c810304354f01a5504d43111399
CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on December 2nd 2016
Comment 6 QA Administrators 2017-12-04 09:53:46 UTC Comment hidden (obsolete)
Comment 7 Gabor Kelemen (allotropia) 2018-12-10 15:49:52 UTC
Created attachment 147423 [details]
Screenshot of an example file in Writer master and Word

https://cgit.freedesktop.org/libreoffice/core/commit/?id=6a04b9298ae993881d20fc4b5aa91516d4df6695 
did help a lot with this one
Comment 8 Gabor Kelemen (allotropia) 2018-12-10 15:52:34 UTC
Created attachment 147424 [details]
Example odt from LO 6.3 master

This has custom font (Lucida Console), font size (15pt), font style (Bold), font color (purple), single strikethrough, single red underline set for the data series label.
Comment 9 Gabor Kelemen (allotropia) 2018-12-10 15:54:12 UTC
Created attachment 147425 [details]
The example file saved as docx from LO 6.3 master

As far as I see, the docx export contains all of the above data series font formatting.
Comment 10 Gabor Kelemen (allotropia) 2018-12-10 16:04:13 UTC
Let's say WFM, maybe this could be set as a duplicate for bug #121279 too.