String and numeric values in a column
Hello,
My final report needs to have both string (some blank cells, followed by a “header” on row 10) + numeric values (the actual values of the documents included) in some of its columns. I have not found a way of doing that successfully till now.
I am uploading a sample of what the report should look like when exported in excel. Several columns need to be kept formatted as number because of the amounts in them, despite the “header” and the blank rows.
The adding of blank rows + header on a specific row and not on top of the table, was discussed and resolved visually here, but then these columns get formatted as “DataCell” due to the inconsistent formatting of the cells in them and I cannot export in excel:
As @takbb suggested, start a new topic and post some sample data including both string and numeric columns. We’ll see what we can do with that. Probably will require some column renaming. You can’t have two different data types in the same column. Don’t forget that the “header” in the 7th row is not really a header. Its just part of the table.
Another problem I have is that some of these headers originally come out of the system with leading spaces, which get removed no matter what I do (tried renaming them in the end, to bring back the leading spaces which I need to keep, but it did not work, the excel export again removes them). I suppose this is for a separate topic though.
Thank you!
Margarita