I have columns with double datatype and when rendered into .xlsx output file a few numbers are dispalayed as text.( small green triangle at the left top corner of the cell)
Whats the issue.How can this be corrected.
@PoojaSingh88 can you share the workflow for us?
its a large workflow and cant be shared due to data confidentiality rules.
However I can share few examples of what's happening
when I check the browse for the column 1 which is configured as a double - I can see the value as per below
when I use the table tool -> Layout -> render tool to output this in .xlsx I see the output as -917,730 but as a text format a green triangle on left top corner of the cell.
Also to note I have read these via a binary input file and am writing it to xlsx.
I was having the same issue.
Fix this by selecting landscape orientation instead of portrait orientation in the Render configuration.
I had similar issue, a table column (number) with one of the cells shown as text in Excel. A workaround was by changing Report Style of Render output, e.g. to A3 / B3 paper size, Landscape, No Margins. A kind of trial and error to find setting that eliminates the text format.
The idea is to widen the report page such that the columns can show sufficient numeric data.
