[libreoffice-users] Re: Date format macro.

[Andreas Säger <villeroy@t-online.de>]

Am 19.07.2012 23:48, rhubarbpieguy@gmail.com wrote:
> I'd like to create a macro for a user-defined date format (H:MMa/p).  As
> examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
> create the format manually, but I understand the LibreOffice format
> can't save user-defined formats.  So my thought is to create a macro
> which creates the format each time the spreadsheet is opened.  The
> user-defined Format Code is for a saved Style.
>
> The macro records without incident and the date format is correct.
> However, running the saved macro doesn't change the format.  It seems
> this should work.  Thoughts?  The recorded macro is as follows:

Hello,

The issue is a known one (AOO bug #66842). The office seems to support 
some format codes that have no equivalent expression in the ODF standard.
It has been discussed in a productive manner here:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=53724
http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=55344

I attached simple Basic macro to a demo document:
http://user.services.openoffice.org/en/forum/download/file.php?id=14598

It links number formats to cell styles so the newly generated number 
formats applies to all the cells where the style is in use.

Hope this helps,
A.S.


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