Download it now!
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)
Version:
(earliest affected)
5.3.0.0.alpha0+
Hardware: x86-64 (AMD64) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-21 12:30 UTC by Brant Maltby
Modified: 2017-03-22 13:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


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

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,

Jacques
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,

Jacques
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