Ignore green triangles in excel export
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Ignore green triangles in excel export
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
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
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: Ignore green triangles in excel export
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.
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
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: Ignore green triangles in excel export
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.
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.
- Attachments
-
- Tag.png (224.49 KiB) Viewed 1058 times
-
- format.png (55.83 KiB) Viewed 1058 times
Re: Ignore green triangles in excel export
use 'General'
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: Ignore green triangles in excel export
I'm sorry but that didn't work.
Interaction > Tag > 'exceltext'
Textbox format is 'General'
but that didn't solve it.
Interaction > Tag > 'exceltext'
Textbox format is 'General'
but that didn't solve it.
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: Ignore green triangles in excel export
Hello,
Please check the last release build.
Thank you.
Please check the last release build.
Thank you.
- Attachments
-
- Screenshot 2023-02-22 224813.png (84.9 KiB) Viewed 1025 times
- dmasterplan
- Posts: 143
- Joined: Thu Mar 17, 2022 4:04 am
- Location: Philippines
Re: Ignore green triangles in excel export
Thanks a lot!
-
- Posts: 6458
- Joined: Tue Mar 20, 2018 5:34 am
Re: Ignore green triangles in excel export
Hello,
You are welcome.
You are welcome.