<div dir="ltr"><div dir="ltr"><br></div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure <<a href="mailto:jp@ledure.be">jp@ledure.be</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">FYI the number of sheets created in new Calc documents can be set to > 1 <br> by doing Options + LibreOffice Calc + Defaults.<br> <br> Maybe makes the test easier.<br></blockquote><div><br></div><div>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. </div><div>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.</div><div><br></div><div>Good job, thanks</div><font color="#888888"><div><br></div></font><div><span style="color:rgb(136,136,136)">Drew </span></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <br> Jean-Pierre<br> <br> Le 11/03/20 à 21:34, Drew Jensen a écrit :<br> > Actually as I think about it.<br> ><br> > Isn't one of the differences between AOO and LO that AOO creates a new <br> > calc file with multiple sheets and LO creates a new calc file with <br> > only one sheet.<br> ><br> > I don't think you can remove that last sheet, so perhaps that is it. A <br> > test should tell on that also.<br> ><br> > On Wed, Mar 11, 2020 at 4:31 PM Drew Jensen <br> > <<a href="mailto:drewjensen.inbox@gmail.com" target="_blank">drewjensen.inbox@gmail.com</a> <mailto:<a href="mailto:drewjensen.inbox@gmail.com" target="_blank">drewjensen.inbox@gmail.com</a>>> wrote:<br> ><br> > Interesting.<br> ><br> > Just did a search in the issue tracking system and there is an<br> > open issue regarding RemoveByName, but in a different context.<br> ><br> > Taking a quick look at that function and where it is called from<br> > it seems a quick test using a copy of that function should be a<br> > fairly quick exercise.<br> ><br> > Before I try that though, just to be sure; This basic module is<br> > embedded in the Calc file, yes?<br> ><br> > Thanks<br> ><br> > Drew<br> ><br> > On Wed, Mar 11, 2020 at 4:17 PM Andrew Pitonyak<br> > <<a href="mailto:andrew@pitonyak.org" target="_blank">andrew@pitonyak.org</a> <mailto:<a href="mailto:andrew@pitonyak.org" target="_blank">andrew@pitonyak.org</a>>> wrote:<br> ><br> > Not able to test for at least a week, but am curious what this<br> > causes an error.<br> ><br> > where it fails, it verifies is something by that name is there<br> > and then it tries to remove it. If I was able to run a test I<br> > could check to make sure that the method is exist, but the<br> > real question, is do you have write access to whatever it is<br> > is trying to modify?<br> ><br> > Sent from BlueMail <<a href="http://www.bluemail.me/r?b=15824" rel="noreferrer" target="_blank">http://www.bluemail.me/r?b=15824</a>><br> > On Mar 11, 2020, at 3:00 PM, Patrick Kariuki<br> > <<a href="mailto:patrick.kariuki@gmail.com" target="_blank">patrick.kariuki@gmail.com</a> <mailto:<a href="mailto:patrick.kariuki@gmail.com" target="_blank">patrick.kariuki@gmail.com</a>>><br> > wrote:<br> ><br> > I'm running a macro file on LibreOffice6.2.8.2 <<a href="http://6.2.8.2" rel="noreferrer" target="_blank">http://6.2.8.2</a>> and keep getting this<br> > -<a href="https://imgur.com/a/tpDocIu" rel="noreferrer" target="_blank">https://imgur.com/a/tpDocIu</a><br> ><br> > Error is on this code -<a href="https://pastebin.com/S9RtUWVK" rel="noreferrer" target="_blank">https://pastebin.com/S9RtUWVK</a> at Line 1327<br> ><br> > Please assist (I can send more information if required)<br> ><br> > Thanks.<br> > ------------------------------------------------------------------------<br> ><br> > LibreOffice mailing list<br> > <a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a> <mailto:<a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a>><br> > <a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br> ><br> > _______________________________________________<br> > LibreOffice mailing list<br> > <a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a><br> > <mailto:<a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a>><br> > <a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br> ><br> ><br> > _______________________________________________<br> > LibreOffice mailing list<br> > <a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a><br> > <a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br> _______________________________________________<br> LibreOffice mailing list<br> <a href="mailto:LibreOffice@lists.freedesktop.org" target="_blank">LibreOffice@lists.freedesktop.org</a><br> <a href="https://lists.freedesktop.org/mailman/listinfo/libreoffice" rel="noreferrer" target="_blank">https://lists.freedesktop.org/mailman/listinfo/libreoffice</a><br> </blockquote></div></div>