Re: [libreoffice-users] Re: Date format macro.

On 07/27/12 05:14, Andreas Säger wrote:
> 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.
Thank you!  That's a very good solution which I'll use - problem 
solved.  I also thank Johnny Rosenberg for his suggestion.


--
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