Bug 106676 - Decroise Unpivot Extension Basic Syntax Error in 5.3. Integration desired
Summary: Decroise Unpivot Extension Basic Syntax Error in 5.3. Integration desired
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Enhancements
  Show dependency treegraph
Reported: 2017-03-21 12:30 UTC by Brant Maltby
Modified: 2023-08-19 14:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Test file as proposed by Decroise (11.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-22 13:24 UTC, Jacques Guilleron

Note You need to log in before you can comment on or make changes to this bug.
Description Brant Maltby 2017-03-21 12:30:16 UTC
The Decroise extension allows Calc to unpivot tables no longer works in 5.3 or 5.4.  When run one gets an edit screen saying that there is a "Basic syntex error. Expected:)."

As an accountant, this extension is an important tool in being able to combine and analyze data from a table or multiple tables. [Once unpivoted, one can combine data from various tables to perform pivot table analyses or import into Base.]

My preference would be for the unpivot to be made part of Libreoffice pivot table feature, but if not, it would be appreciated to make a fix so that the extension will function as intended.
Comment 1 Jacques Guilleron 2017-03-21 16:29:01 UTC
Hi Brant Maltby,

As reported for some other extensions in 
Bug 106529 - LibO 5.3.1.x breaks extensions for changes in BASIC parser 
since bug#80731 - missing closing parenthesis in Basic expressions is now considered to be an error (which it really is) instead of being silently ignored.

Decroise's author has to be informed and correct the code. 
Would you be so kind to do it?

Thank you,

Comment 2 Jacques Guilleron 2017-03-21 20:35:11 UTC
I informed Decroise's Author. He does his best to correct the code quickly.
I set Status to New to mention your preference.

Have a nice day,

Comment 3 Katarina Behrens (Inactive) 2017-03-22 12:40:48 UTC
Is it this extension? http://extensions.openoffice.org/en/project/decroise
Comment 4 Jacques Guilleron 2017-03-22 12:59:34 UTC
That's it.
Comment 5 Jacques Guilleron 2017-03-22 13:24:57 UTC
Created attachment 132071 [details]
Test file as proposed by Decroise
Comment 6 BogdanB 2023-04-13 04:22:30 UTC
Is this bug NOT OUR BUG?
Is this bug meanwhile solved? Brant, can you check again?