Bug 44763 - Cell styles with localized names, in Pivot Table, replaced with en-US named styles, if pivot changed in en-US UI
Summary: Cell styles with localized names, in Pivot Table, replaced with en-US named s...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 113484 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2012-01-13 14:03 UTC by famo
Modified: 2023-07-21 05:04 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with a PivotTable, which was saved under english and german locale (11.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-16 07:30 UTC, famo
Details
Pivot Table test file (14.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-10-04 14:02 UTC, Robert Gonzalez MX
Details
Step 1 screenshoot (162.06 KB, image/png)
2015-10-04 14:03 UTC, Robert Gonzalez MX
Details
step 2 screenshoot (160.70 KB, image/png)
2015-10-04 14:03 UTC, Robert Gonzalez MX
Details
Step 3 screenshoot (156.02 KB, image/png)
2015-10-04 14:04 UTC, Robert Gonzalez MX
Details
Step 4 screenshoot (157.09 KB, image/png)
2015-10-04 14:05 UTC, Robert Gonzalez MX
Details
step 5 screenshoot (165.99 KB, image/png)
2015-10-04 14:05 UTC, Robert Gonzalez MX
Details
Test Pivot table ES to EN (66.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-10-04 14:06 UTC, Robert Gonzalez MX
Details

Note You need to log in before you can comment on or make changes to this bug.
Description famo 2012-01-13 14:03:49 UTC
The Pivot Table / DataPilot styles, which are automatically created upon DataPilot creation, are not localized / translated.

This means if a DataPilot document is interchanged with a user at a different user interface language, custom DataPilot style settings are lost and DataPilot styles get duplicated.


How to reproduce:
1. Create Calc document with DataPilot.
2. Choose a DataPilot styles and change one of the settings (e.g. change font color).
3. Save and close document.
4. Go to Tools -> Options - Language Settings and change the User Interface language.
5. Close LO and restart.
6. Open formerly saved document with the DataPilot.
7. Open Styles (F11) and notice the names of the styles didn't change and don't fit to your current user interface.
8. Right click somewhere in the DataPilot and choose "Refresh" from the context menu.
9. Notice:
 a) your custom style setting is lost
 b) in Styles is now a new ("duplicate") set of DataPilot styles which names fit to your user interface language.
Comment 1 famo 2012-01-13 14:07:58 UTC
See also bug 44762 (DataPilot naming of styles and request for more styles)
Comment 2 sasha.libreoffice 2012-05-08 03:32:05 UTC
Thanks for bugreport
Please, attach document that demonstrates this problem
Comment 3 famo 2012-05-16 07:30:10 UTC
Created attachment 61716 [details]
Spreadsheet with a PivotTable, which was saved under english and german locale

(In reply to comment #2)
> Thanks for bugreport
> Please, attach document that demonstrates this problem

HTH
Comment 4 sasha.libreoffice 2012-05-16 22:37:19 UTC
Thanks for attachment
Reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit
Steps to reproduce:
0. Open attachment
1. Enable Stylist pane
Expected: All styles are with current UI language
Actually: One half is on German, other half on English
2. Modify some German named style, for example Datenpilot Titel, change cell background
3. Right click somewhere in the DataPilot and choose "Refresh" from the context
menu.
Expected: DataPilot formatting remains unchanged, no additional styles appear
Actually: DataPilot formatting lost, some additional styles appear

Changing version to 3.3.4 as most early reproducible
Comment 5 sasha.libreoffice 2012-05-16 22:40:29 UTC
@ Andras
What do You think about this bug?
Comment 6 Kohei Yoshida 2013-01-08 15:57:55 UTC
This has one gotcha.  First of all, I have these pivot table styles and I would LOVE to get rid of them.  But besides that, if we ever decide to keep them for the time being and decide to translate them, then we'd have to make sure that the implementation would continue to use the non-translated versions.  Or else it would break if the document is shared between different locales.
Comment 7 famo 2013-01-10 11:42:58 UTC
Regarding your new idea/proposal on pivottable design, I replied in the other bug 44762.

Regarding this one:
I don't quite get your comment:
(In reply to comment #6)
> But besides that, if we ever decide to keep them for the time being and decide
> to translate them, then we'd have to make sure that the implementation would
> continue to use the non-translated versions.
AFAIK, the style-names are already translated, as they are available in every locale.
Second, there is already an "engine" for style-translation which applies to all other styles (Default, Result, Heading, etc.).

So my question is, why is this "engine" not apllied to the pivot-table stles?
Wouldn't this be the simplest solution (for the time beeing)?


> ... Or else it would break if the document is shared between
> different locales
The current implementation *IS ALREADY* broken, when shared between different locales, so no worry about breaking things ;-) ...
Comment 8 Kohei Yoshida 2013-01-10 14:13:12 UTC
(In reply to comment #7)
> Regarding your new idea/proposal on pivottable design, I replied in the
> other bug 44762.
> 
> Regarding this one:
> I don't quite get your comment:
> (In reply to comment #6)
> > But besides that, if we ever decide to keep them for the time being and decide
> > to translate them, then we'd have to make sure that the implementation would
> > continue to use the non-translated versions.
> AFAIK, the style-names are already translated, as they are available in
> every locale.
> Second, there is already an "engine" for style-translation which applies to
> all other styles (Default, Result, Heading, etc.).
> 
> So my question is, why is this "engine" not apllied to the pivot-table stles?
> Wouldn't this be the simplest solution (for the time beeing)?

You are asking the wrong guy.  I didn't design it, so no idea "why".  Maybe you can see if that's indeed the simplest solution.  Do you need a code pointer for this?

> > ... Or else it would break if the document is shared between
> > different locales
> The current implementation *IS ALREADY* broken, when shared between
> different locales, so no worry about breaking things ;-) ...

That's lame.  It's already broken, so who cares if you break a little more doesn't give me confidence.
Comment 9 Kohei Yoshida 2013-01-10 14:16:43 UTC
(In reply to comment #8)

> > > ... Or else it would break if the document is shared between
> > > different locales
> > The current implementation *IS ALREADY* broken, when shared between
> > different locales, so no worry about breaking things ;-) ...
> 
> That's lame.  It's already broken, so who cares if you break a little more
> doesn't give me confidence.

And that's even another reason why we should get rid of this.  It's broken beyond repair.
Comment 10 famo 2013-01-16 18:54:20 UTC
(In reply to comment #8)
> (In reply to comment #7)
> > Second, there is already an "engine" for style-translation which applies to
> > all other styles (Default, Result, Heading, etc.).
> > 
> > So my question is, why is this "engine" not apllied to the pivot-table stles?
> > Wouldn't this be the simplest solution (for the time beeing)?
> 
> You are asking the wrong guy.  I didn't design it, so no idea "why".

You wrote: "I have these pivot table styles", so I thought you might know this. Also this was meant as a constructive question. I'm not trying to blame anyone for this history-grown code - sorry if it sounded otherwise.


> Do you need a code pointer for this?

I'm user doing some Q&A, I have no experience whatsoever with the LO-code. However if you think it is worth/promising to try - sure go ahead.
Another option might be to name me the "right" guy (if you know) and I will try to contact & point him to this bug. Maybe he can give some useful insights.


> > The current implementation *IS ALREADY* broken, when shared between
> > different locales, so no worry about breaking things ;-) ...
> 
> That's lame.  It's already broken, so who cares if you break a little more
> doesn't give me confidence.

Judging from your comment #6 one could get the impression, that by trying to fix this, things might broke which worked before. I just wanted to clarify this, also notice the smiley.
Comment 11 Kohei Yoshida 2013-01-16 19:03:27 UTC
(In reply to comment #10)
> (In reply to comment #8)
> > (In reply to comment #7)
> > > Second, there is already an "engine" for style-translation which applies to
> > > all other styles (Default, Result, Heading, etc.).
> > > 
> > > So my question is, why is this "engine" not apllied to the pivot-table stles?
> > > Wouldn't this be the simplest solution (for the time beeing)?
> > 
> > You are asking the wrong guy.  I didn't design it, so no idea "why".
> 
> You wrote: "I have these pivot table styles", 

That's a typo. I HATE is what I meant to type.

> Judging from your comment #6 one could get the impression, that by trying to
> fix this, things might broke which worked before.

Yes. You could say that.

In short, 

1) This mis-feature is broken by design, and as it stands today, it already causes issues in several areas which cannot be fixed without removing this mis-feature.
2) No point improving it because of 1).
Comment 12 Kohei Yoshida 2013-01-16 19:09:52 UTC
If I can expand on this a little.

In the future we should remove this and implement much more flexible custom cell properties inside pivot table, combined with some sort of predefined styles that can be applied per table.  The current system allows uniform styles to ALL tables, which isn't extensible, conflicts with these new proposed features, not to mention it causes severe interop problems.
Comment 13 QA Administrators 2015-06-08 14:42:09 UTC Comment hidden (obsolete)
Comment 14 Robert Gonzalez MX 2015-10-04 14:01:48 UTC
Hi.
I confirm that this bug is still present on Versión: LO 5.0.2.2
Id. de compilación: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Configuración regional: es-MX (es_MX)on Win 10

I was going to file a bug about this, but found this one that is exactly what I am experiencing.

I'm adding screenshoots and a test file. 
This bug is reproducible changing the user interface form English to Spanish or Spanish to English.

After changing the user interface and opening the file, the pivot table is not refreshed and the filter drop down menu is not activated, this is related to te bug 84425, after clicking in the category field, the pivot table is refreshed, new styles appear and the formatting changes.
Comment 15 Robert Gonzalez MX 2015-10-04 14:02:44 UTC
Created attachment 119265 [details]
Pivot Table test file
Comment 16 Robert Gonzalez MX 2015-10-04 14:03:23 UTC
Created attachment 119267 [details]
Step 1 screenshoot
Comment 17 Robert Gonzalez MX 2015-10-04 14:03:51 UTC
Created attachment 119268 [details]
step 2 screenshoot
Comment 18 Robert Gonzalez MX 2015-10-04 14:04:20 UTC
Created attachment 119269 [details]
Step 3 screenshoot
Comment 19 Robert Gonzalez MX 2015-10-04 14:05:16 UTC
Created attachment 119270 [details]
Step 4 screenshoot
Comment 20 Robert Gonzalez MX 2015-10-04 14:05:48 UTC
Created attachment 119271 [details]
step 5 screenshoot
Comment 21 Robert Gonzalez MX 2015-10-04 14:06:50 UTC
Created attachment 119272 [details]
Test Pivot table ES to EN
Comment 22 Robert Gonzalez MX 2015-10-05 04:27:27 UTC
I've tested it on OOO 3.2.1 and the problem is present and reproducible, also tested it in A00 4.1.1 and is alo present and reproducible.
Comment 23 QA Administrators 2017-10-23 14:02:30 UTC Comment hidden (obsolete)
Comment 24 Cor Nouws 2017-10-27 14:32:33 UTC
Ah well, why should one try to make sure the summary reflects the bug ? :\
Comment 25 Cor Nouws 2017-10-27 14:32:57 UTC
*** Bug 113484 has been marked as a duplicate of this bug. ***
Comment 26 QA Administrators 2019-03-21 03:49:52 UTC Comment hidden (obsolete)
Comment 27 QA Administrators 2021-03-21 04:17:42 UTC Comment hidden (obsolete)
Comment 28 Robert Gonzalez MX 2021-03-22 01:10:49 UTC
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.
Comment 29 QA Administrators 2023-03-23 03:24:02 UTC Comment hidden (obsolete)
Comment 30 kelseyradley 2023-07-07 02:23:25 UTC Comment hidden (spam)