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

Automatically Save File

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
kgrabske
General User
General User


Joined: 11 May 2009
Posts: 5

PostPosted: Wed Sep 21, 2011 8:44 am    Post subject: Automatically Save File Reply with quote

I have a spreadsheet which I would like our manufacturing personnel to update periodically during the day. I would like to be able to view this spreadsheet (read-only) from my pc. My concern is that the person entering info into the spreadsheet will forget to click save, meaning that the read-only copy that I look at may not be up to date. Is there an extension or something that automatically the file to disk periodically?

Thanks,

Keith
_________________
Keith
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Sep 21, 2011 8:56 am    Post subject: Reply with quote

A simple database would be the most elegant solution.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
kgrabske
General User
General User


Joined: 11 May 2009
Posts: 5

PostPosted: Wed Sep 21, 2011 9:39 am    Post subject: Reply with quote

Villeroy,

I knew someone would suggest that. I was hoping for a down and dirty quick solution using a spreadsheet, because the development time would be minutes rather than hours.

I've tried to create a save macro and assign it to the "'Modified' status was changed" event, but my macro is unavailable for selection. Any thoughts as to why that would be the case?

Thanks,

Keith
_________________
Keith
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed Sep 21, 2011 11:14 am    Post subject: Reply with quote

Your request is explicit about daily usage with multi-user access and you do not want the users handle any documents.
A spreadsheet list would be a very quick one time solution where you may save 5 minutes of time and lose many hours over the weeks to come. Of course you can implement macros to imitate some database-ish mimicry. Nobody has ever be fired for writing bad Basic code.

http://www.oooforum.org/forum/viewtopic.phtml?t=113530
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
kgrabske
General User
General User


Joined: 11 May 2009
Posts: 5

PostPosted: Wed Sep 21, 2011 11:20 am    Post subject: Reply with quote

I already have the save macro. I just need to get it to work from the "'Modified' status was changed" event. I need (or would prefer) to have the macro stored in the spreadsheet file itself as this would lend it portability. I suppose I could live with having to create the macro and assignment on each machine that would run this, but it seems like a pain. Any other thoughts?
_________________
Keith
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 Calc 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