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
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:
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
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
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
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
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
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