Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Printing Repeating Rows or Columns in Spreadsheet
Printing Repeating Rows or Columns in Spreadsheet
 
   NeoOffice Forum Index -> New Features Program
View previous topic :: View next topic  
Author Message
karl864
Agent


Joined: Oct 05, 2007
Posts: 14

PostPosted: 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.

Similar things may be done with columns.

Would you please add this very useful feature?

Thanks, Karl
Back to top
narf
The Anomaly


Joined: Jan 21, 2007
Posts: 1075

PostPosted: Mon Dec 22, 2008 4:00 pm    Post subject:

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:

http://qa.openoffice.org/issue_handling/pre_submission.html

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.

--fran
Back to top
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Mon Dec 22, 2008 4:12 pm    Post subject:

I think it's the same feature; it's just more hidden in NeoOffice Wink (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
Back to top
karl864
Agent


Joined: Oct 05, 2007
Posts: 14

PostPosted: Tue Dec 23, 2008 8:45 am    Post subject:

Hi Narf -

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?

Thanks, Karl
Back to top
karl864
Agent


Joined: Oct 05, 2007
Posts: 14

PostPosted: Tue Dec 23, 2008 8:47 am    Post subject:

Hi Narf -

What I also noticed is that when set in Excel, OpenOffice did absorb the setting but NeoOffice did not.

This seems like something that is different and is up to you all to figure out.

Thanks, Karl
Back to top
narf
The Anomaly


Joined: Jan 21, 2007
Posts: 1075

PostPosted: Tue Dec 23, 2008 8:57 am    Post subject:

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:

http://www.neooffice.org/neojava/earlyaccess.php

Please let us know if you have any other questions,
--fran
Back to top
karl864
Agent


Joined: Oct 05, 2007
Posts: 14

PostPosted: Tue Dec 23, 2008 9:07 am    Post subject:

Hi Fran -

Yes, That is, in fact, correct.

In the meantime, what about a mention in the help screens to help people find this feature?

Thanks, Karl
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Tue Dec 23, 2008 9:13 am    Post subject:

karl864 wrote:
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.

Patrick
Back to top
karl864
Agent


Joined: Oct 05, 2007
Posts: 14

PostPosted: Tue Dec 23, 2008 9:18 am    Post subject:

Thank you, Patrick.

I will put in a request to OpenOffice.

Karl
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> New Features Program All times are GMT - 7 Hours
Page 1 of 1

 
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

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.