[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.

Converting the data into database is not an option that users in my
workplace are keen to explore. Spreadsheets are quick, less time-consuming
when it comes to presenting reports on the fly for most.

I had the notion that LibreOffice supports MS Office 2010 spreadsheet links.
But I was taken aback when it was pointed out that references to external
workbooks created using MS Office 2010 do not even show up when opened in
LibreOffice Calc. Can you help me explain as to why that can possibly
happen?

For example, a cell containing a ROUND function with reference to a cell in
another workbook shows up as only ROUND(,2) when the spreadsheet is opened
in LibreOffice Calc.

Yours respectfully,
Fruitjam


On 31 August 2011 19:58, Andreas Säger [via Document Foundation Mail
Archive] <ml-node+3298526-880307497-425829@n3.nabble.com> wrote:

> Well, you are in the ugly trap of "document security" which simply does not
> exist. Once the document is loaded, all referenced data are freely
> accessible by means of formulas, macros or using your web browser
> (content.xml).
> In case of URL links the data are embedded in the document, which is why
> all formulas continue working even when the referenced files are
> unavaillable.
> In case of DDE links the referenced documents are loaded invisibly.
>
> A simple database could solve all of your problems. I learned this lesson
> 12 years ago when my Excel/VBA solution caused considerable financial damage
> and a database developer developed a solution within 3 days where I spent
> hundreds of hours with VBA and interrelated spreadsheets.
>
> ------------------------------
>  If you reply to this email, your message will be added to the discussion
> below:
>
> http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3298526.html
>  To unsubscribe from Linking between two separate spreadsheets result in
> Err:509., click 
> here<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3297861&code=ZnJ1aXRqYW1Ac2F0YWRydS5pbnwzMjk3ODYxfDg2NDk1NjQzOQ==>.


--
View this message in context: 
http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3300269.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted