umya-spreadsheet
umya-spreadsheet copied to clipboard
Images with spaces in the file name results in corrupted Excel file
If you attempt to add an image with spaces in the file name it will result in a corrupted Excel file. Upon repair using Excel the image will not be displayed.
Investigating the XML files shows that everything appears to be written correctly and the image is in the xlsx zip.
I cannot find it documented anywhere that spaces are not supported, this was identified through trial and error.
Temporary solution: Don't attempt to add an image which has spaces in the file name
Permanent solution:
- Return an error if the image name has spaces in it
- Automatically replace spaces with underscores (as long as it isn't felt that this will cause other problems/confusion with the user trying to enumerate images by name)
@Niatross Thank you for your report. We will modify it with reference to the Excel behavior.