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

[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 <jp at ledure.be> 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
>> <drewjensen.inbox at gmail.com <mailto:drewjensen.inbox at 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
>>     <andrew at pitonyak.org <mailto:andrew at 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 <http://www.bluemail.me/r?b=15824>
>>         On Mar 11, 2020, at 3:00 PM, Patrick Kariuki
>>         <patrick.kariuki at gmail.com <mailto:patrick.kariuki at 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 at lists.freedesktop.org
>> <mailto:LibreOffice at lists.freedesktop.org>
>>             https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>>         _______________________________________________
>>         LibreOffice mailing list
>>         LibreOffice at lists.freedesktop.org
>>         <mailto:LibreOffice at lists.freedesktop.org>
>>         https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>>
>> _______________________________________________
>> LibreOffice mailing list
>> LibreOffice at lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
> _______________________________________________
> LibreOffice mailing list
> LibreOffice at lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>