Ask Your Question

EasyRider's profile - activity

2020-02-06 16:51:31 +0200 received badge  Student (source)
2019-04-03 13:52:26 +0200 answered a question Excel has a feature that when you fill in a date, it can automatically give you the day of the week. I am hoping to find this feature in Libre

I want to get the day of the week, from a date value in a different column, without a long list of "IF" statements.

2016-10-23 19:04:22 +0200 received badge  Famous Question (source)
2016-07-23 20:16:00 +0200 received badge  Notable Question (source)
2016-07-22 10:26:51 +0200 received badge  Popular Question (source)
2016-07-21 16:00:11 +0200 answered a question Problem with writer converting table to text

Usually, each field, in the table, is delimited by a paragraph marker. Turn on the control (toolbar), so you can see the markers. Use the paragraph marker, as your delimiter, then go through the text,replacing each paragraph marker with a tab or space.

2016-07-21 15:49:17 +0200 asked a question How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)

So far, I have a long, complicated "IF" statement, using WEEKDAY().. There must be an easier way!

2014-04-29 15:18:27 +0200 answered a question "the maximum number of rows has been exceeded"

I got the same error, opening a .csv file in calc. The .csv file had quote marks (") delimiting all the text fields, as well as commas. I edited the .csv file, removing all the quote marks, and the error went away.