I see that 3D references are listed as unsupported by POI. I'm
wondering if anyone knows a work around. Here's the problem:
I have a "totals' sheet that sums up values on the rest of the sheets in
the workbook. I use POI to automatically add sheets of data. Every
time I do this my 3d references in my SUM() formula change. More
specifically the reference range shifts over one sheet. Does anyone
have any suggestions? Is there a way to enter a formula as a
RichTextString and then change the cell type to Fomula?
Thanks,
Tim
