Created attachment 86056 [details] DataPilotConstraints.ods Hello See also Bug 66655 The fix of Bug 66655 does not solve the problem in all cases, especially with this syntax: GETPIVOTDATA (pivot table, Constraints) The attached spreadsheet DataPilotConstraints.ods includes examples of syntax that worked in previous versions and does not work (see screenshots). Regards Pierre-Yves
Created attachment 86057 [details] Screenshot DataPilotConstraints OK with OOo
Created attachment 86058 [details] Screenshot DataPilotConstraints KO with LibO
Created attachment 86154 [details] LibO_Calc-3.5.7: OK I confirm this bug: OS: Windows XP 64-bit Edition SP2; Windows XP Pro\Home SP3 LidreOfficeDev: 1. Win-x86_9-Voreppe libreoffice-4.1.3.0.0+; pull time 2013-09-18 06:54:42; core:03a341775507502dd58598edc3fd805a8518550d 2. Win-x86@6-debug LibO-4.2.0.0.alpha0+; pull time 2013-09-05 05:47:55; core:69cd97277cb843d91bc1d1785b23e8c4c8bf6a33 LibreOffice-3.5.7 - OK. This is regression therefor then this is critical bug.
LibO-dev-4.0.6.0+ (ID: c0cf51a499ec52b23443393b67425ab557328a9, TinderBox: Win-x86@6-debug, Time: 2013-09-11_22:34:30) hasn't this bug.
*** Bug 71234 has been marked as a duplicate of this bug. ***
Is this bug still valid / reproducible with the latest LO release? Currently 4.1.3.2: http://www.libreoffice.org/download/ Or is this WORKSFORME as of comment #4?
Hello (In reply to comment #6) > Is this bug still valid / reproducible with the latest LO release? > Currently 4.1.3.2: http://www.libreoffice.org/download/ > > Or is this WORKSFORME as of comment #4? Still reproducible on windows 7/64 with - Version: 4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a - Version: 4.2.0.0.alpha0+ Build ID: 7504b3dd8ca4424fd7da91195741b566ce42a2c0 TinderBox: Win-x86@42, Branch:master, Time: 2013-10-30_22:52:21 Regards Pierre-Yves
(In reply to comment #6) > Is this bug still valid / reproducible with the latest LO release? > Currently 4.1.3.2: http://www.libreoffice.org/download/ > > Or is this WORKSFORME as of comment #4? This is the bug LibO-Dev_4.1.4.0 (build 2013-11-18_03.03.02 win_x86) and LibO-Dev_4.2.0.0alpha1 (build 2013-11-17_23.56.08 win x86). LibreOffice 4.0.6 - OK.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1d85c8df2fb9cb25fc524485339ae9f11e8da676 fdo#69518: Correctly handle the old constraint syntax. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a125b9da3035a584ffd2203f2b3c71c972b8bd4c&h=libreoffice-4-2 fdo#69518: Correctly handle the old constraint syntax. It will be available in LibreOffice 4.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Fixed.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cfc9cef1e26e98153eb93229a9c18a674a3ebf11&h=libreoffice-4-1 fdo#69518: Correctly handle the old constraint syntax. It will be available in LibreOffice 4.1.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thanks for the fix Kohei. Works fine in: Version: 4.1.5.0.0+ Build ID: 812963c5ff6e1c4685eddb830a82a69a3801d82 Version: 4.2.0.0.beta2+ Build ID: 02180aed7dc0b8c5f9cc23b319adc2386a9aab69 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2013-12-08_08:48:31 Version: 4.3.0.0.alpha0+ Build ID: c6fe5c6f371328cb6cf61d68f016a04f8b635a48 TinderBox: Win-x86@39, Branch:master, Time: 2013-12-08_02:58:23
*** Bug 68632 has been marked as a duplicate of this bug. ***
Hello WORKSFORME with windows 7/64 & Version: 4.2.0.0.beta2+ Build ID: 4031765b004dded31f04c54f9a055b7a3d0053f2 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2013-12-14_01:35:27 Thank you Regards Pierre-Yves