Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Issues with shared vs. non-shared formulas on somewhat wide spreadsheets

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing viewing a shared workbook on a shared drive aloomba Excel Discussion (Misc queries) 0 April 13th 07 02:52 PM
Shared workbook - pc/mac - issues with saving KeithZ Excel Discussion (Misc queries) 0 August 29th 06 03:30 PM
update pivot in shared shared workbook 00George00 Excel Discussion (Misc queries) 1 August 23rd 06 08:16 PM
shared spreadsheets Buffalo one Excel Discussion (Misc queries) 1 April 3rd 06 04:44 AM
locking formula for shared excel spreadsheets MFY Excel Discussion (Misc queries) 2 June 11th 05 12:25 AM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"