[Libreoffice-bugs] [Bug 155911] Importing and formatting dates!

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=155911

ady  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #2 from ady  ---
I'm sorry to say that nothing in the prior comments makes sense, other than
perhaps there is some lack of knowledge and/or experience using Calc.

The import dialog allows concatenating separators, and it also allows
(multiple) space characters as separators, among others.

Additionally, the # marks in attachment 187971 (e.g. cell A65) are just
indicating that the width of the column is too narrow so as to show the values
in their current format; just make the column wider.

Please next time search for info; the online help, users' mailing lists,
https://ask.libreoffice.org and even a web search can be useful.

I'm closing this as NOTABUG.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 155911] Importing and formatting dates!

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=155911

--- Comment #1 from Nigel Lee  ---
Created attachment 187971
  --> https://bugs.documentfoundation.org/attachment.cgi?id=187971=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 "MMDD_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.