Re: [libreoffice-users] Inserting date - still a problem

[Ricardo Berlasso]

2018-05-21 17:25 GMT+02:00 Peggy <33mar...@gmail.com>:

> I tried, Ricardo. But I get a pop up saying
>
> "Autotext for shortcut "fd" not found"
>

Sorry, I forgot to mention that for creating the autotext you need to open
the "AutoText" button at the bottom of the window and select "New".


>
>
> On Mon, May 21, 2018 at 11:05 AM, Ricardo Berlasso 
> wrote:
>
>> 2018-05-21 16:55 GMT+02:00 Peggy <33mar...@gmail.com>:
>>
>> > Last night I used the keyboard shortcut I made to insert the date.
>> > Unfortunately there was no choice that I could see to insert date
>> (fixed).
>> > This morning the date has changed to today's date. So I think I probably
>> > need a macro.
>> >
>>
>> An autotext will be easier: insert the fixed date field, select it and to
>> to Tools → Autotext, give it a name and a shortcut, something like
>> "fixed-date" and "fd" (no quotes) and accept. Now on any part of any
>> document type fd and press F3 to get the field.
>>
>>
>>
>> >
>> > I looked under Macros and have to enable JRE, which I think puts my
>> > computer more at risk for hackers etc. Not only that, the option seemed
>> to
>> > be to run a Macro already created, but I didn't see an option to record
>> the
>> > steps for a Macro. I don't suppose there is a work-around?
>> > Peggy
>> >
>> > --
>> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
>> > unsubscribe/
>> > Posting guidelines + more: https://wiki.documentfoundatio
>> n.org/Netiquette
>> > List archive: https://listarchives.libreoffice.org/global/users/
>> > All messages sent to this list will be publicly archived and cannot be
>> > deleted
>> >
>>
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un
>> subscribe/
>> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
>> List archive: https://listarchives.libreoffice.org/global/users/
>> All messages sent to this list will be publicly archived and cannot be
>> deleted
>>
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Inserting date - still a problem

[Ricardo Berlasso]

2018-05-21 16:55 GMT+02:00 Peggy <33mar...@gmail.com>:

> Last night I used the keyboard shortcut I made to insert the date.
> Unfortunately there was no choice that I could see to insert date (fixed).
> This morning the date has changed to today's date. So I think I probably
> need a macro.
>

An autotext will be easier: insert the fixed date field, select it and to
to Tools → Autotext, give it a name and a shortcut, something like
"fixed-date" and "fd" (no quotes) and accept. Now on any part of any
document type fd and press F3 to get the field.



>
> I looked under Macros and have to enable JRE, which I think puts my
> computer more at risk for hackers etc. Not only that, the option seemed to
> be to run a Macro already created, but I didn't see an option to record the
> steps for a Macro. I don't suppose there is a work-around?
> Peggy
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Robert Großkopf]

Hi T.R.,

Am 21.05.2018 um 16:46 schrieb T. R. Valentine:
> Why not use the default of +<;> (that's a semicolon)? 
> 
> Add the  to insert current time.

This is the default for Calc. There isn't any default for date ore time
in Writer. But the combination is free for using in Writer also. So you
could take this combination if you want and haven't used it for other
functionality.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] More on inserting date...

[Peggy]

I right clicked on the date, as someone advised me and the box popped up
with Date (fixed) highlighted. It's not supposed to have changed. I'll
check again tomorrow and see if it's changed again.

Thanks for being patient with me!
Peggy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Dan Lewis]

On 05/21/2018 10:46 AM, Dan Lewis wrote:

On 05/21/2018 09:57 AM, HBarr wrote:

Thanks Robert, that's very helpful.

Now, how would I change the result to -MM-DD?

Regards,

Howard

 This is a little more difficult, but not by much.

 Right click the date.
 Select Additional formats in the Format column.
 Enter what you want in the Format Code box.
 Click OK.

 If you then want to convert this to AutoText after changing the 
date format,

 Ctl+F3 opens AutoText dialog
 Type the name of it in the Name box.
  Modify the Shortcut name if desired.
  Click the AutoText button and select New(text only) from the 
list.

  Click closed.

Dan

OK, I left out one important point:
   After right clicking the date created by Ctrl+7, select 
Fields from the menu.

   Then select Additional formats in the Format column...

Dan


On 21 May 2018 at 21:50, Robert Großkopf  
wrote:

Hi Peggy,

there is no macro needed.

Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".

Now you could insert the current date with Ctrl+7.

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
unsubscribe/
Posting guidelines + more: 
https://wiki.documentfoundation.org/Netiquette

List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Inserting date - still a problem

[Peggy]

Last night I used the keyboard shortcut I made to insert the date.
Unfortunately there was no choice that I could see to insert date (fixed).
This morning the date has changed to today's date. So I think I probably
need a macro.

I looked under Macros and have to enable JRE, which I think puts my
computer more at risk for hackers etc. Not only that, the option seemed to
be to run a Macro already created, but I didn't see an option to record the
steps for a Macro. I don't suppose there is a work-around?
Peggy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[T. R. Valentine]

Why not use the default of +<;> (that's a semicolon)? The format
is dependent on Locale Setting.

Add the  to insert current time.

On 21 May 2018 at 07:50, Robert Großkopf  wrote:
> Hi Peggy,
>
> there is no macro needed.
>
> Open a Writer-document
> Go to
> Tools > Customize > Keyboard
> Type in "Functions": 'Date'
> Now look for a free Shortcut-Key, for example Ctrl+7.
> Click "Modify" on the right.
> Click "Save".
>
> Now you could insert the current date with Ctrl+7.
>
> Regards
>
> Robert
> --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted



-- 
T. R. Valentine
A rich heart may be under a poor coat.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Dan Lewis]

On 05/21/2018 09:57 AM, HBarr wrote:

Thanks Robert, that's very helpful.

Now, how would I change the result to -MM-DD?

Regards,

Howard

 This is a little more difficult, but not by much.

 Right click the date.
 Select Additional formats in the Format column.
 Enter what you want in the Format Code box.
 Click OK.

 If you then want to convert this to AutoText after changing the 
date format,

 Ctl+F3 opens AutoText dialog
 Type the name of it in the Name box.
  Modify the Shortcut name if desired.
  Click the AutoText button and select New(text only) from the 
list.

  Click closed.

Dan


On 21 May 2018 at 21:50, Robert Großkopf  
wrote:

Hi Peggy,

there is no macro needed.

Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".

Now you could insert the current date with Ctrl+7.

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Robert Großkopf]

Hi Howard,
> 
> Now, how would I change the result to -MM-DD?

Dubbelclick on the date. You get the dialog for changing the format.

I don't know how to change the standard - except to change the language
of the text to, for example, Englisch(Canadian).

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[HBarr]

Thanks Robert, that's very helpful.

Now, how would I change the result to -MM-DD?

Regards,

Howard

On 21 May 2018 at 21:50, Robert Großkopf  wrote:

> Hi Peggy,
>
> there is no macro needed.
>
> Open a Writer-document
> Go to
> Tools > Customize > Keyboard
> Type in "Functions": 'Date'
> Now look for a free Shortcut-Key, for example Ctrl+7.
> Click "Modify" on the right.
> Click "Save".
>
> Now you could insert the current date with Ctrl+7.
>
> Regards
>
> Robert
> --
> Homepage: http://robert.familiegrosskopf.de
> LibreOffice Community: http://robert.familiegrosskopf.de/map_3
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Jean-Francois Nifenecker]

Hi Philip,

Le 21/05/2018 à 13:10, Philip Jackson a écrit :

Note: the macro recorder is not available until you've activated the
corresponding option in Tools > Options > LibreOffice > Options, Enable
macro recording.


This will be (in some versions ?)  Tools > Options > LibreOffice >
Advanced, Enable macro recording.


Ahem. Yes, I stand corrected /o\

Anyway, Robert's solution is much faster!

Best regards,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Jean-Francois Nifenecker]

Hello Robert,

Le 21/05/2018 à 14:50, Robert Großkopf a écrit :


there is no macro needed.

Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".

Now you could insert the current date with Ctrl+7.


OMG! How did I overlook that?

Many thanks Robert!


All the best,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Robert Großkopf]

Hi Peggy,

there is no macro needed.

Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".

Now you could insert the current date with Ctrl+7.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Philip Jackson]

On 21/05/18 12:03, Jean-Francois Nifenecker wrote:
> While in Calc there's no need for a macro (the Ctrl + ; (semicolon)
> shortcut will do ;) such is not the case in Writer, yet.
> 
> So, yes, you need to create a macro then connect a keyboard shortcut to
> it. The process is quite simple if you use the macro recorder.
> 
> Here's how (longer to write than to execute) :
> 
> 1. Creating the macro using the macro recorder
> 
> Note: the macro recorder is not available until you've activated the
> corresponding option in Tools > Options > LibreOffice > Options, Enable
> macro recording.

This will be (in some versions ?)  Tools > Options > LibreOffice >
Advanced, Enable macro recording.

> 
> a. Open an empty Writer document
> 
> b. Goto Tools > Macro > Record macro
> (a macro recorder toolbar is displayed: you'll press the "Stop
> recording" button when you're done)
> 
> c. Hit Ctrl+F2 to call the Insert Fields dialog,
> 
> d. in the Document thumbnail select:
> 
> Type = Date
> Select = Date
> Format = select the wanted format
> 
> e. Clic Insert, then Close
> 
> f. Clic the "Stop recording" button
> 
> g. A dialog opens that allows you to save the macro code.
> Enter a name for your macro in Macro Name
> Save macro in : select MyMacros > Standard > Module1
> Click Save
> 
> (a sample of the macro code is given below)
> 
> 
> 2. Connecting the macro execution with a keyboard shortcut
> 
> a. Tools > Customize, Keyboard thumbnail
> 
> Shortcut Keys = choose an appropriate shortcut (Ctrl + ; might do...)
> Category = LibreOffice Macros -> MyMacros -> Standard -> Module1
> Function = select the macro created at step 1 above
> 
> b. Check the "Writer" radio button (the shortcut will be available in
> Writer only), then Modify which makes the shortcut appear in the Keys
> panel.
> 
> c. Validate OK
> 
> 
> From now on, pressing Ctrl + ; in Writer inserts the current date.
> 
> 
> 8< ---
> sub InsertCurrentDate
> 
> dim document   as object
> dim dispatcher as object
> 
> rem get access to the document
> document   = ThisComponent.CurrentController.Frame
> dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
> 
> dim args1(5) as new com.sun.star.beans.PropertyValue
> args1(0).Name = "Type"
> args1(0).Value = 0
> args1(1).Name = "SubType"
> args1(1).Value = 1
> args1(2).Name = "Name"
> args1(2).Value = ""
> args1(3).Name = "Content"
> args1(3).Value = "0"
> args1(4).Name = "Format"
> args1(4).Value = 10036    '
> args1(5).Name = "Separator"
> args1(5).Value = " "
> 
> dispatcher.executeDispatch(document, ".uno:InsertField", "", 0, args1())
> 
> end sub
>  >8

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Brian Barker]

At 05:25 21/05/2018 -0400, Michael Tiernan wrote:

Sorry for the untrimmed quote and top post Gmail client forces it like this.


This is simply untrue, of course. There is plenty of help out there 
on the web to show you how to do whatever you need. Please don't 
blame your tools or encourage others to copy your example.


Brian Barker 



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Jean-Francois Nifenecker]

Hello Peggy,

Le 21/05/2018 à 10:37, Peggy a écrit :

Years ago in Word Perfect there was a feature that allowed me to use a
shortcut key (even picking from a menu would be good) that inserted today's
date. Does Libre Writer have this feature?

I've never written a macro and the couple of instructions I've seen look
complicated. If there is no feature for this, would their be a way to write
a macro for the tecnically challenged?



While in Calc there's no need for a macro (the Ctrl + ; (semicolon) 
shortcut will do ;) such is not the case in Writer, yet.


So, yes, you need to create a macro then connect a keyboard shortcut to 
it. The process is quite simple if you use the macro recorder.


Here's how (longer to write than to execute) :

1. Creating the macro using the macro recorder

Note: the macro recorder is not available until you've activated the 
corresponding option in Tools > Options > LibreOffice > Options, Enable 
macro recording.


a. Open an empty Writer document

b. Goto Tools > Macro > Record macro
(a macro recorder toolbar is displayed: you'll press the "Stop 
recording" button when you're done)


c. Hit Ctrl+F2 to call the Insert Fields dialog,

d. in the Document thumbnail select:

Type = Date
Select = Date
Format = select the wanted format

e. Clic Insert, then Close

f. Clic the "Stop recording" button

g. A dialog opens that allows you to save the macro code.
Enter a name for your macro in Macro Name
Save macro in : select MyMacros > Standard > Module1
Click Save

(a sample of the macro code is given below)


2. Connecting the macro execution with a keyboard shortcut

a. Tools > Customize, Keyboard thumbnail

Shortcut Keys = choose an appropriate shortcut (Ctrl + ; might do...)
Category = LibreOffice Macros -> MyMacros -> Standard -> Module1
Function = select the macro created at step 1 above

b. Check the "Writer" radio button (the shortcut will be available in 
Writer only), then Modify which makes the shortcut appear in the Keys panel.


c. Validate OK


From now on, pressing Ctrl + ; in Writer inserts the current date.


8< ---
sub InsertCurrentDate

dim document   as object
dim dispatcher as object

rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

dim args1(5) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Type"
args1(0).Value = 0
args1(1).Name = "SubType"
args1(1).Value = 1
args1(2).Name = "Name"
args1(2).Value = ""
args1(3).Name = "Content"
args1(3).Value = "0"
args1(4).Name = "Format"
args1(4).Value = 10036  '
args1(5).Name = "Separator"
args1(5).Value = " "

dispatcher.executeDispatch(document, ".uno:InsertField", "", 0, args1())

end sub
 >8


HTH,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Tim Lloyd]

It's a while since I used this.

https://help.libreoffice.org/Common/Recording_a_Macro

From memory you record the macro into your template and all subsequent 
docs should inherit the macro.


HTH

Tim


On 21/05/18 19:25, Michael Tiernan wrote:

Sorry for the untrimmed quote and top post Gmail client forces it like
this.

I started to write a macro (and failed miserably) because I wanted to, in a
spreadsheet, enter today's date and time in a column (or two) that then
*never* updates again. All of my attempts at getting this to work (via
existing methods or by creating a macro) failed.

I simply had to accept that I had to enter it every time I I made an entry.

If I got it wrong l'd love to hear of a better way to do it.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Michael Tiernan]

Sorry for the untrimmed quote and top post Gmail client forces it like
this.

I started to write a macro (and failed miserably) because I wanted to, in a
spreadsheet, enter today's date and time in a column (or two) that then
*never* updates again. All of my attempts at getting this to work (via
existing methods or by creating a macro) failed.

I simply had to accept that I had to enter it every time I I made an entry.

If I got it wrong l'd love to hear of a better way to do it.
-- 
<< MCT >>   Michael C Tiernan.http://www.linkedin.com/in/mtiernan

Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein

On Mon, May 21, 2018, 4:49 AM Ricardo Berlasso  wrote:

> 2018-05-21 10:37 GMT+02:00 Peggy <33mar...@gmail.com>:
>
> > Years ago in Word Perfect there was a feature that allowed me to use a
> > shortcut key (even picking from a menu would be good) that inserted
> today's
> > date. Does Libre Writer have this feature?
> >
>
> Insert → Field → More fields → Document: under Type select Date and then if
> its fixed or should update any time you open the document. On the right
> column you can choose from different formats.
>
> Regards,
> Ricardo
>
>
>
> >
> > I've never written a macro and the couple of instructions I've seen look
> > complicated. If there is no feature for this, would their be a way to
> write
> > a macro for the tecnically challenged?
> >
> > Peggy
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
> > unsubscribe/
> > Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Jean-Baptiste Faure]

Le 21/05/2018 à 10:48, Ricardo Berlasso a écrit :

2018-05-21 10:37 GMT+02:00 Peggy <33mar...@gmail.com>:


Years ago in Word Perfect there was a feature that allowed me to use a
shortcut key (even picking from a menu would be good) that inserted today's
date. Does Libre Writer have this feature?



Insert → Field → More fields → Document: under Type select Date and then if
its fixed or should update any time you open the document. On the right
column you can choose from different formats.


And if you use this functionality often, you can create an autotext with 
the field and its formatting.


Best regards.
JBF

--
Seuls des formats ouverts peuvent assurer la pérennité de vos documents.
Disclaimer: my Internet Provider being located in France, each of our
exchanges over Internet will be scanned by French spying services.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Insert current date

[Ricardo Berlasso]

2018-05-21 10:37 GMT+02:00 Peggy <33mar...@gmail.com>:

> Years ago in Word Perfect there was a feature that allowed me to use a
> shortcut key (even picking from a menu would be good) that inserted today's
> date. Does Libre Writer have this feature?
>

Insert → Field → More fields → Document: under Type select Date and then if
its fixed or should update any time you open the document. On the right
column you can choose from different formats.

Regards,
Ricardo



>
> I've never written a macro and the couple of instructions I've seen look
> complicated. If there is no feature for this, would their be a way to write
> a macro for the tecnically challenged?
>
> Peggy
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-
> unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Insert current date

[Peggy]

Years ago in Word Perfect there was a feature that allowed me to use a
shortcut key (even picking from a menu would be good) that inserted today's
date. Does Libre Writer have this feature?

I've never written a macro and the couple of instructions I've seen look
complicated. If there is no feature for this, would their be a way to write
a macro for the tecnically challenged?

Peggy

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted