Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
there is this button "export structure" on the "sheets" tab of the document_properties_dialog
=> How do I have to open this so that it can be properly viewed, with the separators and all?
Thanks a lot!
Best regards,
DataNibbler
Go to excel.
Choose Data, Import from Text. Select Show All files at the bottom right and then double click on the file you exported. Import the file with a tab delimeter.
You will then get the following result.
Regards,
Marius
Hi DataNibbler,
Import it into Excel as a tab delimeted file.
Regards,
Marius
Go to excel.
Choose Data, Import from Text. Select Show All files at the bottom right and then double click on the file you exported. Import the file with a tab delimeter.
You will then get the following result.
Regards,
Marius
The files contain tab separated data. You could use a spreadsheet program like MS-Excel to open it. Or load the data into a qlikview document.
Hi Marius,
that is cool! Thanks!
I was actually only looking at this as a way of getting a quick listing of all the objects on a sheet - the thought is, when I want to copy any KPI from one app to another, copying the script_tab is easy, but there might be 5 or 6 charts one over another, with variables governing visibility, so I need some kind of listing in order not to overlook anything.
That structure_listing, however, is also a great (very easy) way of learning how "calculation_intensive" certain charts are and if it's worthwhile having a closer look at them.
Best regards,
DataNibbler
Sure thing.
In this export you will however see what you are looking for. All objects. And a status to show if its visible or not visible.
Yeah, I agree with you. Its an awesome little functionality.
Regards,
Marius
Right - the easiest tool to properly do a job is usually the one to choose, particularly when time is rare ... sometimes, however, people miss the word "properly" out of this sentence, which makes things a bit difficult...