Please find me effortless way convert date string into data closed – Ask LibreOffice

Please find me easy way convert date string into data closed - Ask LibreOffice

Very first time here? Check out the FAQ!

I need an effortless way to convert csv-like or web string into calc data for chart creation.

If this do not exist yet, make report as a bug.

Thanks, ROSt52. I have to specify my needs.

I grabbed all these private listing — buyers’ identities protected AU $7.97 1 06-Mar-14 14:36:38 AEDST and needed quantity, date and time as elements to analyze sales. Then I shall create a chart for as a proof that this sells well and more budget is needed. Its ok to say about relevant&,inrelevant information here. ^.^

Closed for the following reason the question is answered, right reaction was accepted by Alex Kemp

close date 2016-02-20 08:11:04.554697

Five Answers

Hi @jiero, selecting the column type to D-M-Y for the column of dates, in the import windows, works for me. (I did it pasting as unformatted text, copying directly from web page)


Thank you, this reminds me what i used to do with csv generated by ebay, why I left behind it? Maybe because this isn’t my data, I don’t have access to csv, which lead to my attempt doing the same but ingoring import function. Anyway, I shall attempt import.

You can use the functions DATEVALUE and TIMEVALUE. DATEVALUE overlooks time information and TIMEVALUE overlooks date information, so you may have to add them together to get a specific point in time.

For example: =DATEVALUE(“2014-05-03”)

Normally, if you paste in a time or date string that Calc understands, it is automatically converted into a number and formatted as a time or date. The above mentioned functions don’t cause this automatic formatting so you may want to select the suitable number format for the cell.

The underlying format for times and dates is a floating-point number. The integer part is the date and the fractional part is the time. If you want to convert such a number into a string in Calc, use the function TEXT,

For example: =TEXT(A1, “YYYY-MM-DD”)

Find myself the way, work like import but more supple – select column and proceed “Menu Entry Data ->, Text to Columns. ” and do same as in import window

All you need to do is highlight the area and then Format >, Clear Direct Formatting.

@jiero – What kind of data do you have and what kind of data do you need and what kind of charts do you need?


Please post only answers as answers. If you want to ask something from the asker, do so in comments. This way we know which questions have been answered. 🙂

Related movie: Making Friends with Strangers on Omegle!

Leave a Reply

Your email address will not be published. Required fields are marked *