2007/4/13, Andis Lazdinsh <[EMAIL PROTECTED]>:
Thank you! Address for insert time extension is http://www.ooomacros.org/user.php#128899 (unfortunately I couldn't find how to get it to work under OOO2.2 Linux). Address for insert time as text string macro is http://www.oooforum.org/forum/viewtopic.phtml?t=53133&highlight=string. The last question is how to convert this macro to function to use in formula, for instance, =if (A1;"";"";textstringnow)? Andis >> >> >> > > One other way would be to use script which enters NOW() as a string value. > Such script has been published on the forum ( www.oooforum.org ***) and > there is also a DATE/TIME tool on www.ooomacros.org . *** Search in the > Calc forum. If not found there, try Macros & API or Code Snippets. >
My first thought was that if you enter NOW() every time, those cells will update every time you enter something in another cell, which will cause ALL NOW()-cells to have the same value. To make the value stay by its first value, a macro or something else is reqiuired. One way is to create a dialog that contain a time field and a NOW button, or just create a NOW-button that automatically search for the first empty time cell and fills it in with the current time. Personally, I use a program called AllChars, which works in all applications (Windows only, unfortunately). With it I can create "macros" that let me insert current date and time in every application that accepts text input, such as OpenOffice.org, Notepad, Opera, any other web browser, anything, even in file save dialogs etc etc. Unfortunately it's not Open Source, but I think the author mentioned somewhere that he planned to make it Open Source, or maybemy memory is just messed up... Personally I created a macro called "ti" (meaning "time") with AllChars. To make run it, I enter a "<" and then the macro name. Of course the "<" can be something else, I think "/" is the default character, but that requires the shift key on a Swedish keyboard, so I went to settings and changed it to "<". To get the current time in my case, I just enter <ti (not too slow though but the time can be changed as well in the settings dialog) and it will be converted to the current time in the format selected by the user If I type that right now it will be changed to 21:16:12 (it's Swedish time, in case someone in another time zone wonders why it doesn't match the time this was sent). Even \t (tab key) and \n (Enter) can be included in the output text string. Search for AllChars with google if you want to know more about it. Johnny Andersson (which I wrote by typing "<ja"...)
