Issue 123839 - Page contains only 1 cell
Summary: Page contains only 1 cell
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 4.0.1
Hardware: PC All
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-12-11 17:16 UTC by aschwarz
Modified: 2013-12-11 23:53 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.1
Developer Difficulty: ---

Calc document with erroneous Page Preview, Print condition (17.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-11 17:16 UTC, aschwarz
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description aschwarz 2013-12-11 17:16:25 UTC
Created attachment 82081 [details]
Calc document with erroneous Page Preview, Print condition

OO 4.01

Document in Landscape mode, top two rows repeated (1:2) and left column repeated (A:A) in landscape mode.

The document has several pages. In both "Page Preview" and print:
Page 1 appears normal
Page 2 is 'short', does not fill the page
Page 3 has a single cell ($A$2)
Page 4 appears normal
Page 5 appears normal

I am including the document at issue in an attachment. I hope that this helps.

Unless a repair is not done this document must be exported to Windows Excel. Most unfortunate (sigh).
Comment 1 aschwarz 2013-12-11 17:21:55 UTC
I just took another look. The correct error indication is:

Page 1  appears normal
Page 2  appears normal
Page 3  contains a single cell ($A$2)
Page 4  repeats page 1
Page 5  repeats page 2

No Header, Footer centered w/Page #.
Comment 2 Edwin Sharp 2013-12-11 18:03:09 UTC
As given in comment 1.

AOO410m1(Build:9750)  -  Rev. 1548193
2013-12-07_04:10:48 - Rev. 1548790
Comment 3 Regina Henschel 2013-12-11 19:49:35 UTC
The document prints exactly those print ranges which are defined. There is no error so far.
The real question is, why there are such print ranges, if you have not defined them? Do you wrote the file directly in Apache OpenOffice, or is it converted from another file format or written by another application?

To get rid of the print ranges goto View > Page Break Preview. Right click a cell and click on item "Undo Print Range".
Comment 4 aschwarz 2013-12-11 21:45:05 UTC
This is an original document created in OOCalc.

I don't understand the comment on ranges. Could you provide an example of what you mean? The ranges I supplied for col/row repeats seem to be ok (to me) and I don't think that I used any other ranges so your comment is confusing. Sorry.

Are you saying that page duplication and other issues are a result of the ranges being incorrect? If so then I would like to suggest an enhancement in that OO should never allow duplicate pages and should report on range errors which may produce them.

Please tell me what it is that I've done wrong so that I can correct the 'error'.

Comment 5 Regina Henschel 2013-12-11 22:06:22 UTC
Go to menu Format > Print Ranges > Edit. There you see in the second and third field the row and column to repeat. And in the first field you see the suspicious print ranges. You can delete that entry.

Sometimes print ranges are wrong when you use other formats or applications. But you say that it has been created in Calc, so I have no idea what might have produced such entry.
Comment 6 aschwarz 2013-12-11 23:53:17 UTC
Thank you, and yes indeedee. Removing the offense removed the problem.

I wish I could blame someone else. My wife, "she who must be obeyed", disavows any contribution. I guess I'm the guilty party.

Any chance that OOCalc can detect and report range errors?