Re: [users] Incrementing Calc cell value with 'button'

2008-05-25 Thread Dotan Cohen
2008/5/25 Jerry Feldman <[EMAIL PROTECTED]>: > WRT: Java. I also got a message. All I did was to go to > Tools/Options/OpenOffice.org/Java, and point it at your installed JRE. > I run SuSE 10.3, and I pointed it > to /usr/lib/jvm/java-1.6.0.u6-sun-1.6.0.u6/jre > > There are a number of web sites th

Re: [users] Incrementing Calc cell value with 'button'

2008-05-25 Thread Jerry Feldman
On Sun, 25 May 2008 09:03:33 +0300 "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > 2008/5/24 Jerry Feldman <[EMAIL PROTECTED]>: > > Here is a macro that I hard coded to increment a value in cell D2. I > > must admit that I found something similar online, but I need to start > > to learn OO.o macro lang

Re: [users] Incrementing Calc cell value with 'button'

2008-05-24 Thread Dotan Cohen
2008/5/24 Jerry Feldman <[EMAIL PROTECTED]>: > Here is a macro that I hard coded to increment a value in cell D2. I > must admit that I found something similar online, but I need to start > to learn OO.o macro languages in the next few weeks. > > Sub Incd2() > mynum = Range("d2") + 1 > Range("d2")

Re: [users] Incrementing Calc cell value with 'button'

2008-05-24 Thread Jerry Feldman
On Fri, 23 May 2008 11:28:12 +0300 "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > I have a calc sheet with a cell who's natural-number content must be > incremented ++1 several times a day. Instead of retyping the new > number over the old number, I would like to create a 'button' that > increments th

Re: [users] Incrementing Calc cell value with 'button'

2008-05-23 Thread Jerry Feldman
On Fri, 23 May 2008 17:09:08 +0300 "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > 2008/5/23 Jerry Feldman <[EMAIL PROTECTED]>: > > On Fri, 23 May 2008 11:28:12 +0300 > > "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > > > >> I have a calc sheet with a cell who's natural-number content must be > >> incremen

Re: [users] Incrementing Calc cell value with 'button'

2008-05-23 Thread Dotan Cohen
2008/5/23 Jerry Feldman <[EMAIL PROTECTED]>: > On Fri, 23 May 2008 11:28:12 +0300 > "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > >> I have a calc sheet with a cell who's natural-number content must be >> incremented ++1 several times a day. Instead of retyping the new >> number over the old number, I

Re: [users] Incrementing Calc cell value with 'button'

2008-05-23 Thread Jerry Feldman
On Fri, 23 May 2008 11:28:12 +0300 "Dotan Cohen" <[EMAIL PROTECTED]> wrote: > I have a calc sheet with a cell who's natural-number content must be > incremented ++1 several times a day. Instead of retyping the new > number over the old number, I would like to create a 'button' that > increments th

[users] Incrementing Calc cell value with 'button'

2008-05-23 Thread Dotan Cohen
I have a calc sheet with a cell who's natural-number content must be incremented ++1 several times a day. Instead of retyping the new number over the old number, I would like to create a 'button' that increments the value by 1. I'm thinking that a clever if condition might help, but I'm not getting