cell formatting of numbers as Text in excel export

[Jozef Balga]

Hello!

I have problems with excel exports. I need to display a decimal number with 26 digits as text in the excel export. Unfortunately the cell containing the number is formatted as 'General', so when I try to edit the cell value in MS Excel 2010 (with mouse double click) and then move the cursor to another cell, the cell value is changed to scientific notation. I would like to prevent that. Is there a way to force the cell formatting to Text in the report template? Thank you for the answer.

Jozef

[HighAley]

Hello.

There is an option in Excel export. You should set the Tag property of the text component to 'exceltext'.

Report.mrt

(3.32 KiB) Downloaded 745 times

Thank you.

[Jozef Balga]

Thank you, it solved my problem.

Jozef

[Andrew]

Hello,

Great! Have a nice weekend.

[anishravindran]

Hi Andrew,

Please can you let me know if the below option still works for the option to show as text only in excel export. Currently using then "2018.1.8.0" version of Stimulsoft.

"There is an option in Excel export. You should set the Tag property of the text component to 'exceltext'."

Thank You.

[anishravindran]

Hi Andrew,

Please can you let me know if the below solution is still applicable for Stimulsoft "2018.1.8.0". I am getting error while opening the excel.

The solution what I am looking for is the same as to show value as text in excel rather than showing an error message at the cell level in excel.

There is an option in Excel export. You should set the Tag property of the text component to 'exceltext'.

Thank You.

[HighAley]

Hello.

We have reproduced the issue.
We need some time to make an improvement.

Thank you.

Ticket reference: #3152698

[Ivan]

Hello,

The problem is solved.
The patch will be available in the next build.

Thank you.

[anishravindran]

Thank You Ivan. When is the next build expected to release?

[Lech Kulikowski]

Hello,

The next release 2018.2 will be available within one or two weeks.

Thank you.