https://bz.apache.org/bugzilla/show_bug.cgi?id=60517
--- Comment #4 from Ricky <[email protected]> --- As you found it out, single quote is very important in multiple sheet of formula string, 1. The single quote of sheet name is kept if any characters such as #"=<>&+-%,SINGLE_SPACE exist in sheet name. eg, if you put # sign inside sheet name, ie 'Sheet#4', the single quote is preserved 2. The parsed formula string of multiple sheet from POI 3.15 is incorrect. At any time, it is illegal to quote sheet name twice =SUM('1003':'1856'!D28). The correct parse result should be SUM('1003:1856'!D28) I tried to figure it out how POI generate parse result and patch it by myself. But IMHO the formula parsing code is not quite readable. In the absence of development document, it is better to leave maintainer to fix it. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
