Issue 18357 - Max nmbr of rows exceeded
Summary: Max nmbr of rows exceeded
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-18 15:50 UTC by wiger
Modified: 2003-09-08 16:55 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Spreadsheet showing the message (431.75 KB, multipart/mixed)
2003-08-19 08:41 UTC, wiger 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description wiger 2003-08-18 15:50:44 UTC 
I just installed OpenOffice 1.1.0 on my XP machine. It seems to be working fine.
However, there is one issue. When opening a large spreadsheet (2.818kB), I get
the following message:


Warning loading document file: ///C:/<PATH>/Administratie.xls:
The maximum number of rows has been exceeded. Excess rows were not imported.


When browsing through the spreadsheet, it looks as if nothing is missing. Even
the 'conditional formats' seem to exist . . .

Could you please clear this up to me?

Kind regards,
Wiger Levering
Comment 1 john.marmion 2003-08-18 18:46:39 UTC 
Typically this message is generated if the Excel file contains more
than  32000 Rows or there is a reference in the document to a Row
greater than 32000. Can you attach your sample document to this issue
using the link: "Create a new attachment" above. Thanks.
Comment 2 wiger 2003-08-19 08:41:26 UTC 
Created attachment 8566 [details]
Spreadsheet showing the message
Comment 3 wiger 2003-08-19 08:57:39 UTC 
I added the requested file in zip format and I think it should be
reassigned. . . . 

Wiger
Comment 4 john.marmion 2003-08-19 10:14:41 UTC 
Calc currently only supports 32000 Rows. See issue 1967. Excel has
created more than 66000 MULBLANK records in the attached doc. These
records access Rows greater than 32000. Thus the warning is that these
blank records are ignored. MULBLANK records are created internally by
Excel for file size optimization. It means multiple blank records.
This allows Excel to store 256 blank cells in a single record. The
reason this is happening in this document, is because there is a lot
of conditional formatting in the cells, thus Excel needs to write
these cells explicitly and therefore it needs to mark the blank cells.

So you can safely ignore the warning. I will close this issue.
Comment 5 john.marmion 2003-08-19 10:15:41 UTC 
closing as stated