| View previous topic :: View next topic |
| Author |
Message |
mazarin
General User
Joined: 16 Feb 2009
Posts: 25
|
 Posted: Thu Apr 23, 2009 10:30 am Post subject: Link columns between two spreadsheets |
 |
|
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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu Apr 23, 2009 10:46 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
mazarin
General User
Joined: 16 Feb 2009
Posts: 25
|
| Posted: Thu Apr 23, 2009 10:58 am Post subject: |
|
|
| I could do that manualy, with = , but it surely wouldn´t be practical... |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Thu Apr 23, 2009 11:29 am Post subject: |
|
|
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 |
|
|
mazarin
General User
Joined: 16 Feb 2009
Posts: 25
|
| Posted: Thu Apr 23, 2009 11:47 am Post subject: |
|
|
| Sounds interesting, John V, let me try. |
|
| Back to top |
|
|
mazarin
General User
Joined: 16 Feb 2009
Posts: 25
|
| Posted: Thu Apr 30, 2009 9:10 am Post subject: |
|
|
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!  |
|
| Back to top |
|
|
|
