Issues with shared vs. non-shared formulas on somewhat wide spreadsheets

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm not hopeful I can get help here, but I'll give it a try.

I'm on XP, using Excel 2003.

I have a somewhat wide spreadsheet (up to column IT).

I read this spreadsheet with the Jakarta POI HSSF framework, written
specifically for reading Excel files.

When I run the app that uses POI, if I only read the leftmost columns,
it works fine. However, once I get up to about column 65 (somewhere
around BP), I get the following bizarre exception from POI:

org.apache.poi.hssf.record.RecordFormatException: Coding Error:
Expected ExpPtg to be converted from Shared to Non-Shared Formula

I've filed a POI bug for this, and asked around on the dev list, but
I've gotten nowhere.

I've tried experiments of creating multiple worksheets, each
containing blocks of about 50-60 columns from the original worksheet,
and that works, although it's somewhat laborious.

I'm hoping there may be an Excel expert who really knows about the
innards that might have a feel for what could be happening here, and
how I could deal with it, or how POI HSSF could be modified to deal
with it.

.

Relevant Pages

  • Re: How to mimic Excel download?
    ... that don't know Excel get lost when it comes to understanding my ... alternatively you could use the Java POI library to create ... Off hand I don't think POI supports creating multiple Worksheets ... ms.ExecuteStatement Command ...
    (comp.lang.javascript)
  • Re: Excel File Question
    ... Back in the early days when the generic term "spreadsheet" was coined it ... In Excel a file is a workbook which can contain multiple worksheets. ...
    (microsoft.public.excel.misc)
  • multiple worksheets
    ... Excel xp ... I'm looking to set up a spreadsheet with multiple worksheets for multiple ...
    (microsoft.public.excel.misc)
  • RE: Cannot get code to work for API Save Dialog Box
    ... I thought I put the formula in the spreadsheet with the .cell, ... Your totals are not saved with it. ... difference at all to the output in excel. ... ' Declare necessary API routines: ...
    (microsoft.public.access.forms)
  • Re: Looking for Easiest Way to Create Report
    ... By recording Excel macros and editing them you may be able to get all this down to one button push in each application. ... run your query then that makes life very much easier than it would have been if you'd had to match values line by line. ... So, if you do go for the query and TransferSpreadsheet route, that leaves you with the problem of levering in the four header rows. ... My guess is that the simplest solution will be in Excel, if you're prepared to do the job in two stages: one which generates the spreadsheet from Access, and another which requires you to move to Excel to add the headers. ...
    (microsoft.public.access.gettingstarted)