Page 1 of 1

Ignore green triangles in excel export

Posted: Mon Feb 20, 2023 2:02 am
by dmasterplan
Hi,

How do I disable error checking in Excel on export?

I have 002 in a cell and it's having a green triangle. How can I remove it?

It cannot be formatted as a number as it has leading zeroes.

Great, Thanks

Re: Ignore green triangles in excel export

Posted: Tue Feb 21, 2023 11:20 am
by Lech Kulikowski
Hello,

You can now enter the string "exceltext" in the Tag field of the textbox, and when exporting to Excel, this cell will be set to "Text" format.
For example, a cell has the string "012345" and the format is set to General, if you edit this cell, the leading zero will disappear; with the format "Text" the string is not changed.

Thank you.

Re: Ignore green triangles in excel export

Posted: Wed Feb 22, 2023 6:06 am
by dmasterplan
Hi,

I did put "exceltext" without quotes in the Tag field of the Textbox in Interaction > Tag
and I can't find any "Text" format in the Text Format property.

I did export but I am still getting a green triangle.

I want the green triangle disappear in i.e. "002" value in a cell.

By the way, I am using 2014.3.0

Thank you.

Re: Ignore green triangles in excel export

Posted: Wed Feb 22, 2023 7:38 am
by ulli82
use 'General'

Re: Ignore green triangles in excel export

Posted: Wed Feb 22, 2023 8:32 am
by dmasterplan
I'm sorry but that didn't work.

Interaction > Tag > 'exceltext'
Textbox format is 'General'

but that didn't solve it.

Re: Ignore green triangles in excel export

Posted: Wed Feb 22, 2023 9:48 pm
by Lech Kulikowski
Hello,

Please check the last release build.

Thank you.

Re: Ignore green triangles in excel export

Posted: Thu Feb 23, 2023 1:39 am
by dmasterplan
Thanks a lot!

Re: Ignore green triangles in excel export

Posted: Thu Feb 23, 2023 10:29 am
by Lech Kulikowski
Hello,

You are welcome.