Hello David,
With regard to the original 'Coding Error' problem, did you notice it only
after migrating to a more recent build of the API? If not, have you tried using
an earlier build just to see if it is a problem that has been inadvertently
introduced?
To answer this question however, I cannot see an obvious way around the problem
because HSSF will still have to access the sheets that 'contain' or provoke the
errors; it may even be that you have to persevere with the event model to
create the temporary sheet and then proceed to process this in the more
familiar way. If I manage to find the time over the weekend, I will have a play
with the event model just to see how it all hangs together and whether that
provokes any thoughts.
I could think of a much more clumsy technique that would use Excel macros to
process the original sheets and create your temporary worksheet that could then
be processed using HSSF. But this is ugly in the extreme and would involve
using both Excel and your application; unless it is possible to use HSSF to -
somehow - execute a macro contained within a worksheet.
"Karr, David" <[EMAIL PROTECTED]> wrote: Because of my problems with "Coding
Error: Expected ExpPtg to be
converted from Shared to Non-Shared Formula", I'm considering the best
way to "clone" two regions of my wide spreadsheet into a "temporary"
spreadsheet, which I can then process like the original spreadsheet.
My primary concern is that I have to use a strategy that can
successfully read the columns I specify, without hitting the same error
that I had originally. Is there another way to copy a region of cells
that I might not have that problem with?
I tried doing things with the event model, but I can't make much headway
with that. It's like implementing Java with front-panel switches.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.
