Created attachment 136652 [details] sheet with pivot table and pivot chart Open attached file and save it to strict ODF 1.2. The resulting file has in Object 1 (which is the chart) the invalid attribute "data-pilot-source". When saving to strict ODF 1.2. not only the namespace loext has to be removed, but the entire attribute. The same kind of error is with attributes "value-type" (bug ?) in a table-cell and "repeat-item-labels" (bug 112484) in data-pilot-level in content.xml. But that errors exists before and are not introduced with the new feature "pivot charts". I have used Version: 6.0.0.0.alpha0+ Build ID: 499194508c8cf91fbbc21f882bcf4ace77e19eaa CPU threads: 4; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-09-30_06:14:26 Locale: de-DE (de_DE); Calc: group
I saved it as ODF 1.2, unzipped, went to Object 1 folder and examined all the .xmls. I was unable to find data-pilot-source in any of them. Arch Linux 64-bit, KDE Plasma 5 Version: 6.0.0.0.alpha1+ Build ID: fff7097f1ed8493de099d79aa0613ea6b309100a CPU threads: 8; OS: Linux 4.13; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on November 2nd 2017
No repro here, either. I assume Load/Save -> General -> ODF format version has to be set to 1.2 for testing this, right? Version: 6.0.0.0.alpha1+ Build ID: 8ce49eab696d830d420fbf48b22ac151167bbd62 CPU threads: 4; OS: Windows 6.1; UI render: default; TinderBox: Win-x86@42, Branch:master, Time: 2017-11-03_23:12:37 Locale: en-US (en_US); Calc: CL
(In reply to Aron Budea from comment #2) > No repro here, either. I assume Load/Save -> General -> ODF format version > has to be set to 1.2 for testing this, right? That is correct.
Created attachment 137526 [details] The original file with the pivot chart My fault. I have uploaded the result, not the original file. The new, correct file contains a pivot chart. A pivot chart is not only connected to the pivot table, but the chart itself has filter buttons. After saving in ODF 1.2 format, the chart is no longer a pivot chart, because the feature is not available in ODF 1.2 strict, but it is a LO extension. Please try the steps again with the new file.
Yes, reproducible now.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
The error still exists in Version: 6.2.0.0.alpha1+ (x64) Build ID: e33424dd887cb1a11a3dba2513ef0f4bf93a6dbe CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2018-11-01_00:43:29 Locale: de-DE (en_US); Calc: CL
On pc Debian x86-64 with master sources updated today, I could reproduce this. Relevant part of the assert: #4 0x00007fffed4b2b85 in SvXMLNamespaceMap::GetQNameByKey(unsigned short, rtl::OUString const&, bool) const (this=0x55555c4dacd0, nKey=43, rLocalName="data-pilot-source", bCache=true) at /home/julien/lo/libreoffice/xmloff/source/core/nmspmap.cxx:261 #5 0x00007fffed4d16fd in SvXMLExport::AddAttribute(unsigned short, xmloff::token::XMLTokenEnum, rtl::OUString const&) (this=0x55555c2ff660, nPrefixKey=43, eName=xmloff::token::XML_DATA_PILOT_SOURCE, rValue="DataPilot1") at /home/julien/lo/libreoffice/xmloff/source/core/xmlexp.cxx:954 #6 0x00007fffed3e1a1c in SchXMLExportHelper_Impl::parseDocument(com::sun::star::uno::Reference<com::sun::star::chart::XChartDocument> const&, bool, bool) (this=0x55555c4e6b00, rChartDoc=uno::Reference to (class chart::wrapper::ChartDocumentWrapper *) 0x555558168740, bExportContent=true, bIncludeTable=false) at /home/julien/lo/libreoffice/xmloff/source/chart/SchXMLExport.cxx:1204
If we fix the problem of bt already quoted, we've got another assert: #4 0x00007fffed4b2ba1 in SvXMLNamespaceMap::GetQNameByKey(unsigned short, rtl::OUString const&, bool) const (this=0x55555c48c100, nKey=42, rLocalName="repeat-item-labels", bCache=true) at /home/julien/lo/libreoffice/xmloff/source/core/nmspmap.cxx:261 #5 0x00007fffed4d1719 in SvXMLExport::AddAttribute(unsigned short, xmloff::token::XMLTokenEnum, rtl::OUString const&) (this=0x55555c2ca470, nPrefixKey=42, eName=xmloff::token::XML_REPEAT_ITEM_LABELS, rValue="false") at /home/julien/lo/libreoffice/xmloff/source/core/xmlexp.cxx:954 #6 0x00007fffdde4a27c in ScXMLExportDataPilot::WriteLevels(ScDPSaveDimension const*) (this=0x7ffffffef410, pDim=0x5555582e6810) at /home/julien/lo/libreoffice/sc/source/filter/xml/XMLExportDataPilot.cxx:499 which corresponds to tdf#112484
https://gerrit.libreoffice.org/#/c/65742/ for the first bt. The second bt will be fixed with https://gerrit.libreoffice.org/#/c/65740/ concerning tdf#112484
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/18b9f23f13fd503e94d669ab80b5d2354d1817a1%5E%21 tdf#112782: data-pilot-source is invalid in odf1.2 strict It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/eee044b76a2c4ef515475004a550dbd11635e5df%5E%21 tdf#112782: data-pilot-source is invalid in odf1.2 strict It will be available in 6.2.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-6-1": https://git.libreoffice.org/core/+/6aa9f0980612d5c7dcc02cfe11babb73605be4ca%5E%21 tdf#112782: data-pilot-source is invalid in odf1.2 strict It will be available in 6.1.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.