Re: Drop Down Menu in AOO4.1.1

2015-02-05 Thread Brian Barker
At 17:29 05/02/2015 -0500, Vince Bonly wrote: On 2/4/2015 3:31 PM, Brian Barker wrote: At 15:13 04/02/2015 -0500, Vince Bonly wrote: On Feb 4, 2015, at 13:55, Brian Barker wrote: From: Vince Bonly: Date: Wed, 04 Feb 2015 11:51:53 -0500 Does a feature exist whereby I can insert Today's Date in

Re: Drop Down Menu in AOO4.1.1

2015-02-05 Thread Vince-WA2RSX
Actually, what I need is "current date" whenever I reopen the spreadsheet. This will save me time and avoid typos, since I have fat fingers and poor vision! I do not need a time stamp included for my Oil Consumption calculations. I do not understand about the "F2, F9,Enter,Enter" sequence (i

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Brian Barker
At 15:13 04/02/2015 -0500, Vince Bonly wrote: On Feb 4, 2015, at 13:55, Brian Barker wrote: From: Vince Bonly: Date: Wed, 04 Feb 2015 11:51:53 -0500 Does a feature exist whereby I can insert Today's Date into a Calc cell? Try: o Enter =NOW() o F2; F9; Enter; Enter. After formatting the cell

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Vince B.
No problem. Regards, Vince Sent from my iPad > On Feb 4, 2015, at 14:48, Dave Barton wrote: > > Original Message > From: Brian Barker > To: users@openoffice.apache.org > Date: Wed, 04 Feb 2015 18:55:53 + > >> At 19:30 04/02/2015 +0100, Dave Barton wrote: >>> From: V

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Vince B.
After formatting the cells to Date (MMM D, ) your suggestion of =NOW() Worked splendidly; thanks! Regards, Vince Sent from my iPad > On Feb 4, 2015, at 13:55, Brian Barker wrote: > > At 19:30 04/02/2015 +0100, Dave Barton wrote: >> From: Vince Bonly: >> Date: Wed, 04 Feb 2015 11:51:

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Dave Barton
Original Message From: Brian Barker To: users@openoffice.apache.org Date: Wed, 04 Feb 2015 18:55:53 + > At 19:30 04/02/2015 +0100, Dave Barton wrote: >> From: Vince Bonly: >> Date: Wed, 04 Feb 2015 11:51:53 -0500 >>> Does a feature exist whereby I can insert Today's Date in

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Brian Barker
At 19:30 04/02/2015 +0100, Dave Barton wrote: From: Vince Bonly: Date: Wed, 04 Feb 2015 11:51:53 -0500 Does a feature exist whereby I can insert Today's Date into a Calc cell? Insert Today's Date = Hold down the keyboard "CTRL" key and press the ";" semicolon key. Er, is that in OpenOffice

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Dave Barton
Original Message From: Vince-WA2RSX To: users@openoffice.apache.org Date: Wed, 04 Feb 2015 11:51:53 -0500 > Hi Dennis: > > Yes, you have interpreted my meaning very nicely. > > OK; a calendar pop out (1) or an utility (2) would be a welcomed > addition to AOO Calc. > > Does

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Vince-WA2RSX
knowledge base at https://forum.openoffice.org/, -Original Message- From: Vince B. [mailto:wa.two...@verizon.net] Sent: Wednesday, January 28, 2015 14:38 To: users@openoffice.apache.org Subject: Re: Drop Down Menu in AOO4.1.1 There are no suggested values; I manually monitor data o

Re: Drop Down Menu in AOO4.1.1

2015-01-29 Thread NoOp
On 01/28/2015 08:19 AM, Vince-WA2RSX wrote: > I am using AOO AOO411m6(Build:9775) - Rev. 1617669 > 2014-08-13 09:06:54 (Mi, 13 Aug 2014) on WIN 8.2 Desktop. > > Can someone point me to info on creating a dropdown menu in a > Spreadsheet cell, if this is possible? > > I have created a spreadshee

Re: Drop Down Menu in AOO4.1.1

2015-01-28 Thread Brian Barker
At 17:37 28/01/2015 -0500, Vince Bonly wrote: There are no suggested values; ... That's strange: you said "a specific date" and I believed you! I manually monitor data on a random date (whenever I happen to be close to an elapsed time meter that is connected to my heating system. I write the

RE: Drop Down Menu in AOO4.1.1

2015-01-28 Thread Dennis E. Hamilton
e.org/, -Original Message- From: Vince B. [mailto:wa.two...@verizon.net] Sent: Wednesday, January 28, 2015 14:38 To: users@openoffice.apache.org Subject: Re: Drop Down Menu in AOO4.1.1 There are no suggested values; I manually monitor data on a random date (whenever I happen to be close to an el

Re: Drop Down Menu in AOO4.1.1

2015-01-28 Thread Vince B.
There are no suggested values; I manually monitor data on a random date (whenever I happen to be close to an elapsed time meter that is connected to my heating system. I write the data on paper, and note also the date. Then, I enter the collected data into my AOO spreadsheet. I am afraid I fa

Re: Drop Down Menu in AOO4.1.1

2015-01-28 Thread Brian Barker
At 11:19 28/01/2015 -0500, Vince Bonly wrote: Can someone point me to info on creating a dropdown menu in a Spreadsheet cell, if this is possible? I have created a spreadsheet to calculate Heating Fuel consumption, and frequently need to enter a specific date into a cell. A dropdown menu, I thi

Drop Down Menu in AOO4.1.1

2015-01-28 Thread Vince-WA2RSX
I am using AOO AOO411m6(Build:9775) - Rev. 1617669 2014-08-13 09:06:54 (Mi, 13 Aug 2014) on WIN 8.2 Desktop. Can someone point me to info on creating a dropdown menu in a Spreadsheet cell, if this is possible? I have created a spreadsheet to calculate Heating Fuel consumption, and frequently