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

[Drew Jensen]

On Thu, Mar 12, 2020 at 7:58 AM 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.
>

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
> > <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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20200314/eceb95eb/attachment.htm>