{"id":1695,"date":"2016-04-20T16:16:57","date_gmt":"2016-04-21T00:16:57","guid":{"rendered":"http:\/\/systemsolver.com\/StatlerBlog\/?p=1695"},"modified":"2016-04-20T16:16:57","modified_gmt":"2016-04-21T00:16:57","slug":"libre-writer-macro-for-date-fails-heres-the-fix","status":"publish","type":"post","link":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/2016\/04\/20\/libre-writer-macro-for-date-fails-heres-the-fix\/","title":{"rendered":"Libre writer macro for date fails here’s the fix"},"content":{"rendered":"

When I used Libre Writer Record Macro to put the date in as a non-fixed field it would, after saving as a template then opening the template, put the date field in as a number instead of formatted mmm d, yyyy. Very frustrating, tried over and over again.<\/p>\n

Found answer thanks to this guys work<\/p>\n

https:\/\/ask.libreoffice.org\/en\/question\/13945\/basic-macro-date-numberformat\/<\/a><\/p>\n

I changed his function NumberFormat from 84 to 76 so I got my mmm d, yyyy format. He also made a chart of the possible formats (see below)<\/p>\n

Sub<\/span> Main<\/span>\n\nDim<\/span> Doc<\/span> As<\/span> Object<\/span>\nDim<\/span> DateTimeField<\/span> As<\/span> Object<\/span>\nDim<\/span> Cursor<\/span> As<\/span> Object<\/span>\nDoc<\/span> =<\/span> ThisComponent<\/span>\nCursor<\/span> =<\/span> Doc<\/span>.<\/span>Text<\/span>.<\/span>createTextCursor<\/span>()<\/span>\n\nDateTimeField<\/span> =<\/span> Doc<\/span>.<\/span>createInstance<\/span>(<\/span>\"com.sun.star.text.textfield.DateTime\"<\/span>)<\/span>\nDateTimeField<\/span>.<\/span>IsFixed<\/span> =<\/span> False<\/span>\nDateTimeField<\/span>.<\/span>IsDate<\/span> =<\/span> True<\/span>\nDateTimeField<\/span>.<\/span>NumberFormat<\/span> =<\/span> 76<\/span>\nDoc<\/span>.<\/span>Text<\/span>.<\/span>insertTextContent<\/span>(<\/span>Cursor<\/span>,<\/span> DateTimeField<\/span>,<\/span> False<\/span>)<\/span>\n\nEnd<\/span> Sub\n\n<\/span><\/code><\/pre>\n
Here’s the list of numbers and formats<\/p>\n
10<\/span>   =<\/span>  4134761<\/span>%<\/span>\n11<\/span>   =<\/span>  4134760.39<\/span>%<\/span>\n20<\/span>   =<\/span>  $41<\/span>,<\/span>348<\/span>\n21<\/span>   =<\/span>  $41<\/span>,<\/span>347.60<\/span>\n24<\/span>   =<\/span>  41<\/span>,<\/span>347.61<\/span> USD\n<\/span>30<\/span>   =<\/span>  3<\/span>\/<\/span>14<\/span>\/<\/span>13<\/span>\n31<\/span>   =<\/span>  Thu<\/span> 14<\/span>\/<\/span>Mar<\/span> 13<\/span>\n32<\/span>   =<\/span>  03<\/span>\/<\/span>13<\/span>\n33<\/span>   =<\/span>  Mar<\/span> 14<\/span>\n34<\/span>   =<\/span>  March<\/span>\n35<\/span>   =<\/span>  1st<\/span> quarter <\/span>13<\/span>\n36<\/span>   =<\/span>  03<\/span>\/<\/span>14<\/span>\/<\/span>2013<\/span>\n38<\/span>   =<\/span>  Thursday<\/span>,<\/span> March<\/span> 14<\/span>,<\/span> 2013<\/span>\n39<\/span>   =<\/span>  Mar<\/span> 14<\/span>,<\/span> 13<\/span>\n40<\/span>   =<\/span>  14<\/span>:<\/span>29<\/span>\n41<\/span>   =<\/span>  14<\/span>:<\/span>29<\/span>:<\/span>38<\/span>\n42<\/span>   =<\/span>  02<\/span>:<\/span>29<\/span> PM\n<\/span>43<\/span>   =<\/span>  02<\/span>:<\/span>29<\/span>:<\/span>38<\/span> PM\n<\/span>44<\/span>   =<\/span>  992342<\/span>:<\/span>29<\/span>:<\/span>38<\/span>\n45<\/span>   =<\/span>  29<\/span>:<\/span>38.00<\/span>\n46<\/span>   =<\/span>  992342<\/span>:<\/span>29<\/span>:<\/span>38.00<\/span>\n50<\/span>   =<\/span>  03<\/span>\/<\/span>14<\/span>\/<\/span>13<\/span> 02<\/span>:<\/span>30<\/span> PM\n<\/span>51<\/span>   =<\/span>  03<\/span>\/<\/span>14<\/span>\/<\/span>2013<\/span> 14<\/span>:<\/span>30<\/span>:<\/span>00<\/span>\n60<\/span>   =<\/span>  4.13E+004<\/span>\n61<\/span>   =<\/span>  4.13E+04<\/span>\n70<\/span>   =<\/span>  41347<\/span> 3<\/span>\/<\/span>5<\/span>\n71<\/span>   =<\/span>  41347<\/span> 26<\/span>\/<\/span>43<\/span>\n72<\/span>   =<\/span>  41347<\/span> 2<\/span>\/<\/span>4<\/span>\n73<\/span>   =<\/span>  41347<\/span> 60<\/span>\/<\/span>100<\/span>\n75<\/span>   =<\/span>  Mar<\/span> 14<\/span>,<\/span> 2013<\/span>\n76<\/span>   =<\/span>  March<\/span> 14<\/span>,<\/span> 2013<\/span>\n77<\/span>   =<\/span>  Thu<\/span>,<\/span> Mar<\/span> 14<\/span>,<\/span> 13<\/span>\n78<\/span>   =<\/span>  Thu<\/span>,<\/span> March<\/span> 14<\/span>,<\/span> 2013<\/span>\n79<\/span>   =<\/span>  Thursday<\/span>,<\/span> March<\/span> 14<\/span>,<\/span> 2013<\/span>\n80<\/span>   =<\/span>  14.<\/span> Mar<\/span>.<\/span> 2013<\/span>\n81<\/span>   =<\/span>  14.<\/span> March<\/span> 2013<\/span>\n82<\/span>   =<\/span>  03<\/span>-<\/span>14<\/span>\n83<\/span>   =<\/span>  13<\/span>-<\/span>03<\/span>-<\/span>14<\/span>\n84<\/span>   =<\/span>  2013<\/span>-<\/span>03<\/span>-<\/span>14<\/span>\n99<\/span>   =<\/span>  TRUE\n<\/span>110<\/span>  =<\/span>  Thu<\/span> Nissan<\/span> 3<\/span> 5773<\/span>\n111<\/span>  =<\/span>  Thu<\/span> 3<\/span> Nissan<\/span> 5773<\/span>\n112<\/span>  =<\/span>  3<\/span> Nissan<\/span> 5773<\/span>\n113<\/span>  =<\/span>  Nissan<\/span> 3<\/span> 5773<\/span>\n114<\/span>  =<\/span>  3<\/span> Nissan<\/span>\n115<\/span>  =<\/span>  Nissan<\/span> 3<\/span>\n116<\/span>  =<\/span>  Nissan<\/span> 5773<\/span>\n117<\/span>  =<\/span>  Nissan<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
When I used Libre Writer Record Macro to put the date in as a non-fixed field it would, after saving as a template then opening the template, put the date field in as a number instead of formatted mmm d, yyyy. Very frustrating, tried over and over again. Found answer thanks to this guys work […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1695","post","type-post","status-publish","format-standard","hentry","category-general"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/posts\/1695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/comments?post=1695"}],"version-history":[{"count":0,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/posts\/1695\/revisions"}],"wp:attachment":[{"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/media?parent=1695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/categories?post=1695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/systemsolver.goodhealthyday.com\/StatlerBlog\/wp-json\/wp\/v2\/tags?post=1695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}