[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
fruitjam wrote: How do I use find replace to fix all the formulas which have such lengthy reference statements? For starters, each cell would have to be checked for cell references, and then again checks will have to be conducted to identify those with apostrophes and spaces within the formulas. menu:EditFindReplace... Search: 'file:///e:/dox/pc's documents/street address.ods' Replace: 'file:///e:/dox/pc%27s documents/street address.ods' or with 2 single quotes: 'file:///e:/dox/pc''s documents/street address.ods' or with whatever file_URL you are going to use. I suggest file names without special characters. [More Options] Regular Expressions =OFF Search in: Formulas -- View this message in context: http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3306388.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
The apostrophe in pc's is the culprit. Encoding the spaces and the apostrophe may work: ='file:///e:/dox/pc%27s%20documents/street%20address.ods'#sheet1.e4 If not, remove the apostrophe from the folder name. -- View this message in context: http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3297881.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
Worked! Thanks! But how do I go about encoding several scores of links in a given spreadsheet? Do I have to manually edit all of those? Or is there a shortcut? I note that blank space, if present, in the sheet name need not be encoded. Yours respectfully, Fruitjam* *** On 31 August 2011 15:10, Andreas Säger [via Document Foundation Mail Archive] ml-node+3297881-396492129-425...@n3.nabble.com wrote: The apostrophe in pc's is the culprit. Encoding the spaces and the apostrophe may work: ='file:///e:/dox/pc%27s%20documents/street%20address.ods'#sheet1.e4 If not, remove the apostrophe from the folder name. -- 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-tp3297861p3297881.html To unsubscribe from Linking between two separate spreadsheets result in Err:509., click herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3297861code=ZnJ1aXRqYW1Ac2F0YWRydS5pbnwzMjk3ODYxfDg2NDk1NjQzOQ==. -- View this message in context: http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3297902.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
You can use findreplace to fix all your formulas. Programmers, administrators and web-designers use to avoid special characters in path names. Apart from that, it is *always* a bad idea to split sheets across documents. The target document keeps a copy of the referenced data anyway, so why not store all the sheets in a single document? -- View this message in context: http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3298121.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
How do I use find replace to fix all the formulas which have such lengthy reference statements? For starters, each cell would have to be checked for cell references, and then again checks will have to be conducted to identify those with apostrophes and spaces within the formulas. The problem is that I do not choose how my users manage their data across documents. My advice may not be heeded simply because the spreadsheets and their data come from varied sources. And therein lies the crux of the problem. Yours respectfully, Fruitjam On 31 August 2011 17:23, Andreas Säger [via Document Foundation Mail Archive] ml-node+3298121-78164131-425...@n3.nabble.com wrote: You can use findreplace to fix all your formulas. Programmers, administrators and web-designers use to avoid special characters in path names. Apart from that, it is *always* a bad idea to split sheets across documents. The target document keeps a copy of the referenced data anyway, so why not store all the sheets in a single document? -- 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-tp3297861p3298121.html To unsubscribe from Linking between two separate spreadsheets result in Err:509., click herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3297861code=ZnJ1aXRqYW1Ac2F0YWRydS5pbnwzMjk3ODYxfDg2NDk1NjQzOQ==. -- View this message in context: http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3298293.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
On 08/31/2011 05:53 AM, Andreas Säger wrote: The target document keeps a copy of the referenced data anyway, so why not store all the sheets in a single document? Because the primary doc may be used by an employee and that doc generates information the employee should have no access to. The second doc has the private data. This is useful when the primary doc uses a macro to generate the data for the second doc so the primary doc does NOT have a copy of the output of the macro. -- Bill Gradwohl Roatan, Honduras -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Linking between two separate spreadsheets result in Err:509.
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. -- View this message in context: http://nabble.documentfoundation.org/Linking-between-two-separate-spreadsheets-result-in-Err-509-tp3297861p3298526.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[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-425...@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 herehttp://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=3297861code=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+h...@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