On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure <jp@xxxxxxxxx> 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@xxxxxxxxx <mailto:drewjensen.inbox@xxxxxxxxx>> 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@xxxxxxxxxxxx <mailto:andrew@xxxxxxxxxxxx>> 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@xxxxxxxxx <mailto:patrick.kariuki@xxxxxxxxx>>
> 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@xxxxxxxxxxxxxxxxxxxxx <mailto:LibreOffice@xxxxxxxxxxxxxxxxxxxxx>
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
> _______________________________________________
> LibreOffice mailing list
> LibreOffice@xxxxxxxxxxxxxxxxxxxxx
> <mailto:LibreOffice@xxxxxxxxxxxxxxxxxxxxx>
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>
>
> _______________________________________________
> LibreOffice mailing list
> LibreOffice@xxxxxxxxxxxxxxxxxxxxx
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
_______________________________________________
LibreOffice mailing list
LibreOffice@xxxxxxxxxxxxxxxxxxxxx
https://lists.freedesktop.org/mailman/listinfo/libreoffice
_______________________________________________ LibreOffice mailing list LibreOffice@xxxxxxxxxxxxxxxxxxxxx https://lists.freedesktop.org/mailman/listinfo/libreoffice
