To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=12710
User robbk changed the following:
What |Old value |New value
================================================================================
CC|'' |'robbk'
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Tue Mar 3 08:40:24 +0000
2009 -------
OK, guys, a new attempt to reopen this issue several years later. There are
circumstances where Excel and OpenOffice *do* behave differently in this regard.
Our CEO is an Excel power user and is reluctant to switch to OOo, partly due to
this issue. Say you want to fit the sheet to one page wide and you don't care
how many pages long. Excel will let you manually change the vertical page break
(row break) while remembering the "fit to page width" attribute. Calc will not.
1. Open OOo Calc and enter lots of data, both in colums and rows.
2. Choose "Format > Page > Sheet > Scale > Scaling mode: Fit print range(s) to
width/height > Width in pages: 1 > Height in pages: 400"
3. Choose "View > Page break preview"
4. Try to grab one of the page breaks with the mouse and move it. It doesn't
work.
5. Choose "Insert > Manual break > Row break". Nothing happens (why isn't the
menu item greyed out?)
6. Choose "View > Normal"
7. Save the same file in Excel format and open it in Excel.
8. Choose "File > Page setup > Paper format" (I'm translating from German here
since I can't easily switch languages in MSOffice)
9. Note that it says "Scale: Fit: 1 page(s) wide and 400 page(s) high" (my
translation) indicating that the settings were correctly taken over from Calc.
10. Hit "OK".
11. Choose "View > Page break preview" (my translation)
12. Grab one of the page breaks with the mouse and move it. It works in Excel as
desired. A solid blue line is a manual page break, and a dotted blue line is a
page break determined by Excel.
13. Position the cursor in a different row and choose "Insert > Page break" (my
translation). A solid blue line is inserted at the cursor position as desired.
Please reopen this issue. Thanks.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
