[Advanced Excel] Cell_FormatRange with CellType

Forge Component
Published on 27 Aug by Hanno
54 votes
Published on 27 Aug by Hanno

Dear Team,

I have a question for the Cell_FormatRange action, would it be possible to also include the number format there as a CellType parameter? Now all cells seem to be formatted as General.

In this case I have, I need to write text values to the excel (because i have dynamic queries and no dynamic structures exist for advanced queries, so all data gets to be text using recordlist to excel, etc) that later on get formatted according to the data type from the dynamic query in the excel. Now I need to go cell by cell as only Cell_WriteBy... has the CellType parameter.

Thanks for your consideration.



Wilko, please try the new development version (2.1.2 https://www.outsystems.com/forge/component-versions/355) and let me know if it works for you.