> -----Original Message----- > From: TerryJ [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 03, 2007 7:51 AM > > > I have two password-protected spreadsheets. One spreadsheet references > > cells in the other spreadsheet and if source is closed then Calc would > > not ask for a password. > > Is there any workaround (while we wait for issue 24535 to be fixed)? > > > > Hello. I don't use password protection. I take it that the problem is > that > a reference to a cell in a protected document does NOT return the data in > the referenced cell. > > Standard references rely on a hidden copy of the sheet in the document > which > contains the reference, so I do not see how OOo would manage the process > if > such a reference were possible. It would mean, in effect, that part of a > protected document became embedded in a document which is unprotected.
Yep, makes sense (your explanation, not the way Office works). > > Have you tried a DDE entry instead of the standard reference? Looks like I would have to. Thanks a lot for your answer (somehow I missed it with openoffice.org being down). WBR, KP. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
