https://issues.apache.org/bugzilla/show_bug.cgi?id=53314
Mark B <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #2 from Mark B <[email protected]> --- Just realised you posted this as a bug. Really, this is a user question and it should have been posted to the user list. Anyway, to repeat what I said, I do not think that it is possible to do what you want with Excel and, if it is an illegal operation, POI will not sidestep rules Excel enforces. I tried, using Excel, to create a named range using the formulae Sheet1!G and Sheet1!$G and in both cases, Excel generated an error. My advice would be to find an Excel users forum and ask how to create a named range that applies to a complete column there. If they know and can provide a formula that works, then we should be able to make POI do the same. I am going to change the status of the bug to NEEDINFO until you can find out how to perform this operation in Excel. -- 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]
