On Thu, Mar 12, 2020 at 7:58 AM Jean-Pierre Ledure <j...@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.in...@gmail.com <mailto:drewjensen.in...@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 > > <and...@pitonyak.org <mailto:and...@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.kari...@gmail.com <mailto:patrick.kari...@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@lists.freedesktop.org <mailto: > LibreOffice@lists.freedesktop.org> > > https://lists.freedesktop.org/mailman/listinfo/libreoffice > > > > _______________________________________________ > > LibreOffice mailing list > > LibreOffice@lists.freedesktop.org > > <mailto:LibreOffice@lists.freedesktop.org> > > https://lists.freedesktop.org/mailman/listinfo/libreoffice > > > > > > _______________________________________________ > > LibreOffice mailing list > > LibreOffice@lists.freedesktop.org > > https://lists.freedesktop.org/mailman/listinfo/libreoffice > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > https://lists.freedesktop.org/mailman/listinfo/libreoffice >
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice
