[libreoffice-users] Help needed - LO has lost my database

2017-01-17 Thread ptoye
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

Re: [libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread Tanstaafl
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

Re: [libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread Tanstaafl
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

Re: [libreoffice-users] Macro/button to update link(s) to external sheet(s)

2017-01-17 Thread Tanstaafl
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 =

Re: [libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread Tanstaafl
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

Re: [libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread Tanstaafl
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

[libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread m.a.riosv
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

Re: [libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread Tim Lloyd
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

[libreoffice-users] Re: Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-17 Thread m.a.riosv
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.