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:Edit>Find&Replace... 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: [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
