https://bugs.documentfoundation.org/show_bug.cgi?id=99097
--- Comment #6 from Roy D <roy.dam...@gmail.com> --- Hello Bernard, Your solution (Format(Now, "yyyymmdd\_hhmmss")) does work, but it is plain wrong behaviour. First time mm is replaced by the month and later the same mm is replaced by something else: minutes. What if I want to format a string in the form of years and minutes. I can do that in all kind of languages, including VBA. In Calc basic, it does go wrong. In every other language a distinct character is used for minutes. And we are not talking about cell formatting, but about the Basic scripting language. But I think it is strange for cell formatting too. Also Calc Basic is in VBA compatibility mode (via switch Option VBASupport 1). The documentation of VBA states: https://msdn.microsoft.com/en-us/library/office/gg251755.aspx nn, NN, Nn does work fine in Excel. Regards, Roy -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs