Ignore green triangles in excel export

[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

[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.

[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.

[ulli82]

use 'General'

[dmasterplan]

I'm sorry but that didn't work.

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

but that didn't solve it.

[Lech Kulikowski]

Hello,

Please check the last release build.

Thank you.

[dmasterplan]

Thanks a lot!

[Lech Kulikowski]

Hello,

You are welcome.