BASIC Runtime error (Property/method not found: Selectitem)

Creating a macro - Writing a Script - Using the API

BASIC Runtime error (Property/method not found: Selectitem)

Postby royalhd » Tue Aug 22, 2017 10:02 pm

Hi guys,

I've recently put a lot of sweat and tears into my beatiful Calc sheet, yet now that I'm trying to edit it a bit more I keep getting the same error when hitting 'apply' in the conditional formatting part. My sheet is build around conditional formatting, and I have an extra plug-in installed to be able to add more than the standard amount of formulas for one cell. Perhaps the sheet is too much? Because I have a lot (!) of condotional formatting for a lot of cells.

I am a total noob when it comes to Calc / Basic, So I did not touch the macros / code one bit as I have just been using the 'conditional formatting' window to edit. I've attached an image of the error below. It's really messing with my sheet and my progress, so I hope someone can help me out here!

edit: not sure if the image is displaying correctly. Here is the link if it doesn't: http://imgur.com/a/o4ywJ


Image
OpenOffice 4.1 on MacOSX 10.10.5 (Yosemite)
royalhd
 
Posts: 15
Joined: Wed May 24, 2017 2:24 pm

Re: BASIC Runtime error (Property/method not found: Selectit

Postby Zizi64 » Tue Aug 22, 2017 10:24 pm

Please upload the real code list - embedded into a sample ODF type document - here.
Last edited by Zizi64 on Tue Aug 22, 2017 11:03 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.3.2; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8464
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: BASIC Runtime error (Property/method not found: Selectit

Postby royalhd » Tue Aug 22, 2017 10:29 pm

So I've been looking around a bit and managed to find the part of code in the plug-in (CFPlus) that I've mentioned before that is giving the error. Not sure if adding it in a empty file and adding it here is what you requested, as I said: 100% unknown to this. If not: please explain and I'll edit a.s.a.p. tomorrow. This sheet is my lifeswork..! :lol:

note: the plug-in seems to be in French, this is new to me as well.
Attachments
code-part-error.odt
(28.53 KiB) Downloaded 75 times
OpenOffice 4.1 on MacOSX 10.10.5 (Yosemite)
royalhd
 
Posts: 15
Joined: Wed May 24, 2017 2:24 pm

Re: BASIC Runtime error (Property/method not found: Selectit

Postby royalhd » Tue Aug 22, 2017 10:36 pm

O, and this is the extension (not plug-in ;) that I'm talking about. I've downloaded it of an English website, so I'm just as lost as you are about the French part.

http://www.beaussier.com/sections/viewtopic.php?f=1&t=1580
OpenOffice 4.1 on MacOSX 10.10.5 (Yosemite)
royalhd
 
Posts: 15
Joined: Wed May 24, 2017 2:24 pm

Re: BASIC Runtime error (Property/method not found: Selectit

Postby Zizi64 » Tue Aug 22, 2017 11:03 pm

Please upload the real code list - embedded into a sample ODF type document - here.

It is a Calc related question.
I meant "with the code embedded into a Module of a sample .ods document" = a working example with some sample data in the cells.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.3.2; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8464
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: BASIC Runtime error (Property/method not found: Selectit

Postby royalhd » Wed Aug 23, 2017 8:20 am

Like so?

The error does not always appear and I haven't yet figured out what triggers it. In this example I have not gotten the error yet.
Attachments
example-forum.ods
(10.71 KiB) Downloaded 67 times
OpenOffice 4.1 on MacOSX 10.10.5 (Yosemite)
royalhd
 
Posts: 15
Joined: Wed May 24, 2017 2:24 pm

Re: BASIC Runtime error (Property/method not found: Selectit

Postby Villeroy » Wed Aug 23, 2017 12:10 pm

The document has no macros embedded and I can not find anything in that document that triggers any external macro. No document event, no sheet event, no form event, no form control event.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: BASIC Runtime error (Property/method not found: Selectit

Postby royalhd » Wed Aug 23, 2017 1:31 pm

As I obviously can't get these examples to work, would it be an option to send the originial document to someone trough PM?
OpenOffice 4.1 on MacOSX 10.10.5 (Yosemite)
royalhd
 
Posts: 15
Joined: Wed May 24, 2017 2:24 pm

Re: BASIC Runtime error (Property/method not found: Selectit

Postby Villeroy » Wed Aug 23, 2017 1:50 pm

Yes, PM is an option. I'll delete your file when the issue is resolved and you delete the attachment after I received your message (moved from "Outbox" to "Sent")
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: BASIC Runtime error (Property/method not found: Selectit

Postby Villeroy » Wed Aug 23, 2017 6:16 pm

You have to debug that Basic code. The file you sent me has no links to any Basic code.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: BASIC Runtime error (Property/method not found: Selectit

Postby royalhd » Mon Aug 28, 2017 6:00 pm

Thanks for checking!
OpenOffice 4.1 on MacOSX 10.10.5 (Yosemite)
royalhd
 
Posts: 15
Joined: Wed May 24, 2017 2:24 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests