Posted: Mon Dec 22, 2008 3:22 pm Post subject: Printing Repeating Rows or Columns in Spreadsheet
Hi all -
In Excel, it is possible, with a multiple page document, to set a repeating row or column in printing. So, for example, I can set the printing so that on every page, I can print rows 1 through 3. This becomes useful when there is information that needs to be repeated on each page. When set this way, if page one printed rows 1 through 30, then page 2 first prints rows 1 through 3 and then prints rows 31 through 57, then page 3 first prints rows 1 through 3 and then prints rows 58 through 84, etc.
Maybe you can emulate Microsoft Excel functionality by using NeoOffice's existing Print Ranges function.
You can access this by selecting the menu Format :: Print Ranges :: Edit
If NeoOffice's Print Ranges function does not meet your needs, you will need to contact OpenOffice.org to request this feature.
Unfortunately, our very limited funding and developer resources limits the current scope of the NeoOffice project to keeping a native version of OpenOffice.org running on Mac OS X and adding OpenOffice.org features is outside that scope.
You can file a feature request in the OpenOffice.org issue tracker to get it on the radar of the core OpenOffice.org developers and if they create the feature, the new behavior will get included in a future release of NeoOffice:
Note : our advice is to not mention NeoOffice as mentioning NeoOffice may cause OOo volunteers to accidentally close it without actually reviewing your feature request.
I think it's the same feature; it's just more hidden in NeoOffice (I recall in Lotus you used to be able to define the ranges and row/column titles from the Print dialogue....)
Smokey _________________ "[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Thanks for your thoughts. As a result, I downloaded OpenOffice to see whether the same was true in OpenOffice before sending in a request with them.
I noticed that when I opened the file in OpenOffice, the repeat row function I had set in Excel, was noticed and worked in OpenOffice. So, taking a look at the Format :: Print Ranges :: Edit :: Rows to Repeat, I found the setting and also found the same setting was in NeoOffice.
Therefore, all that remains is for someone to put into the Help files a link for Print Repeat Rows/Columns so that people can find it.
Since I also noticed that the NeoOffice Help Screen is identical to the OpenOffice help screen, perhaps this means I need to contact OpenOffice directly, or will you all handle this?
I am guessing you are using OpenOffice.org 3.0, their latest version. NeoOffice 2.2.5 is based on an earlier version, OpenOffice.org 2.2.1.
Although it doesn't help you right now, we will be upgrading NeoOffice to the OpenOffice.org 3.0 code in the NeoOffice Early Access Program which is currently planned to be released in January 2009. More details about the NeoOffice 3.0 Early Access release are in the following URL:
In the meantime, what about a mention in the help screens to help people find this feature?
Unfortunately, changing any of the help screens is a massive change and not one we are going to devote our very limited funding and developer resources to only three weeks before a new release.
Bascially, changing the help documentation requires changing the OpenOffice.org build. There is just no way around it. The help files for all of OpenOffice.org are in one place and they consist of a big list of XML files and matching localization files that all must be run through OOo's custom "help compiler" every time there is a change.
Running this help compiler for all of the files and localizations usually takes a full day on my G5 PowerPC machine. Even if you could provide workable patches to the OpenOffice.org help files, the respin time and the need to put out a new release and a whole new set of language packs makes editing these files in our builds pretty much unworkable.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum