Apache OpenOffice (AOO) Bugzilla – Issue 123839
Page contains only 1 cell
Last modified: 2013-12-11 23:53:17 UTC
Created attachment 82081 [details] Calc document with erroneous Page Preview, Print condition Win7 OO 4.01 Calc 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).
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 #.
As given in comment 1. AOO410m1(Build:9750) - Rev. 1548193 2013-12-07_04:10:48 - Rev. 1548790 Debian
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".
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'. thanks art
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.
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? art