On 09/24/10 16:28, Andy Thompson wrote:
we have 12 individual spreadsheets that are submitted by individuals
with our organization ... these spreadsheets are password protected
to open.
at corporate office we have an additonal spreadsheet that extracts
(via links) info from those 12 individual spreadsheets.
in Excel when we open the Corporate spreadsheet and respond that we
wish to update the linked data ... we are prompted for the 12
individual passwords related to the 12 individual spreadsheets.
in OpenOffice we are currently not prompted for the passwords to open
the 12 individual spreadsheets and all linked cells are displayed
with a #REF error.
Is this function possible and now do we set the corporate spreadsheet
to prompt for the 12 passwords if we are indicating to update the
linked data.
Sounds similar to issue 108404
(http://qa.openoffice.org/issues/show_bug.cgi?id=108404), but there the
result was zero values, not #REF. You could check if you get different
results with OOo 3.3.0 Beta.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
