GNOME Bugzilla – Bug 649914
ODF export of sheet names containing '
Last modified: 2011-05-10 19:09:18 UTC
We incorrectly export expressions with sheet names that contain ': FOr example on import of a file we exported: Sheet1!A6 Unable to parse 'SQRT(['Sheet\'2'.A1])' ('Could not find matching closing quote') The expression should be: SQRT(['Sheet''2'.A1])
We read files containing such sheet names that are created correctly just fine. So this is just an export problem.
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.