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 - Add Repeat or Redo Functionality in Calc After a Sort
Add Repeat or Redo Functionality in Calc After a Sort
 
   NeoOffice Forum Index -> NeoOffice New Feature Requests
View previous topic :: View next topic  
Author Message
noibs
Sentinel


Joined: Dec 09, 2006
Posts: 22

PostPosted: Thu Feb 18, 2010 12:06 pm    Post subject: Add Repeat or Redo Functionality in Calc After a Sort

I don't know if this is a bug or deliberate omission in the OpenOffice code or not. If so, then it likely cannot be added in NeoOffice. I have submitted a formal request for this in OpenOffice.

I do a large number of repetitive sorts in Calc. Each one requires a two or three mouse actions. The reason is that the Repeat and/or Redo command OO/NeoO does not function after a sort. It does after most other things, but not after a sort. I have even assigned a quick, custom key-code to the Repeat command in Calc, but it's useless after a sort.

Lately, I've been exporting certain spreadsheets to xls so that I can use the Excel Redo function. I was hoping that Office 2008 was going to be the last Mac version of Office that I had to buy.

I can't understand why Redo/Repeat doesn't work after ALL actions in Calc.
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Thu Feb 18, 2010 1:10 pm    Post subject:

To be honest, I do not think that this new feature request is feasible to implement within OpenOffice.org's Redo management code.

The current Redo management code repeats only redoes the last action which is the sorting of the selected range. Changing data in the selected range or selecting a new range are separate actions so you are essentially requesting to redo an action several actions before the latest actions. AFAICT, only the latest action is stored by the Redo manager.

It may be possible that Oracle's OpenOffice.org engineers can overhaul their Redo manager is such a way to implement this new feature, but it is realistically infeasible for me to implement.

Unfortunately, because of my limitations I think you have two choices:

1. Write a macro using OpenOffice.org Basic that does the various actions (like change data, change selected range, and then sort) that need to be done

2. Use Microsoft Excel

Regarding the second option, while you may not like buying Microsoft Office, Office is able to charge such a price because they have very specialized features that donation-based software like NeoOffice and OpenOffice do not have.

So whether to use Microsoft Excel or not is really a business decision: is the value of the time you save every day more than the price of Microsoft Office. If not, then the next business decision is the value of the time you save every day more than the time or cost of writing, debugging, and maintaining an OpenOffice.org Basic macro.

Patrick
Back to top
ovvldc
Captain Naiobi


Joined: Sep 13, 2004
Posts: 2352
Location: Zürich, CH

PostPosted: Thu Feb 18, 2010 4:44 pm    Post subject:

Also, keep in mind that Excel is not entirely flawless in term of undo/redo either. YMMV.

Best wishes,
Oscar

_________________
"What do you think of Western Civilization?"
"I think it would be a good idea!"
- Mohandas Karamchand Gandhi
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice New Feature Requests 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.