Quantcast

Alternate Method of Error Handling when Developing Basic Macros?

classic Classic list List threaded Threaded
17 messages Options
leeand00 leeand00
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Alternate Method of Error Handling when Developing Basic Macros?

Is there some way to redirect the output of errors to a logger instead of the standard popup dialog box when editing macros?

This runs really slow on my virtual machine.

Thank you,
   Andrew J. Leer
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Alternate Method of Error Handling when Developing Basic Macros?

Am 29.05.2012 22:15, leeand00 wrote:

> Is there some way to redirect the output of errors to a logger instead of the
> standard popup dialog box when editing macros?
>
> This runs really slow on my virtual machine.
>
> Thank you,
>     Andrew J. Leer
>
> --
> View this message in context: http://nabble.documentfoundation.org/Alternate-Method-of-Error-Handling-when-Developing-Basic-Macros-tp3986593.html
> Sent from the Users mailing list archive at Nabble.com.
>

Look up "Err function" in the Basic section of the F1-help index.


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

leeand00 leeand00
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Alternate Method of Error Handling when Developing Basic Macros?

Can this be enabled for an entire script instead of just for a single function or sub?
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Alternate Method of Error Handling when Developing Basic Macros?

Am 29.05.2012 23:26, leeand00 wrote:
> Can this be enabled for an entire script instead of just for a single
> function or sub?
>
> --
> View this message in context: http://nabble.documentfoundation.org/Alternate-Method-of-Error-Handling-when-Developing-Basic-Macros-tp3986593p3986617.html
> Sent from the Users mailing list archive at Nabble.com.
>

As far as I know this is not possible in Basic which has no reasoable
error handling. You can not even call another error handling routine.


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

leeand00 leeand00
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Alternate Method of Error Handling when Developing Basic Macros?

Okay....thanks! :)
Andrew Douglas Pitonyak Andrew Douglas Pitonyak
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Alternate Method of Error Handling when Developing Basic Macros?

In reply to this post by leeand00

On 05/29/2012 05:26 PM, leeand00 wrote:
> Can this be enabled for an entire script instead of just for a single
> function or sub?

If you are using StarBasic, checkout section  "3.10.  Error handling
using On Error" in this document: http://www.pitonyak.org/OOME_3_0.odt

If you use the on error mechanism, it will call that error handling
routine even if the error occurs in a different subroutine or function.

Oh, and no, the referenced document is not finished.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Emily Akin Emily Akin
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Installation problem Windows 7 and LO 3.5

I have tried to install Libre Office 3.5 multiple times on my Windows 7
64-bit machine. When I start the install, a message comes up saying to Close
LibreOffice Quickstarter 3.5. Nothing else is open. When I click OK. I get a
message that the install was interrupted with no choice but to End.

I have Open Office on my computer. Could something about Open Office be
interfering with the LibreOffice install?

Emily Akin


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

James Knott James Knott
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

Emily Akin wrote:

> I have tried to install Libre Office 3.5 multiple times on my Windows
> 7 64-bit machine. When I start the install, a message comes up saying
> to Close LibreOffice Quickstarter 3.5. Nothing else is open. When I
> click OK. I get a message that the install was interrupted with no
> choice but to End.
>
> I have Open Office on my computer. Could something about Open Office
> be interfering with the LibreOffice install?
>
> Emily Akin
>
>

I have both OO and LO installed on a Windows 7 system.  Did you close
the Quickstarter?


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tom Tom
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

In reply to this post by Emily Akin
Hi :)
Hopefully this guide might be useful
http://wiki.documentfoundation.org/Installing_in_parallel
I'm not sure how useful it is for Windows. 

Yes, OpenOffice does sound like it's interfering.  I think if you open up OpenOffice and go to

Tools - Options - Memory

and switch off the option at the bottom so that OpenOffice doesn't start-up when Windows starts-up but the guide probably goes into more detail.
Good luck, welcome in and regards from
Tom :) 


--- On Wed, 30/5/12, Emily Akin <[hidden email]> wrote:

From: Emily Akin <[hidden email]>
Subject: [libreoffice-users] Installation problem Windows 7 and LO 3.5
To: [hidden email]
Date: Wednesday, 30 May, 2012, 0:29

I have tried to install Libre Office 3.5 multiple times on my Windows 7 64-bit machine. When I start the install, a message comes up saying to Close LibreOffice Quickstarter 3.5. Nothing else is open. When I click OK. I get a message that the install was interrupted with no choice but to End.

I have Open Office on my computer. Could something about Open Office be interfering with the LibreOffice install?

Emily Akin


-- For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Thomas Taylor Thomas Taylor
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

In reply to this post by Emily Akin
On Tue, 29 May 2012 18:29:20 -0500
"Emily Akin" <[hidden email]> wrote about [libreoffice-users] Installation
problem Windows 7 and LO 3.5:

> I have tried to install Libre Office 3.5 multiple times on my Windows 7 64-bit
> machine. When I start the install, a message comes up saying to Clos e LibreOffice
> Quickstarter 3.5. Nothing else is open. When I click OK. I get a message that the
> install was interrupted with no choice but to End.
>
> I have Open Office on my computer. Could something about Open Office be
> interfering with the LibreOffice install?
>
> Emily Akin
>
>

Hi Emily :<)
OpenOffice probably is listed in the windows startup list. You can change this by
(as administrator) click on the startup icon and in the run box entering msconfig.
Go to the startup tab and delete OpenOffice.

Please, when you have a new subject, don't hijack an existing thread. Many mail
programs use thread information contained in the headers, NOT the subject.  If your
mail program shows threads you will observe that your message is in the middle
of a thread about "Alternate Method of Error Handling when Developing Basic Macros?".
Just changing the subject doesn't start a new thread.

This would help you have a better chance of getting a good answer as more people
would see the subject where they skip over threads (with your message in the
midst) that don't interest them.

Tom

--
“What we do for ourselves dies with us. What we do for others and the world
remains and is immortal.”  Albert Pine

Tom Taylor - retired penguin
AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2
openSUSE 12.1x86_64    openSUSE 12.2x86_64
KDE 4.7.2, FF 7.0      KDE 4.8.1, FF 10.0
claws-mail 3.8.0
registered linux user 263467
linxt-At-comcast-DoT-net

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Fernand Vanrie Fernand Vanrie
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

In reply to this post by Emily Akin
  Emily,

You must remove the Symphonie stuff, i had the same problem, only after
uninstall Symphonie i could update/install LO again

Hope it helps

Fernand

> I have tried to install Libre Office 3.5 multiple times on my Windows
> 7 64-bit machine. When I start the install, a message comes up saying
> to Close LibreOffice Quickstarter 3.5. Nothing else is open. When I
> click OK. I get a message that the install was interrupted with no
> choice but to End.
>
> I have Open Office on my computer. Could something about Open Office
> be interfering with the LibreOffice install?
>
> Emily Akin
>
>


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Kees de Jong Kees de Jong
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

LibreOffice Calc freezes when copy pasting data in spreadsheet

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,



How many people experience this problem:
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=50464
And of course what can we do about it? This problem is quite
persistent in my experience on different systems and on IRC I saw more
people complaining about it. Does someone have a solution or a
plan/initiative to work on a fix for this?



Thanks,
Kees
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQEcBAEBAgAGBQJPxdMOAAoJENRhrNqNnJdgSd4H/idExvXs3aR+WFEyRqaSLf3p
0hPSD20oOz579WuLez1QJ7tPn/L3ULrSvqqphrNYEKQCDFlwHJUBkMDnoz0HzlDj
ye8KiHN3owyOsjOHkhKEI2ldY8aWpEwhiYJr4mROKt6Pa3LBeEMxw/PJO4MV94sL
XIkfeKn04nD7Qy+vhYpbGYMq744LvBWr61fjtZdphN/ZivEDa1NDipt1jdqt1Cry
4RLHtQIZskV+zgPhRjOfgeFjzr92qQMMM3FhwbeHV34RXTZaj82wLNPOePZ0p0LW
qKsjFDXVQp3M/ax67DMLni+H8jObtpQz+9f/1dZpB7j6kwv9+NWurqWKs+DakhE=
=kg9n
-----END PGP SIGNATURE-----

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tom Tom
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

In reply to this post by Fernand Vanrie
Hi :)
Uninstalling OpenOffice, Symphony, Go-oo, Star Office, NeoOffice or other forks of the original StarOffice/OpenOffice is a good way to avoid conflicts but the guide on how to install 2 versions of LibreOffice should help you be able to keep those and just install LibreOffice alongside the existing ones. 

Of course we don't have the same problem with Caligra/KOffice, MS Office, Gnome Office or Google-docs because they don't share the same origins so you can have any or all those quite happily alongside LO with no problems. 

Regards from
Tom :)


--- On Wed, 30/5/12, Fernand Vanrie <[hidden email]> wrote:

From: Fernand Vanrie <[hidden email]>
Subject: Re: [libreoffice-users] Installation problem Windows 7 and LO 3.5
To: [hidden email]
Date: Wednesday, 30 May, 2012, 8:19

 Emily,

You must remove the Symphonie stuff, i had the same problem, only after uninstall Symphonie i could update/install LO again

Hope it helps

Fernand
> I have tried to install Libre Office 3.5 multiple times on my Windows 7 64-bit machine. When I start the install, a message comes up saying to Close LibreOffice Quickstarter 3.5. Nothing else is open. When I click OK. I get a message that the install was interrupted with no choice but to End.
>
> I have Open Office on my computer. Could something about Open Office be interfering with the LibreOffice install?
>
> Emily Akin
>
>


-- For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

NoOp NoOp
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

[HT] Re: LibreOffice Calc freezes when copy pasting data in spreadsheet

In reply to this post by Kees de Jong
On 05/30/2012 12:58 AM, Kees de Jong wrote:
> Hi all,
>
>
>
> How many people experience this problem:
...
Not sure. Perhaps if you start your own thread rather than merely
changing the subject line of the original thread:
Subject: Re: Installation problem Windows 7 and LO 3.5
In-Reply-To: <[hidden email]>
you'll get a response. Please start with a *new* email & subject
rather than hijacking an existing thread.




--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Emily Akin Emily Akin
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

In reply to this post by Thomas Taylor
Thanks to everyone who replied. I took Open Office out of startup, and
LibreOffice installed without a hitch.

-----Original Message-----
From: Thomas Taylor
Sent: Wednesday, May 30, 2012 12:38 AM
To: [hidden email]
Subject: Re: [libreoffice-users] Installation problem Windows 7 and LO 3.5

On Tue, 29 May 2012 18:29:20 -0500
"Emily Akin" <[hidden email]> wrote about [libreoffice-users]
Installation
problem Windows 7 and LO 3.5:

> I have tried to install Libre Office 3.5 multiple times on my Windows 7
> 64-bit
> machine. When I start the install, a message comes up saying to Clos e
> LibreOffice
> Quickstarter 3.5. Nothing else is open. When I click OK. I get a message
> that the
> install was interrupted with no choice but to End.
>
> I have Open Office on my computer. Could something about Open Office be
> interfering with the LibreOffice install?
>
> Emily Akin
>
>

Hi Emily :<)
OpenOffice probably is listed in the windows startup list. You can change
this by
(as administrator) click on the startup icon and in the run box entering
msconfig.
Go to the startup tab and delete OpenOffice.

Please, when you have a new subject, don't hijack an existing thread. Many
mail
programs use thread information contained in the headers, NOT the subject.
If your
mail program shows threads you will observe that your message is in the
middle
of a thread about "Alternate Method of Error Handling when Developing Basic
Macros?".
Just changing the subject doesn't start a new thread.

This would help you have a better chance of getting a good answer as more
people
would see the subject where they skip over threads (with your message in the
midst) that don't interest them.

Tom

--
“What we do for ourselves dies with us. What we do for others and the world
remains and is immortal.”  Albert Pine

Tom Taylor - retired penguin
AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2
openSUSE 12.1x86_64    openSUSE 12.2x86_64
KDE 4.7.2, FF 7.0      KDE 4.8.1, FF 10.0
claws-mail 3.8.0
registered linux user 263467
linxt-At-comcast-DoT-net

--
For unsubscribe instructions e-mail to: [hidden email]
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: LibreOffice Calc freezes when copy pasting data in spreadsheet

In reply to this post by Kees de Jong
Am 30.05.2012 09:58, Kees de Jong wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all,
>
>
>
> How many people experience this problem:
> https://www.libreoffice.org/bugzilla/show_bug.cgi?id=50464
> And of course what can we do about it? This problem is quite
> persistent in my experience on different systems and on IRC I saw more
> people complaining about it. Does someone have a solution or a
> plan/initiative to work on a fix for this?
>
>

A fix for what? You are the one and only person who struggles with this
and you refuse to reset your user profile. Quite often unspecific
problems can be cured by a simple profile reset.

There have been reports about the skype program interfering with
spreadsheet clipboards (Excel and Calc).
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=53983&p=235714&hilit=skype+excel#p235714
Other reports describe similar problems related to some 3rd party
clipboard manager.


--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Tom Tom
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Installation problem Windows 7 and LO 3.5

In reply to this post by Emily Akin
Hi :)
Nicely done :)

You might find that when you have a document open using 1 program you wont be able to open another program with the other although you can have multiple files open with either one as long as you stick to using the same one for each file.  If all files are closed you can choose which program to open with by right-clicking on the file and then something like

"Open with ..."

Good luck, congrats and regards from
Tom :)  



--- On Wed, 30/5/12, Emily Akin <[hidden email]> wrote:

From: Emily Akin <[hidden email]>
Subject: Re: [libreoffice-users] Installation problem Windows 7 and LO 3.5
To: [hidden email]
Date: Wednesday, 30 May, 2012, 20:16

Thanks to everyone who replied. I took Open Office out of startup, and LibreOffice installed without a hitch.

-----Original Message----- From: Thomas Taylor
Sent: Wednesday, May 30, 2012 12:38 AM
To: [hidden email]
Subject: Re: [libreoffice-users] Installation problem Windows 7 and LO 3.5

On Tue, 29 May 2012 18:29:20 -0500
"Emily Akin" <[hidden email]> wrote about [libreoffice-users] Installation
problem Windows 7 and LO 3.5:

> I have tried to install Libre Office 3.5 multiple times on my Windows 7 64-bit
> machine. When I start the install, a message comes up saying to Clos e LibreOffice
> Quickstarter 3.5. Nothing else is open. When I click OK. I get a message that the
> install was interrupted with no choice but to End.
>
> I have Open Office on my computer. Could something about Open Office be
> interfering with the LibreOffice install?
>
> Emily Akin
>
>

Hi Emily :<)
OpenOffice probably is listed in the windows startup list. You can change this by
(as administrator) click on the startup icon and in the run box entering msconfig.
Go to the startup tab and delete OpenOffice.

Please, when you have a new subject, don't hijack an existing thread. Many mail
programs use thread information contained in the headers, NOT the subject. If your
mail program shows threads you will observe that your message is in the middle
of a thread about "Alternate Method of Error Handling when Developing Basic Macros?".
Just changing the subject doesn't start a new thread.

This would help you have a better chance of getting a good answer as more people
would see the subject where they skip over threads (with your message in the
midst) that don't interest them.

Tom

-- “What we do for ourselves dies with us. What we do for others and the world
remains and is immortal.”  Albert Pine

Tom Taylor - retired penguin
AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2
openSUSE 12.1x86_64    openSUSE 12.2x86_64
KDE 4.7.2, FF 7.0      KDE 4.8.1, FF 10.0
claws-mail 3.8.0
registered linux user 263467
linxt-At-comcast-DoT-net

-- For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

--
For unsubscribe instructions e-mail to: [hidden email]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Loading...