Vizlib Home Try Vizlib

Enhanced Support for Calculated Columns in Vizlib Writeback Table Export to Excel

This is to request enhanced support of calculated columns in Writeback Table exports to excel. Currently the hypercube mostly appears to be the focus of the export, so:

1. the column order of the exported data elements does not always match the column order in the table.

2. calculated columns are sometimes excluded from the exported file.

3. calculated column names are not retained in the exported file which shows the underlying script as the column name.

Related tickets: #25377, 25378, 25379.

1 person likes this idea
  • Agreed. The ordering of the columns (depending on how you adjust your writeback) doesn't seem to correlated properly when exporting (no matching). I'd think the export would consider the display label, but seems like its just the display on the actual writeback table vs. the column name on the exported file.

  • Hi,
    Thank you for your input! The export is of the hypercube/underlying data and not the actual visualization which explains why you would see a different result when exporting. 

    The exporting of ongoing formatted Writeback data is not a priority so this feature is unfortunately not there yet. If we get more requests and important use-cases for this functionality in the future we will consider adding formatted exports as a separate option to exporting only the data. The workaround currently would be to export updated data through Vizlib Table that does have a formatted export to Excel option.

    Kind regards 

    Please note your unique ticket reference (#25404) and URL

  • We have the same issue. Our end users expect the correct column order when exporting as well.

    Related ticket #26614

Login to post a comment