libreoffice-calc
For some time now I've been able to insert the date into LibreOffice Calc cells by pressing Ctrl; combination like in Excel.
With regard to this I have two questions:
Is it possible to make it insert only the DATE without the time (right now it inserts ddmmyy hhmmss).
Where is this option located in the menu as I couldn't find it anywhere?
Yes, this is possible. You need to select the XY (Scatter)chart type. If you start with this data table:
..., select it, start the chart wizard and select XY (Scatter), the result preview already shows that the data points are córrectly spaced:
(NB: i didn't customize the wizard's defaults yet - Calc did recognize the columns correctly).
The only problem is that you still can't tell Calc to use "one month" as scaling unit for the X axis. This means, the scale of the X axis will use days as scaling unit. If you set the major interval of the X axis to 30 (days), the resulting chart will look like this:
Start with a formula in cell B1.
Then click on the small black square in the lower right hand corner of B1 and drag down, for example to B5.
To use the menu instead, select B1 to B5 and go to Sheets -> Fill Cells -> Down.
To quickly apply the formula to the entire column, see https://stackoverflow.com/questions/26868186/quickest-way-to-apply-a-formula-to-an-entire-column.
These are not Array Functions, because they just deal with a single value at a time.
Best Answer
In LibreOffice 4.1:
Date: Ctrl;
Time: CtrlShift;