You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/12/11 18:16:25 UTC
[Bug 123839] New: Page contains only 1 cell
https://issues.apache.org/ooo/show_bug.cgi?id=123839
Bug ID: 123839
Issue Type: DEFECT
Summary: Page contains only 1 cell
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: viewing
Assignee: issues@openoffice.apache.org
Reporter: aschwarz@acm.org
CC: issues@openoffice.apache.org
Created attachment 82081
--> https://issues.apache.org/ooo/attachment.cgi?id=82081&action=edit
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).
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123839] Page contains only 1 cell
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123839
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #3 from Regina Henschel <rb...@t-online.de> ---
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".
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123839] Page contains only 1 cell
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123839
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |elish@apache.org
Latest|--- |4.0.1
Confirmation on| |
Ever confirmed|0 |1
OS|Windows 7 |All
--- Comment #2 from Edwin Sharp <el...@apache.org> ---
As given in comment 1.
AOO410m1(Build:9750) - Rev. 1548193
2013-12-07_04:10:48 - Rev. 1548790
Debian
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123839] Page contains only 1 cell
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123839
--- Comment #5 from Regina Henschel <rb...@t-online.de> ---
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123839] Page contains only 1 cell
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123839
--- Comment #1 from aschwarz@acm.org ---
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 #.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123839] Page contains only 1 cell
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123839
--- Comment #6 from aschwarz@acm.org ---
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
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123839] Page contains only 1 cell
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123839
--- Comment #4 from aschwarz@acm.org ---
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
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.