Hi,
I have a report with a table that has a few columns that have visibility property set to hidden and other visible columns. I would like to export the report to Excel but I need to be able to export the hidden columns as well and unhide that from Excel file generated if needed. Is this possible to do or only the visible columns can be exported?
Thank you.
Yes, toggle state is preserved and exported as Excel outlines. So you should be able to export the hidden columns and unhide them through Excel outlines. Note there are some Excel limitations on outlines, e.g. the maximum number of levels for nexted outlines is 7, and if the toggle item is not in the previous or next row/column of the toggled item, outline is disabled.|||Hi I am having trouble with the toggle item functionality being exported to excel. Could you please expand on the point you made about the toggle item functionality being disabled "if the toggle item is not in the previous or next row/column of the toggled item" or even better provide a pointer to some documentation on this.
Thanks in advance Tony
|||Thanks - i have figured out what i was doing wrong - the problem seems to be that i had rows that were not part of the toggled group. rows like a detail row and group footer rows ocne i removed these (they were initially there but i just made them not visible) the toggle functionality worked perfectly
cheers Tony
No comments:
Post a Comment