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] <[email protected]> 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: [email protected] 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
