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