Displayr

Users complain of seeing “table” being included in the name of the table being exported to Excel. Since it’s part of the object’s Properties > GENERAL > Label , it is automatically included upon export: !image-20220829-211828.png|width=544,height=147! Instead, the user would prefer not to see this at all (since it’s part of the page name already and is a repeat), or just have the variable label (Q16. Do you plan to submit a loan forgiveness application by the October 31st deadline?)

Can we provide users with the capability to update an existing Excel Workbook. Sometimes users Export tables to Excel and do some further manipulation in Excel while they explore their data. They might then realize that there are some tables missing and go back into Displayr to run their tables. However, they are not able to update their existing Excel and continue their analysis from where they left off, instead, they are forced to export an entirely new Excel Workbook. Can we allow to instead select an option Update an Existing Excel Workbook and append the new tables to the existing tables?

Allow users to select an Excel Table Style when exporting data from Viz/ R output.

Biggest pain point for user is that "I can’t export data to excel and check the box to have a chart exported right along with the data. I do not want to have to set up data tables and then separate visualizations for charts. I want to export data WITH generated charts that I can manipulate in excel. We pass off excel files with data and charts to our art department – NOT powerpoint. Researchers do not look at data in powerpoint. Creating this type of document in DisplayR is impossible. Q could do it in 30 seconds."

Tables from Displayr should export to excel exactly as they appear on the browser.

The user is transitioning to Displayr from Q. In Q you have the option to Export as one worksheet per group . They would like to have this exporting capability in Displayr too as they use it all the time in Q.

When you export from Displayr to Excel, it currently only exports underlying tables, textboxes, and items from the page master. The user has sample details in an R calculation but this won’t export unless the pasted text appears within a data frame, i.e. viewed as a table.

Right now, a text box nor a dynamic text box (R string output) will not export to Excel. This user was looking to do so because they wanted to show the filter description in the Excel output. They are aware that filter descriptions appear at the bottom of tables by default, but they deleted the table filter because they did not want the table to resize each time a filter were applied.

For pages with QChart/visualizations w/tests. When it’s exported to Excel the underlying table of data used to build the chart is not. However, it is with many R visualizations. Current workaround is to duplicate the chart, turn it back into a Table, then hide it behind a white square or something so that it’s not visible but can be exported.

Export to Excel by going to: Go to Publish > Export Pages > Excel . Expand out the Advanced Options !image-20220518-105750.png|width=50%! Within a Document go to Choose an Excel table style and select a style. Click Export . When you go to export that Page again, the settings have reverted Unstyled and the customer has to reselect the table style. The settings are preserved when you choose an option for Choose how to export pages , so the customer would like the same functionality for Choose an Excel table style and Choosing the spacing between tables on the same Excel worksheet .