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

Link columns between two spreadsheets

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


Joined: 16 Feb 2009
Posts: 25

PostPosted: Thu Apr 23, 2009 10:30 am    Post subject: Link columns between two spreadsheets Reply with quote

In some of my spreadsheets, I have a mix of confidencial and non-confidencial information, like this:

Product..| Units..|....Sale....|.Profit
---------------------------------------
Pencil.....|..203...|..487,20..|..42%
Rubber...|..356...|..543,00..|..38%
Stapler...|..195...|1560,00..|..32%
Poiter.....|..439...|..921,00..|..37%

A and B Columns can be seen by everyone, bu C and D columns contain confidencial information, that I would not like to show to anyone.

So, here is my question:

There´s a way to make a "clone" of a spreadsheet, where I can add only the C and D columns, i.e, the A and B columns are pulled from the original sheet, but the C and D exists only in the clone? The spreadsheet clone would be considered the "complete version" of original.

An alternative way to obtain what I want, is If it were possible to have blocked sheets (with password) in the same spreadsheet file, so I could keep the standard information on sheet 1, and the confidencial/complete information on the sheet 2.

Thanks!
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Thu Apr 23, 2009 10:46 am    Post subject: Reply with quote

You describe a typical database application. No, there is no document security as soon as you can read any file content. I can unhide/extract any hidden content in any Calc/Excel document I'm able to open.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
mazarin
General User
General User


Joined: 16 Feb 2009
Posts: 25

PostPosted: Thu Apr 23, 2009 10:58 am    Post subject: Reply with quote

I could do that manualy, with = , but it surely wouldn´t be practical...
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Apr 23, 2009 11:29 am    Post subject: Reply with quote

What you could do is create a macro library in the document other than the existing Standard. This new library can then be password protected and could contain a macro that first asks for a password and, if satisfied, calculates columns C & D.

This macro could then be tied to a button control in the document. Anyone can run the macro but only you know the requested password.
Back to top
View user's profile Send private message
mazarin
General User
General User


Joined: 16 Feb 2009
Posts: 25

PostPosted: Thu Apr 23, 2009 11:47 am    Post subject: Reply with quote

Sounds interesting, John V, let me try.
Back to top
View user's profile Send private message
mazarin
General User
General User


Joined: 16 Feb 2009
Posts: 25

PostPosted: Thu Apr 30, 2009 9:10 am    Post subject: Reply with quote

I´ve found a way to do what I want. It´s not the best way but it works.

In Cell Protection window, there an option named "Hide All". So, doing this on the cell range, and protecting the sheet with a password, we can hide all confidencial information.

We just can´t forget to protect the sheet before closing the file! Wink
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