Hi all,
I’d love for exports to use the widget’s custom title instead of the underlying table name — the worksheet name in XLSX exports, the file name for CSV downloads, and anywhere else the table name currently shows up. I often rename widgets to something clean and readable for the page, and it would be great if that name carried through to exported files — especially when sharing with clients or coworkers who never see the Grist side.
This would also fix a real bug I hit today. I exported a summary table widget to XLSX, and since summary tables get auto-generated names like CHAMP_Import_summary_AccountName_Department_Name_Zone_week_ending, the sheet name blows past Excel’s 31-character limit. Excel flags the file as damaged with the “We found a problem with some content…” dialog and forces a repair on open. The repair turns out to be harmless — it just truncates the sheet name and all the data survives — but it looks alarming and doesn’t inspire confidence in the export.
Even if the widget title idea doesn’t land, it would be worth sanitizing XLSX sheet names on export anyway: truncate to 31 characters and strip the characters Excel doesn’t allow (\ / * [ ] : ?).
Thanks for a great product — this is the first real snag I’ve hit with exports.