Hello,
Can you tell me where I can find a list of values that I can use with excel value property?
I have a following issue -
I formated my data in text property as {Format("{0:N0}", Data.Value)} and i used Number in text formatting. What do I put in Excel Value property so my exported xmlx consists of numbers too? Right now in excel I get a following error - number stored as text.
(I know it is easy to fix it in excel but it is not an option for me, I need to fix it in report)
Thank you in advance !
Excel Value Property
Re: Excel Value Property
Hi Eloy,
Unfortunately, we do not support any other type of the Exported value to Excel, rather than text, if the exported value is not recognized by Excel. If you need some advanced calculations, please check the following approach as well;
viewtopic.php?t=407
ExcelValue is intended to be used just in case if the value in Excel export should differ from the default value from the Text property
viewtopic.php?&t=3894
Thank you,
Edward
Unfortunately, we do not support any other type of the Exported value to Excel, rather than text, if the exported value is not recognized by Excel. If you need some advanced calculations, please check the following approach as well;
viewtopic.php?t=407
ExcelValue is intended to be used just in case if the value in Excel export should differ from the default value from the Text property
viewtopic.php?&t=3894
Thank you,
Edward