[Libreoffice-bugs] [Bug 44763] Cell styles with localized names, in Pivot Table, replaced with en-US named styles, if pivot changed in en-US UI

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=44763

--- Comment #28 from Robert Gonzalez MX <ggrc670 at gmail.com> ---
Tested with Version: 7.1.1.2 / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: es-MX (es_MX.UTF-8); UI: es-ES
Calc: threaded

The first thing I did was create a new file and copy the raw data from the 2015
test file with the Spanish UI.

Then I made a new pivot table to review the styles.

I modified the background color of the pivot table styles, to see if those
properties were lost, when changing the UI. I saved the file.

I changed the UI to English and restarted LibreOffice, reloaded the file and
noticed that the colors were kept and the styles were renamed to their
respective English without affecting the pivot table. I saved the file.

I changed the UI back to Spanish and opened the file again and there were no
impacts. The styles had their respective names in Spanish.

>From the above, I could say that this bug is already resolved, however, I
decided to review the 2015 test file.

When testing with the original test file from 2015, with the UI in Spanish, the
pivot table styles were linked to the English names Data Pilot XXX and there
were also the names in Spanish.

DataPilot Category
DataPilot Corner
DataPilot Field
DataPilot Result
DataPilot Title
DataPilot Value

I modified the styles to add background color to them and saved the file.
I changed the UI to English and opened the file, the colors remained intact.
When reviewing the styles were the above and the following:

Pivot Table Category
Pivot Table Corner
Pivot Table Field
Pivot Table Result
Pivot Table Title
Pivot Table Value

I opened the properties of the pivot table and clicked OK and the styles were
updated to "Pivot Table XXXX" losing color.

Again I modified the styles to add background color to them, saved the file and
changed UI to Spanish.

I opened the file again and the styles were updated to Spanish without
affecting the pivot table. The previous “DataPilot XXX” styles were still
there, but no longer assigned.

I removed them without affecting the file.

>From the above, I could say that this bug is already solved, however, all
tables created with previous versions must be updated.

I do not update the status, for someone else to test and verify it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210322/64f6a114/attachment.htm>