[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 startup macro.
It's true - the MRI library has disappeared.

Then I tried reinstalling MRI. Clicking the Tools|Extension Manager menu
item did nothing the first time. Clicking it again gave me the window, but
when I clicked the "Add" button I got this:

 

Worse to come: when I opened my database and tried to access the tables in
it I got:

 

So now I can't load MRI and I can't get at my data.

Any ideas as to how I can get them both back - PLEASE!!



-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Help-needed-LO-has-lost-my-database-tp4205566.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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: 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 spreadsheets, 'A' and 'B'

Define column A in spreadsheet 'A' as Number/Currency, enter some
numbers in column A

Define column A in spreadsheet 'B' as Number/Currency, define formula to
reference column A in spreadsheet 'A', fill down to include rows in
spreadsheet 'A' with nothing in them

Sort column A in spreadsheet 'B' in descending order

Note that all of the blank cells are sorted ABOVE the ones with values,
when they should be sorted BELOW (treated as zeros, so less than any non
blank/zero value).

Sorting the same rows directly in spreadsheet 'A' puts the empty cells
BELOW the cells with values

-- 
To unsubscribe e-mail to: users+unsubscr...@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: 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 Tue Jan 17 2017 12:46:05 GMT-0500 (Eastern Standard Time), Tanstaafl
 wrote:
> 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 relative references to external
> spreadsheets (meaning, the reference assumes the referenced spreadsheet
> is in the same location/directory as the one calling it), I'd be most
> appreciative.
> 
> 
> On Tue Jan 17 2017 12:26:26 GMT-0500 (Eastern Standard Time), Tanstaafl
>  wrote:
>> 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 spreadsheets, 'A' and 'B'
>>
>> Define column A in spreadsheet 'A' as Number/Currency, enter some
>> numbers in column A
>>
>> Define column A in spreadsheet 'B' as Number/Currency, define formula to
>> reference column A in spreadsheet 'A', fill down to include rows in
>> spreadsheet 'A' with nothing in them
>>
>> Sort column A in spreadsheet 'B' in descending order
>>
>> Note that all of the blank cells are sorted ABOVE the ones with values,
>> when they should be sorted BELOW (treated as zeros, so less than any non
>> blank/zero value).
>>
>> Sorting the same rows directly in spreadsheet 'A' puts the empty cells
>> BELOW the cells with values
>>
> 
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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] 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 = thisComponent.SheetLinks.createEnumeration
   while oEnum.hasMoreElements
  oLink = oEnum.NextElement
  oLink.refresh
   wend
End Sub

Sub Main
end sub

On Mon Jan 16 2017 16:23:46 GMT-0500 (Eastern Standard Time), Cley Faye
 wrote:
> Ok, I can't test this right now, but this page might have an acceptable
> answer: http://blog.louic.nl/?p=622
> 
> The part about adding a nice button have a small macro in it. Here it's
> used for linked CSV files, but since the dialog asking to update links
> that's shown when you reload your file is the same, maybe the same
> procedure works.
> 
> Other than that I didn't find a quicker way to reload external references
> than file->reload->accept the dialog that asks for refresh :(
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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: 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 relative references to external
spreadsheets (meaning, the reference assumes the referenced spreadsheet
is in the same location/directory as the one calling it), I'd be most
appreciative.


On Tue Jan 17 2017 12:26:26 GMT-0500 (Eastern Standard Time), Tanstaafl
 wrote:
> 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 spreadsheets, 'A' and 'B'
> 
> Define column A in spreadsheet 'A' as Number/Currency, enter some
> numbers in column A
> 
> Define column A in spreadsheet 'B' as Number/Currency, define formula to
> reference column A in spreadsheet 'A', fill down to include rows in
> spreadsheet 'A' with nothing in them
> 
> Sort column A in spreadsheet 'B' in descending order
> 
> Note that all of the blank cells are sorted ABOVE the ones with values,
> when they should be sorted BELOW (treated as zeros, so less than any non
> blank/zero value).
> 
> Sorting the same rows directly in spreadsheet 'A' puts the empty cells
> BELOW the cells with values
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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: 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 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 Tue Jan 17 2017 12:46:05 GMT-0500 (Eastern Standard Time), Tanstaafl
>  wrote:
>> 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 relative references to external
>> spreadsheets (meaning, the reference assumes the referenced spreadsheet
>> is in the same location/directory as the one calling it), I'd be most
>> appreciative.
>>
>>
>> On Tue Jan 17 2017 12:26:26 GMT-0500 (Eastern Standard Time), Tanstaafl
>>  wrote:
>>> 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 spreadsheets, 'A' and 'B'
>>>
>>> Define column A in spreadsheet 'A' as Number/Currency, enter some
>>> numbers in column A
>>>
>>> Define column A in spreadsheet 'B' as Number/Currency, define formula to
>>> reference column A in spreadsheet 'A', fill down to include rows in
>>> spreadsheet 'A' with nothing in them
>>>
>>> Sort column A in spreadsheet 'B' in descending order
>>>
>>> Note that all of the blank cells are sorted ABOVE the ones with values,
>>> when they should be sorted BELOW (treated as zeros, so less than any non
>>> blank/zero value).
>>>
>>> Sorting the same rows directly in spreadsheet 'A' puts the empty cells
>>> BELOW the cells with values
>>>
>>
>>
> 
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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: 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 the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@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: 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 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 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 Tue Jan 17 2017 12:46:05 GMT-0500 (Eastern Standard Time), Tanstaafl
 wrote:

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 relative references to external
spreadsheets (meaning, the reference assumes the referenced spreadsheet
is in the same location/directory as the one calling it), I'd be most
appreciative.


On Tue Jan 17 2017 12:26:26 GMT-0500 (Eastern Standard Time), Tanstaafl
 wrote:

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 spreadsheets, 'A' and 'B'

Define column A in spreadsheet 'A' as Number/Currency, enter some
numbers in column A

Define column A in spreadsheet 'B' as Number/Currency, define formula to
reference column A in spreadsheet 'A', fill down to include rows in
spreadsheet 'A' with nothing in them

Sort column A in spreadsheet 'B' in descending order

Note that all of the blank cells are sorted ABOVE the ones with values,
when they should be sorted BELOW (treated as zeros, so less than any non
blank/zero value).

Sorting the same rows directly in spreadsheet 'A' puts the empty cells
BELOW the cells with values










--
To unsubscribe e-mail to: users+unsubscr...@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: 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.

-- 
To unsubscribe e-mail to: users+unsubscr...@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