You are not logged in.

#1 2012-04-10 07:05:16

cdwijs
Member
Registered: 2010-04-24
Posts: 310

Excel clone with file changed notification and merge option?

Hi All,

At my work, we use excell sheets. These are on a central fileserver. It happens that multiple people have the same file open, both make edits, and save them. Then the edit from the one that saved first are lost.

To solve this, I am looking for a spreadsheet that notices when somebody else alters the file, and then gives me the following dialog:
"The file has been altered by somebody else. Do you want to:
-reload the file
-see / merge the changes
-ignore


I have tried the following programs. I have run them on windows, I did not yet take the time to try it on linux yet.
microsoft excel: Does notice that somebody else has the file open, but does not see if there are actual changes in the file.
gnummeric on windows: This program does not notice any filechanges at all.
libreoffice on windows: This program does not notice any filechanges at all.

Do you know a program / plugin that does this?

Best regards,
Cedric

Offline

#2 2012-04-10 11:47:15

Trilby
Inspector Parrot
Registered: 2011-11-29
Posts: 30,557
Website

Re: Excel clone with file changed notification and merge option?

As much as I am *not* a fan of them, have you considered google-docs?  I don't know that they can do this, but they'd seem a likely candidate to check.


"UNIX is simple and coherent" - Dennis Ritchie; "GNU's Not Unix" - Richard Stallman

Offline

#3 2012-04-10 12:32:26

marxav
Member
From: Gatineau, PQ, Canada
Registered: 2006-09-24
Posts: 386

Re: Excel clone with file changed notification and merge option?

You would have better answers on an Excel forum.  But in Excel, you can enable share workbook to allow more than one person to work on the same workbook and allow merging.

Offline

#4 2012-04-10 16:32:07

cdwijs
Member
Registered: 2010-04-24
Posts: 310

Re: Excel clone with file changed notification and merge option?

@Trilby: The information in these sheets is confidential, so a commercial data mining company like google is not an option :-)

Thanks for the suggestion marxav. I will try that out. I hope openoffice and gnummeric also have something like this, I am trying to move away from microsoft office.

Best regards,
Cedric

Offline

Board footer

Powered by FluxBB