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

On 07/20/12 20:49, Pedro wrote:
> rhubarbpieguy 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.
> Since this is a limitation of the ODF file format and that modifying the
> default template only applies to your PC (correct me if I'm wrong) wouldn't
> it make more sense to simply save it as XLS?
>
> I tested with your example and the user-defined time format is saved...
>
> --
> Pedro
>
>
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Date-format-macro-tp3996521p3996810.html
> Sent from the Users mailing list archive at Nabble.com.
Yes, XLS will save the format, but my macros don't carry over.

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