openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Johnny Rosenberg <gurus.knu...@gmail.com>
Subject Re: Click to add date or similar
Date Thu, 18 Apr 2013 21:15:33 GMT
2013/4/18 Wade Smart <wadesmart@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
> <gurus.knugum@gmail.com> wrote:
>> 2013/4/18 Wade Smart <wadesmart@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.m.barker@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


Mime
View raw message