After I exported a report to Excel, some of the cells' background color disappear.
Only the columns without data were displayed without background color, although I'd specified color at design time.
Hi
Typically the color must be retained. can you please post some code sample here for us to help you out.
Thanks
VJ
|||hi vj, i don't have sample code as there's no code involved. i just specified the cell background to dark green.
this discolorisation problem only occur on group cell. for example, the first column contain group header risk category. second column contain risk id. some risk id belong to the same risk category. so for every risk id, risk category is only displayed for the first occurrence. for the other risks, the risk category is empty. as a result the background color defaults back to white.
i hope i explained the situation. i can send you the spreadsheet so you can see what i mean.
|||Hi,
From your description, the exporting to excel is a built-in function which enables you to export the current report to an excel formatted file.
When you are going to export a report to the excel formatted file, it converts the fields which filled with data to the cells in excel with the format, but for those fields without data, it wouldn't.
Based on my knowledge, since this is a built-in function, it's difficult for us to set the background through codes or any programmatically ways.
Thanks.
that's what i thought nai-dong.
is there any workaround for this.
No comments:
Post a Comment