You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Wade Smart <wa...@gmail.com> on 2013/04/18 02:16:24 UTC
Click to add date or similar
A friend of mine (in another state) is disabled and has difficulty
controlling the mouse.
He has a spread sheet that keeps track of all the things he has to do
in the day. Not
a to-do list per say but he has to put the date in the field each time
he does something.
In a column he wants to do something like the date picker. I dont have
any experience
with it other than playing with it today. I see how it works but I
dont see how to apply it
to every cell in a column without drawing it on every cell.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Click to add date or similar
Posted by Johnny Rosenberg <gu...@gmail.com>.
2013/4/18 Wade Smart <wa...@gmail.com>:
> Now that would be cool. Ill have to play with that. Ive not written
> many macros so this could be interesting. Good idea. Thanks :D
If you didn't write many macros I guess it could be tough, but with a
little help from this list, your favourite search engine, the X-ray
extension and maybe Andrew's macro document, I think it's doable, if
time is not an issue.
Johnny Rosenberg
>
> Wade
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
>
> On Thu, Apr 18, 2013 at 3:48 PM, Johnny Rosenberg
> <gu...@gmail.com> wrote:
>> 2013/4/18 Wade Smart <wa...@gmail.com>:
>>> --
>>> Registered Linux User: #480675
>>> Registered Linux Machine: #408606
>>> Linux since June 2005
>>>
>>>
>>> On Thu, Apr 18, 2013 at 11:05 AM, Brian Barker
>>> <b....@btinternet.com> wrote:
>>>> At 19:16 17/04/2013 -0500, Wade Smart wrote:
>>>>>
>>>>> A friend of mine (in another state) is disabled and has difficulty
>>>>> controlling the mouse. He has a spreadsheet that keeps track of all the
>>>>> things he has to do in the day. Not
>>>>> a to-do list per se but he has to put the date in the field each time he
>>>>> does something.
>>>>>
>>>>> In a column he wants to do something like the date picker. I don't have
>>>>> any experience with it other than playing with it today. I see how it works
>>>>> but I don't see how to apply it
>>>>>
>>>>> to every cell in a column without drawing it on every cell.
>>>>
>>>>
>>>> If you don't solve this in the way you hope, you may be able to create a
>>>> workaround by setting the facility up in one place - somewhere probably on
>>>> the same sheet but out of the way of your data or it could just be at the
>>>> head of the relevant column. Your friend can then pick the required date
>>>> there, copy it, and paste it into the required cells. He can copy and paste
>>>> using the keyboard, of course (Ctrl+C, Ctrl+V), and he can paste into
>>>> multiple cells by selecting the destination range first, using the arrow
>>>> keys along with the Shift key.
>>>>
>>>> I trust this helps.
>>>>
>>>> Brian Barker
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>>>> For additional commands, e-mail: users-help@openoffice.apache.org
>>>>
>>>
>>> That is about the only thing Ive thought of too that would work.
>>> I feel for him because simple things like point, click, copy, point,
>>> click, paste ..
>>> takes us seconds and him minutes per transaction.
>>>
>>> Thanks.
>>>
>>> Wade
>>
>>
>> It's possible to create one ”date picker” and let it trig a macro that
>> puts the selected date to the first empty cell in a specific row. I
>> don't know if that's a good idea in this case, but it's the first that
>> comes to my mind.
>>
>>
>> Johnny Rosenberg
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Click to add date or similar
Posted by Wade Smart <wa...@gmail.com>.
Now that would be cool. Ill have to play with that. Ive not written
many macros so this could be interesting. Good idea. Thanks :D
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Thu, Apr 18, 2013 at 3:48 PM, Johnny Rosenberg
<gu...@gmail.com> wrote:
> 2013/4/18 Wade Smart <wa...@gmail.com>:
>> --
>> Registered Linux User: #480675
>> Registered Linux Machine: #408606
>> Linux since June 2005
>>
>>
>> On Thu, Apr 18, 2013 at 11:05 AM, Brian Barker
>> <b....@btinternet.com> wrote:
>>> At 19:16 17/04/2013 -0500, Wade Smart wrote:
>>>>
>>>> A friend of mine (in another state) is disabled and has difficulty
>>>> controlling the mouse. He has a spreadsheet that keeps track of all the
>>>> things he has to do in the day. Not
>>>> a to-do list per se but he has to put the date in the field each time he
>>>> does something.
>>>>
>>>> In a column he wants to do something like the date picker. I don't have
>>>> any experience with it other than playing with it today. I see how it works
>>>> but I don't see how to apply it
>>>>
>>>> to every cell in a column without drawing it on every cell.
>>>
>>>
>>> If you don't solve this in the way you hope, you may be able to create a
>>> workaround by setting the facility up in one place - somewhere probably on
>>> the same sheet but out of the way of your data or it could just be at the
>>> head of the relevant column. Your friend can then pick the required date
>>> there, copy it, and paste it into the required cells. He can copy and paste
>>> using the keyboard, of course (Ctrl+C, Ctrl+V), and he can paste into
>>> multiple cells by selecting the destination range first, using the arrow
>>> keys along with the Shift key.
>>>
>>> I trust this helps.
>>>
>>> Brian Barker
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>>> For additional commands, e-mail: users-help@openoffice.apache.org
>>>
>>
>> That is about the only thing Ive thought of too that would work.
>> I feel for him because simple things like point, click, copy, point,
>> click, paste ..
>> takes us seconds and him minutes per transaction.
>>
>> Thanks.
>>
>> Wade
>
>
> It's possible to create one ”date picker” and let it trig a macro that
> puts the selected date to the first empty cell in a specific row. I
> don't know if that's a good idea in this case, but it's the first that
> comes to my mind.
>
>
> Johnny Rosenberg
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Click to add date or similar
Posted by Johnny Rosenberg <gu...@gmail.com>.
2013/4/18 Wade Smart <wa...@gmail.com>:
> --
> Registered Linux User: #480675
> Registered Linux Machine: #408606
> Linux since June 2005
>
>
> On Thu, Apr 18, 2013 at 11:05 AM, Brian Barker
> <b....@btinternet.com> wrote:
>> At 19:16 17/04/2013 -0500, Wade Smart wrote:
>>>
>>> A friend of mine (in another state) is disabled and has difficulty
>>> controlling the mouse. He has a spreadsheet that keeps track of all the
>>> things he has to do in the day. Not
>>> a to-do list per se but he has to put the date in the field each time he
>>> does something.
>>>
>>> In a column he wants to do something like the date picker. I don't have
>>> any experience with it other than playing with it today. I see how it works
>>> but I don't see how to apply it
>>>
>>> to every cell in a column without drawing it on every cell.
>>
>>
>> If you don't solve this in the way you hope, you may be able to create a
>> workaround by setting the facility up in one place - somewhere probably on
>> the same sheet but out of the way of your data or it could just be at the
>> head of the relevant column. Your friend can then pick the required date
>> there, copy it, and paste it into the required cells. He can copy and paste
>> using the keyboard, of course (Ctrl+C, Ctrl+V), and he can paste into
>> multiple cells by selecting the destination range first, using the arrow
>> keys along with the Shift key.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>
>
> That is about the only thing Ive thought of too that would work.
> I feel for him because simple things like point, click, copy, point,
> click, paste ..
> takes us seconds and him minutes per transaction.
>
> Thanks.
>
> Wade
It's possible to create one ”date picker” and let it trig a macro that
puts the selected date to the first empty cell in a specific row. I
don't know if that's a good idea in this case, but it's the first that
comes to my mind.
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Click to add date or similar
Posted by Wade Smart <wa...@gmail.com>.
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Thu, Apr 18, 2013 at 11:05 AM, Brian Barker
<b....@btinternet.com> wrote:
> At 19:16 17/04/2013 -0500, Wade Smart wrote:
>>
>> A friend of mine (in another state) is disabled and has difficulty
>> controlling the mouse. He has a spreadsheet that keeps track of all the
>> things he has to do in the day. Not
>> a to-do list per se but he has to put the date in the field each time he
>> does something.
>>
>> In a column he wants to do something like the date picker. I don't have
>> any experience with it other than playing with it today. I see how it works
>> but I don't see how to apply it
>>
>> to every cell in a column without drawing it on every cell.
>
>
> If you don't solve this in the way you hope, you may be able to create a
> workaround by setting the facility up in one place - somewhere probably on
> the same sheet but out of the way of your data or it could just be at the
> head of the relevant column. Your friend can then pick the required date
> there, copy it, and paste it into the required cells. He can copy and paste
> using the keyboard, of course (Ctrl+C, Ctrl+V), and he can paste into
> multiple cells by selecting the destination range first, using the arrow
> keys along with the Shift key.
>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
That is about the only thing Ive thought of too that would work.
I feel for him because simple things like point, click, copy, point,
click, paste ..
takes us seconds and him minutes per transaction.
Thanks.
Wade
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Click to add date or similar
Posted by Brian Barker <b....@btinternet.com>.
At 19:16 17/04/2013 -0500, Wade Smart wrote:
>A friend of mine (in another state) is disabled and has difficulty
>controlling the mouse. He has a spreadsheet that keeps track of all
>the things he has to do in the day. Not
>a to-do list per se but he has to put the date in the field each
>time he does something.
>
>In a column he wants to do something like the date picker. I don't
>have any experience with it other than playing with it today. I see
>how it works but I don't see how to apply it
>to every cell in a column without drawing it on every cell.
If you don't solve this in the way you hope, you may be able to
create a workaround by setting the facility up in one place -
somewhere probably on the same sheet but out of the way of your data
or it could just be at the head of the relevant column. Your friend
can then pick the required date there, copy it, and paste it into the
required cells. He can copy and paste using the keyboard, of course
(Ctrl+C, Ctrl+V), and he can paste into multiple cells by selecting
the destination range first, using the arrow keys along with the Shift key.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org
Re: Click to add date or similar
Posted by Steven Vollmer <sv...@yahoo.com>.
Add-on Python Calendar for Calc
Press Ctrl+Shift+F2 and then click on the date you want to input.
Good luck,
Steve
________________________________
From: Wade Smart <wa...@gmail.com>
To: ooo-users@incubator.apache.org
Sent: Wednesday, April 17, 2013 5:16 PM
Subject: Click to add date or similar
A friend of mine (in another state) is disabled and has difficulty
controlling the mouse.
He has a spread sheet that keeps track of all the things he has to do
in the day. Not
a to-do list per say but he has to put the date in the field each time
he does something.
In a column he wants to do something like the date picker. I dont have
any experience
with it other than playing with it today. I see how it works but I
dont see how to apply it
to every cell in a column without drawing it on every cell.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org