In Calc I have a table with three columns. In the first column are 25 dates (dd.mm.yy), in the columns two and three are the corresponding values. The first entry is that of 06.01.18; the last entry is that of 23.06.18. The diagram does not start on 01/06/18, but on 04/08/17. There are no date entries or values for this day and the following days up to 01/06/18. Consequently, the diagram starts with long even lines up to the first date with values (the 6.01.18). The diagram is only created correctly if the column with the dates is not included.
Please attach a sample document so we do not have to guess at your formatting, best to use the .fods "Flat XML ODF Spreadsheet" format. Thanks.
Created attachment 143063 [details] A table in .fods with the wrong diagram with dates and a good one without Thank you for fast reading and reacting. Attached is the file in the .fods format. With the described mistake. I wrote it in .xlsx format, because my friends ar all on Excel.
Thanks for the document to work with... I can see the issue on Windows 10 Home 64-bit en-US with Version: 6.0.5.1 (x64) Build ID: 0588a1cb9a40c4a6a029e1d442a2b9767d612751 CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: en-US (en_US); Calc: CL IIUC the "Dates" entered in column A are not "formatted" as dates, and instead are text. So automatic detection is assigning an incorrect value and extrapolating values. The mischarting of the X-axis resolves if select the text for the cells and set its data type to Date.
Created attachment 143073 [details] Print screen showing how cell is formatted Thank you for your help I'll send you a print screen showing how the date entries are formatted: LibreOffice says that the entries are formatted as date and not as text. I think it must be an even more serious error if LibreOffice interprets the same entries on one computer as date and on another as text. Regards Andi
Will set this new then. Not clear what is expected behavior, but neither setting the whole first column to dates, or forcing the actual date cells (A3-A27) to be Date (de-CH) is allowing the X-Axis -> Scale "automatic" to pick up correct "Date" format. With the Scale automatic, the Date -> Minimum of the range is being extrapolated.
Also reproducible in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.10; Render: default; Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Cell A16 contains date 2017-04-08 not 2018-04-08 hence the date series starts there. Not a bug.