poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53314] Invalid Formula Cell Reference for named ranges referring to whole columns
Date Tue, 29 May 2012 14:29:32 GMT

Mark B <markbrdsly@tiscali.co.uk> changed:

           What    |Removed                     |Added
             Status|NEW                         |NEEDINFO

--- Comment #2 from Mark B <markbrdsly@tiscali.co.uk> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message