https://bugs.documentfoundation.org/show_bug.cgi?id=155911
--- Comment #1 from Nigel Lee <[email protected]> --- Created attachment 187971 --> https://bugs.documentfoundation.org/attachment.cgi?id=187971&action=edit calc sheet showing the problem(s) I wanted to see if I could extract DIR data for some files with the wrong date, to work out what they should be, with a view to renaming them automatically, but had a few problems, with "import", and "format". See the comments on the sheet. I would have liked to be able to use a TEXT("MM") formulae to extract 'month' or 'minutes', or to use "YYYYMMDD_HHMMSS", but couldn't! I ended up having to use TEXT(Day(G2),"00"), etc. and concatenate! - and got several 'suggestions' when I missed out brackets or quotes, that weren't right) - the files were created by my "wildlife trail camera", which timestamps pictures and video clips, and 'sets' it's clock from a text file, and creates a new one with a default date string.. fortunately that file did have the correct create date! Otherwise I could use the date I intended, as the 'start date'. I'm not sure if I can do the rename operation in code within Calc, or else I will replicate it using Python. Nigel Lee -- You are receiving this mail because: You are the assignee for the bug.
