Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Parentheses in colum names

 Post Reply Post Reply
Author
pdv-software GmbH Firma View Drop Down
Member
Member
Avatar

Joined: 02 Apr 2014
Posts: 46
Post Options Post Options   Quote pdv-software GmbH Firma Quote  Post ReplyReply Direct Link To This Post Topic: Parentheses in colum names
    Posted: 18 Jan 2016 at 4:39pm
Hello,

we have a problem concerning column names and placholders in the excel file. One of our customer has a column named "Material (short)" and an error occures during report generation that says "missing parenthesis on formula....". The placeholder looks like "<#Table.Material (short)>". I guess FlexCel interprets this placeholder as a formula and recognises a wrong syntax. But it is impossible for us to change the column name. Is there any way to use this column in a placeholder?

Thanks in advance
Back to Top
Adrian Gallero View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 1233
Post Options Post Options   Quote Adrian Gallero Quote  Post ReplyReply Direct Link To This Post Posted: 18 Jan 2016 at 10:47pm
The issue is that FlexCel interprets parenthesis () as a function call. This was a known issue, but we didn't really put much priority on it since most (sane) tables don't have parenthesis in column names. And you could always workaround it by using something like Select "Material (short)" as MaterialShort from table.

But well, I looked at the code and it was simple to add this special case. We have fixed it internally already. Please send me an email to adrian@tmssoftware.com mentioning your registration email and I will send you the updated FlexCel.
Back to Top
pdv-software GmbH Firma View Drop Down
Member
Member
Avatar

Joined: 02 Apr 2014
Posts: 46
Post Options Post Options   Quote pdv-software GmbH Firma Quote  Post ReplyReply Direct Link To This Post Posted: 21 Jan 2016 at 11:11am
Thank you for your help, it works now.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down