[Libreoffice-bugs] [Bug 117043] PIVOT TABLE: refresh bug

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Julien ROPE <jrope at linagora.com> ---

 Hi,

 I've been working with rking on this issue, and I'd like to add some context.

 I understand how pivot table styles are applied - I looked at the source code
and understand how Calc is looking for styles based on their name, and apply
them when the table is created/refreshed.

 The problem is not about applying custom styles. The default styles were used,
and edited to have the expected look.
 The problem is that this was done with an earlier version of LibreOffice
(5.2), and then opened in 5.4.

 What happens is that the translations for the LibreOffice pivot styles (in
French) have been modified in 5.3, and then again in master.
 See for example the "Pivot Table Value" translation history here :
https://translations.documentfoundation.org/fr/libo54_ui/translate/sc/source/ui/src.po#search=PIVOT&sfields=source,target&unit=130435809&offset=0

 Then Calc is now looking for default styles with a different name than those
found in the document. Since it doesn't find them, it re-creates them with the
new name, completely empty. Those new styles are then applied, and the user see
the styles disappear.

 Looking for a hard-coded string is causing the problem: whenever the string
changes (for a typo, or a translation), you loose everything.

 NOTE: it is similar to the bug described here
(https://bugs.documentfoundation.org/show_bug.cgi?id=44763), except we're not
moving the document between different locales environments, but from one
version of LibreOffice to another.

 From a user's standpoint, without creating any custom styles, this really
looks like a bug.

 I understand the problem is not an easy one and won't have an easy fix. But is
there a way to fix this bad reference in a document (other than manually
renaming each style in every document)?
 Something we could apply as a batch on all existing documents for instance ?

-- 
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/20181105/0e799ae3/attachment.html>