Description
I tried to perform an export of all resource strings in a solution I'm using as I'd like to search them. When I did so I received the following error:
The Excel limit is 32767 characters per cell. This text can't be exported: {"EngineerName":null,"EngineerOrganization":null,"...
I understand this means one of the resource values in the solution has a length that exceeds one of Excel's limits. Unfortunately, this causes the entire export to fail - the result is an invalid Excel file that doesn't contain any data. While we can't fix Excels limitations, it would be better if the extension handled this error more gracefully, for example by truncating long values to the 32767 characters.
An additional option to resolve this would be to add support for CSV export, which being a raw data format isn't affected by Excel's limitations. Also, Excel does seem able to handle opening of CSV files with very long fields by truncating them.
Attached below is a Visual Studio project with a very long resource string that can be used to reproduce this bug: