Note: applies to both Mac and Windows Microsoft Excel applications. Does not cause import warnings in Mac Numbers or Google Sheets.
- Export data from a DataGrid, applying conditional formatting during the export
- Open the exported .xlsx file in MS Excel (mac or windows)
Opens without any warnings
Displays an alert and requires data to be "recovered" before the file can be opened.
Recovery process completes successfully without any data loss (afaik).