LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: aop

Hi!

Some times when using the excel output node with TemplateInputFile set the header row in the final output retains the formatting that was set on that row in the template and some times it does not and some times it is retained for some part of the headers but not for all even inside same sheet. I've been using the workbookspec parameter to define the output.

Basically in my all usage scenarios it would be a desirable feature to be able to keep the header row formatting (background colors, fonts etc.) as it is set on the template input file so I would not need a macro to do the work afterwards. Initially I thought this was not possible with the excel output node but then I noticed that some times I'm actually able to generate outputs like that (the formatting of the template is retained). So far the behaviour has seemed a bit random to me and I haven't been able to figure out what actually affects this behaviour.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

If you set the parameters: "FormatOutput" and "HeaderBold" to false, then this visual formatting (cell background colors etc) should be preserved.
Unfortunately, there is currently no separation of data formatting and visual formatting, in that if FormatOutput is set to false, the data that is output will be simply output as a string type.
It also means that certain cells in Excel will show with the little green arrow indicating that there is numeric etc data stored as text and that numeric functions will not operate correctly on those cells.

If "FormatOutput" is set to true, the node will correctly set the data formatting, but in doing so it also overwrites the visual formatting present on the template file.

An enhancement request has been raised within our system to separate this functionality such that you can choose to overwrite the data formatting while preserving the visual formatting.
This has been raised as issue 4722.

Regards,
Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: aop

I'm able to generate excel outputs with preserved header row formatting even if I have even "FormatOutput" and "HeaderBold" set to true. It seems to work the same way every time for a certain data set. However, the issue is that sometimes visual formatting of all column headers is preserved and sometimes for only part of the column headers and sometimes not for any of them. I just cannot figure out what could it be in the data that affects the outcome I get.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hey,

Are you able to PM some example templates & graphs with these cases (all preserved, none preserved, some preserved)?

Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

Was there a solution to this problem?