I was debugging a macro in a database, using MRI and the Watch window) when
LO suddenly crashed. I can't remember exactly what I was doing when it
happened.
On restarting LO it first said that it couldn't find the MRI library, which
is loaded on application load. So I deleted the application
On Mon Jan 16 2017 18:16:28 GMT-0500 (Eastern Standard Time), m.a.riosv
wrote:
> Please could you share sample files to test?
I can't share the specific files, they contain sensitive financial
information.
But it should be easy to recreate...
Create two
Ok, I created two basic spreadsheets that demonstrate the problem, but
you'll have to adjust the formula for the file location on your computer
- unless someone can tell me how to make it just a relative reference
that assumes the called document is in the same location as the one
calling it.
On
Doesn't work for me but seems to try to do something.
The article is 4 years old and based on Openoffice - so maybe something
changed and someone here can spot the problem?
Here is the code from the linked article:
REM * BASIC *
Sub refreshAllSheetLinks()
oEnum =
Scratch this... I actually decided to go ahead and create these for
anyone who asked, but discovered these work as expected.
So, it must have something to do with the VLOOKUP I'm using. I'm working
on recreating these, and will follow-up once I'm done.
That said, if anyone knows how to use
Guess it would help to attach the files...
On Tue Jan 17 2017 13:01:13 GMT-0500 (Eastern Standard Time), Tanstaafl
wrote:
> Ok, I created two basic spreadsheets that demonstrate the problem, but
> you'll have to adjust the formula for the file location on your
Set up references as relative path is on:
Menu/Tools/Options/LibreOffice/Load-Save/General
Miguel Ángel.
--
View this message in context:
http://nabble.documentfoundation.org/Calc-blank-cell-not-treated-as-0-in-formula-when-referenced-from-external-file-sheet-tp4205236p4205612.html
Sent from
Hi, the list doesn't accept attachments. Best bet is either the web
based interface:
http://www.libreoffice.org/get-help/nabble/
Or use an online storage resource we can look at :)
Cheers
On 18/01/17 07:40, Tanstaafl wrote:
Guess it would help to attach the files...
On Tue Jan 17 2017
Please could you share sample files to test?
Miguel Ángel
--
View this message in context:
http://nabble.documentfoundation.org/Calc-blank-cell-not-treated-as-0-in-formula-when-referenced-from-external-file-sheet-tp4205236p4205510.html
Sent from the Users mailing list archive at Nabble.com.