https://issues.apache.org/bugzilla/show_bug.cgi?id=49612
--- Comment #7 from Ranvijay <[email protected]> 2010-07-29 07:10:02 EDT --- (In reply to comment #6) > Name evaluation across workbooks is not supported by POI. Josh Micich, the > developer who wrote most of the evaluation code confirmed that and and I have > to resolve this bug report as "wontfix". > > The syntax SUM('file1.xls'!BOB+'file2.xls'!JIM) means that BOB and JIM are > external names and evaluator needs to open file1.xls and file2.xls to evaluate > them and this is not supported. > > Yegor hi Yegor, Thanks for reply, I understand that external names are not supported by POI as you mentioned.but same error also occur in the same .xls file for two different sheets. lets say two sheets are sheet1 and sheet2 and excel file is file1.xls.lets there are two named defined name1 and name2 in sheet1 now when i am trying to use SUM('sheet1'!name1+'sheet1'!name2) in sheet2 for the same excel file file1.xls,then same exception which i mentioned previously comes. Can You plz, confirmed me that this is supported by POI or not Thanks Ranvijay -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- 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]
