alexjansons opened a new pull request, #545: URL: https://github.com/apache/poi/pull/545
Sheets starting with R1C1 cell style reference are enclosed in single quotes. If this is not the case Microsoft Excel treats formulas with references to such sheets as erroneous. It proposes to "repair" corrupted workbook and as a result clears affected cells as seen in the image below:  E.g. sheet name `RC123Test`. It should be enclosed in single quotes. Whereas `RA` can be left as is, as 'R' following alpha character is not a valid R1C1 cell style reference. This behavior is also described here: https://stackoverflow.com/questions/41677779/when-does-excel-surround-sheet-names-with-single-quotes-in-workbook-xml-or-othe/53483274#53483274 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
