Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-17 Thread Patrick Kariuki 
Still doesn't work. I thought an upgrade would fix it but I now it
hangs while validating "Please wait while your sheet is being
validated"

On 3/12/20, Jean-Pierre Ledure  wrote:
> FYI the number of sheets created in new Calc documents can be set to > 1
> by doing Options + LibreOffice Calc + Defaults.
>
> Maybe makes the test easier.
>
> Jean-Pierre
>
> Le 11/03/20 à 21:34, Drew Jensen a écrit :
>> Actually as I think about it.
>>
>> Isn't one of the differences between AOO and LO that AOO creates a new
>> calc file with multiple sheets and LO creates a new calc file with
>> only one sheet.
>>
>> I don't think you can remove that last sheet, so perhaps that is it. A
>> test should tell on that also.
>>
>> On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen
>> mailto:drewjensen.in...@gmail.com>> wrote:
>>
>> Interesting.
>>
>> Just did a search in the issue tracking system and there is an
>> open issue regarding RemoveByName, but in a different context.
>>
>> Taking a quick look at that function and where it is called from
>> it seems a quick test using a copy of that function should be a
>> fairly quick exercise.
>>
>> Before I try that though, just to be sure; This basic module is
>> embedded in the Calc file, yes?
>>
>> Thanks
>>
>> Drew
>>
>> On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak
>> mailto:and...@pitonyak.org>> wrote:
>>
>> Not able to test for at least a week, but am curious what this
>> causes an error.
>>
>> where it fails, it verifies is something by that name is there
>> and then it tries to remove it. If I was able to run a test I
>> could check to make sure that the method is exist, but the
>> real question, is do you have write access to whatever it is
>> is trying to modify?
>>
>> Sent from BlueMail 
>> On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
>> mailto:patrick.kari...@gmail.com>>
>> wrote:
>>
>> I'm running a macro file on LibreOffice6.2.8.2
>>   and keep getting this
>> -https://imgur.com/a/tpDocIu
>>
>> Error is on this code -https://pastebin.com/S9RtUWVK  at Line
>> 1327
>>
>> Please assist (I can send more information if required)
>>
>> Thanks.
>>
>> 
>>
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> 
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> 
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>>
>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-14 Thread Drew Jensen 
On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure  wrote:

> FYI the number of sheets created in new Calc documents can be set to > 1
> by doing Options + LibreOffice Calc + Defaults.
>
> Maybe makes the test easier.
>

Indeed - the basic code was hard wired to expect three sheets in a new Calc
file and wanted to delete two. Changing the options setting from 1 to 3
allows it to run that function.
In fact the error was actually in a basic function called from an event
handler and the BAISC error dialog, and UI, was pointing at the calling
function not where the actual error happened.

Good job, thanks

Drew


>
> Jean-Pierre
>
> Le 11/03/20 à 21:34, Drew Jensen a écrit :
> > Actually as I think about it.
> >
> > Isn't one of the differences between AOO and LO that AOO creates a new
> > calc file with multiple sheets and LO creates a new calc file with
> > only one sheet.
> >
> > I don't think you can remove that last sheet, so perhaps that is it. A
> > test should tell on that also.
> >
> > On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen
> > mailto:drewjensen.in...@gmail.com>> wrote:
> >
> > Interesting.
> >
> > Just did a search in the issue tracking system and there is an
> > open issue regarding RemoveByName, but in a different context.
> >
> > Taking a quick look at that function and where it is called from
> > it seems a quick test using a copy of that function should be a
> > fairly quick exercise.
> >
> > Before I try that though, just to be sure; This basic module is
> > embedded in the Calc file, yes?
> >
> > Thanks
> >
> > Drew
> >
> > On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak
> > mailto:and...@pitonyak.org>> wrote:
> >
> > Not able to test for at least a week, but am curious what this
> > causes an error.
> >
> > where it fails, it verifies is something by that name is there
> > and then it tries to remove it. If I was able to run a test I
> > could check to make sure that the method is exist, but the
> > real question, is do you have write access to whatever it is
> > is trying to modify?
> >
> > Sent from BlueMail 
> > On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
> > mailto:patrick.kari...@gmail.com>>
> > wrote:
> >
> > I'm running a macro file on LibreOffice6.2.8.2  <
> http://6.2.8.2>  and keep getting this
> > -https://imgur.com/a/tpDocIu
> >
> > Error is on this code -https://pastebin.com/S9RtUWVK  at
> Line 1327
> >
> > Please assist (I can send more information if required)
> >
> > Thanks.
> >
>  
> >
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org   LibreOffice@lists.freedesktop.org>
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > 
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-14 Thread Drew Jensen 
On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure  wrote:

> FYI the number of sheets created in new Calc documents can be set to > 1
> by doing Options + LibreOffice Calc + Defaults.
>
> Maybe makes the test easier.
>

Indeed - the basic code was hard wired to expect three sheets in a new Calc
file and wanted to delete two. Changing the options setting from 1 to 3
allows it to run that function.

Good job, thanks

Drew

>
> Jean-Pierre
>
> Le 11/03/20 à 21:34, Drew Jensen a écrit :
> > Actually as I think about it.
> >
> > Isn't one of the differences between AOO and LO that AOO creates a new
> > calc file with multiple sheets and LO creates a new calc file with
> > only one sheet.
> >
> > I don't think you can remove that last sheet, so perhaps that is it. A
> > test should tell on that also.
> >
> > On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen
> > mailto:drewjensen.in...@gmail.com>> wrote:
> >
> > Interesting.
> >
> > Just did a search in the issue tracking system and there is an
> > open issue regarding RemoveByName, but in a different context.
> >
> > Taking a quick look at that function and where it is called from
> > it seems a quick test using a copy of that function should be a
> > fairly quick exercise.
> >
> > Before I try that though, just to be sure; This basic module is
> > embedded in the Calc file, yes?
> >
> > Thanks
> >
> > Drew
> >
> > On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak
> > mailto:and...@pitonyak.org>> wrote:
> >
> > Not able to test for at least a week, but am curious what this
> > causes an error.
> >
> > where it fails, it verifies is something by that name is there
> > and then it tries to remove it. If I was able to run a test I
> > could check to make sure that the method is exist, but the
> > real question, is do you have write access to whatever it is
> > is trying to modify?
> >
> > Sent from BlueMail 
> > On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
> > mailto:patrick.kari...@gmail.com>>
> > wrote:
> >
> > I'm running a macro file on LibreOffice6.2.8.2  <
> http://6.2.8.2>  and keep getting this
> > -https://imgur.com/a/tpDocIu
> >
> > Error is on this code -https://pastebin.com/S9RtUWVK  at
> Line 1327
> >
> > Please assist (I can send more information if required)
> >
> > Thanks.
> >
>  
> >
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org   LibreOffice@lists.freedesktop.org>
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > 
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> >
> >
> > ___
> > LibreOffice mailing list
> > LibreOffice@lists.freedesktop.org
> > https://lists.freedesktop.org/mailman/listinfo/libreoffice
> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-12 Thread Jean-Pierre Ledure 
FYI the number of sheets created in new Calc documents can be set to > 1 
by doing Options + LibreOffice Calc + Defaults.


Maybe makes the test easier.

Jean-Pierre

Le 11/03/20 à 21:34, Drew Jensen a écrit :

Actually as I think about it.

Isn't one of the differences between AOO and LO that AOO creates a new 
calc file with multiple sheets and LO creates a new calc file with 
only one sheet.


I don't think you can remove that last sheet, so perhaps that is it. A 
test should tell on that also.


On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen 
mailto:drewjensen.in...@gmail.com>> wrote:


Interesting.

Just did a search in the issue tracking system and there is an
open issue regarding RemoveByName, but in a different context.

Taking a quick look at that function and where it is called from
it seems a quick test using a copy of that function should be a
fairly quick exercise.

Before I try that though, just to be sure; This basic module is
embedded in the Calc file, yes?

Thanks

Drew

On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak
mailto:and...@pitonyak.org>> wrote:

Not able to test for at least a week, but am curious what this
causes an error.

where it fails, it verifies is something by that name is there
and then it tries to remove it. If I was able to run a test I
could check to make sure that the method is exist, but the
real question, is do you have write access to whatever it is
is trying to modify?

Sent from BlueMail 
On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
mailto:patrick.kari...@gmail.com>>
wrote:

I'm running a macro file on LibreOffice6.2.8.2    
and keep getting this
-https://imgur.com/a/tpDocIu

Error is on this code -https://pastebin.com/S9RtUWVK  at Line 1327

Please assist (I can send more information if required)

Thanks.



LibreOffice mailing list
LibreOffice@lists.freedesktop.org  

https://lists.freedesktop.org/mailman/listinfo/libreoffice

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org

https://lists.freedesktop.org/mailman/listinfo/libreoffice


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-11 Thread Drew Jensen 
Actually as I think about it.

Isn't one of the differences between AOO and LO that AOO creates a new calc
file with multiple sheets and LO creates a new calc file with only one
sheet.

I don't think you can remove that last sheet, so perhaps that is it. A test
should tell on that also.

On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen 
wrote:

> Interesting.
>
> Just did a search in the issue tracking system and there is an open issue
> regarding RemoveByName, but in a different context.
>
> Taking a quick look at that function and where it is called from it seems
> a quick test using a copy of that function should be a
> fairly quick exercise.
>
> Before I try that though, just to be sure; This basic module is embedded
> in the Calc file, yes?
>
> Thanks
>
> Drew
>
> On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak 
> wrote:
>
>> Not able to test for at least a week, but am curious what this causes an
>> error.
>>
>> where it fails, it verifies is something by that name is there and then
>> it tries to remove it. If I was able to run a test I could check to make
>> sure that the method is exist, but the real question, is do you have write
>> access to whatever it is is trying to modify?
>>
>> Sent from BlueMail 
>> On Mar 11, 2020, at 3:00 PM, Patrick Kariuki 
>> wrote:
>>>
>>> I'm running a macro file on LibreOffice 6.2.8.2 and keep getting this
>>> - https://imgur.com/a/tpDocIu
>>>
>>> Error is on this code - https://pastebin.com/S9RtUWVK at Line 1327
>>>
>>> Please assist (I can send more information if required)
>>>
>>> Thanks.
>>> --
>>>
>>> LibreOffice mailing list
>>> LibreOffice@lists.freedesktop.org
>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>>
>>> ___
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-11 Thread Drew Jensen 
Interesting.

Just did a search in the issue tracking system and there is an open issue
regarding RemoveByName, but in a different context.

Taking a quick look at that function and where it is called from it seems a
quick test using a copy of that function should be a fairly quick exercise.

Before I try that though, just to be sure; This basic module is embedded in
the Calc file, yes?

Thanks

Drew

On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak  wrote:

> Not able to test for at least a week, but am curious what this causes an
> error.
>
> where it fails, it verifies is something by that name is there and then it
> tries to remove it. If I was able to run a test I could check to make sure
> that the method is exist, but the real question, is do you have write
> access to whatever it is is trying to modify?
>
> Sent from BlueMail 
> On Mar 11, 2020, at 3:00 PM, Patrick Kariuki 
> wrote:
>>
>> I'm running a macro file on LibreOffice 6.2.8.2 and keep getting this
>> - https://imgur.com/a/tpDocIu
>>
>> Error is on this code - https://pastebin.com/S9RtUWVK at Line 1327
>>
>> Please assist (I can send more information if required)
>>
>> Thanks.
>> --
>>
>> LibreOffice mailing list
>> LibreOffice@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>> ___
> LibreOffice mailing list
> LibreOffice@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-11 Thread Andrew Pitonyak 
Not able to test for at least a week, but am curious what this causes an error.

where it fails, it verifies is something by that name is there and then it 
tries to remove it. If I was able to run a test I could check to make sure that 
the method is exist, but the real question, is do you have write access to 
whatever it is is trying to modify?

⁣Sent from BlueMail ​

On Mar 11, 2020, 3:00 PM, at 3:00 PM, Patrick Kariuki 
 wrote:
>I'm running a macro file on LibreOffice 6.2.8.2 and keep getting this
>- https://imgur.com/a/tpDocIu
>
>Error is on this code - https://pastebin.com/S9RtUWVK at Line 1327
>
>Please assist (I can send more information if required)
>
>Thanks.
>___
>LibreOffice mailing list
>LibreOffice@lists.freedesktop.org
>https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

How do I get rid of this error? Macro file requires OpenOffice but I would like to use Libreoffice

2020-03-11 Thread Patrick Kariuki 
I'm running a macro file on LibreOffice 6.2.8.2 and keep getting this
- https://imgur.com/a/tpDocIu

Error is on this code - https://pastebin.com/S9RtUWVK at Line 1327

Please assist (I can send more information if required)

Thanks.
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice