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

[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 
> <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