OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Probable bug in macro record CALC

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
GSD4ME
General User
General User


Joined: 16 Feb 2011
Posts: 13

PostPosted: Mon Jul 09, 2012 1:58 pm    Post subject: Probable bug in macro record CALC Reply with quote

Trying to automate an action sequence, I used the macro recording facility in CALC to obtain some code. However, there seems to be a bug here.


Open a new blank workbook
Tools>Macro>record macro
Place cursor on any cell
Place cursor against any *complete* row (eg select row 10)
Edit>Delete contents>Delete all
Stop recording
Save macro

Examine the saved macro and step through it if required
The actions carried out will only delete the contents of the *last* selected cell
(Can be verified by filling cells' contents with dummy data and observe what happens when the macro is run)
Unless anyone can fault the actions that I have detailed, will raise it as a bug on the appropriate site for Linux/Ubuntu/Open Office
Back to top
View user's profile Send private message
patel
Power User
Power User


Joined: 14 Apr 2012
Posts: 54
Location: Italy

PostPosted: Mon Jul 09, 2012 7:40 pm    Post subject: Reply with quote

you are right, but it is known that the macro recorder is very unreliable, if you want use macros you have to learn basic.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group