Launchpad has imported 19 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=74549.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2014-02-05T09:41:02+00:00 Eneko Lacunza wrote: Created attachment 93432 Simple spreadsheet that demonstrates the bug We three lines of data, the first are date values and the other two count values (estimated ours - not relevant for the bug). When creating a chart with first line for X-axis label, graph is good but the labels are not. Seems there is some type of misscalculation. Please find attached spreadsheet that demonstrates the bug, there are some red-marked data that are not correctly shown in the chart. ODS file is created with LibreOffice 3.5.7.2 Build ID: 350m1(Build:2) and it's shown correctly. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/0 ------------------------------------------------------------------------ On 2014-02-06T11:10:26+00:00 Dominique-boutry3 wrote: Hi. Please how did you manage to have: - an X-axis showing 5 days per 7 (01-21, 01-24, 01-25... but no 01-22, 01-23) - based on series which show these 2 days (all 7 days per 7) ? Thanks Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/1 ------------------------------------------------------------------------ On 2014-02-06T11:22:29+00:00 Eneko Lacunza wrote: Hi Dominique, The chart is based directly on spreadsheet data. Date calculus is made using B2 as starting date, then dia.lab() function (WORKDAY()) is used to calculate next bussiness day. Spreadsheet show correct dates, but chart does not. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/2 ------------------------------------------------------------------------ On 2014-02-06T13:19:57+00:00 Gerard-fargeot wrote: Reproducible with Version: 4.3.0.0.alpha0+ Build ID: f571104ef38ba9f7f6073e22c2374add7aa73887 TinderBox: Win-x86@39, Branch:master, Time: 2014-01-28_00:11:40 Sorry, don't have 4.2.0 for testing. All dates in X-axis are offset by 693958 days. Show 0114-01-21 instead of 2014-01-17 for the 1st. Format scale axis to "date" or "automatic" cure the problem. It seems that setting date as "text" misinterpret the date. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/3 ------------------------------------------------------------------------ On 2014-02-06T13:35:39+00:00 Gerard-fargeot wrote: Created attachment 93526 File with Histogram and X-axis date scale as text Affect Line chart but also Histogram. All charts where you can scale Axis as "Date" or "Text". It seems that the new date origin is not 31/12/1899 for chart but JC birth... :) Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/4 ------------------------------------------------------------------------ On 2014-02-06T13:38:38+00:00 Gerard-fargeot wrote: Raise importance to High/Critical. I don't know if we should consider this as a blocker/mab as most of users use real date for X-asis and not text category. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/5 ------------------------------------------------------------------------ On 2014-02-06T14:50:21+00:00 Dominique-boutry3 wrote: Results of my experiments: The data type of X-Axis values is "Text" (and not Date: should it was, you would have seen the saturdays and sundays wihout data). If you format the X-Axis values with "Number>Default", you see the repesentation of right numeric values (41656, 41659, and so on). If you format the X-Axis values with "Date>31/12/99", you see "21/01/14, 24/01/14", and so on. The conversion into Date is false, too high by contant 4. Step to reproduce : - in a New spreadsheet, - fill in A1 with 41676, C1 with "=A1" formatted as "Date" : 06/02/14, OK - fill in A2 with 100, select A1:A2, Insert a Chart, Column-type, "Next", "Data series in rows", "First row as label" then "Finish", - right click on the 41676 value in X-axis, "Format Axis", then "Date" - Observe "10/02/14"! - You have just been stolen 4 days... Quick, quick, close the doors... Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/6 ------------------------------------------------------------------------ On 2014-02-06T14:51:26+00:00 Dominique-boutry3 wrote: Similar conclusion... obtained at the same time (Mid-air collision). Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/7 ------------------------------------------------------------------------ On 2014-02-14T15:02:43+00:00 Gerard-fargeot wrote: *** Bug 74965 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/8 ------------------------------------------------------------------------ On 2014-03-19T03:54:34+00:00 Libreoffice-commits wrote: Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=22c7da0ca5438b69165609db2a1ef219aa167dc2 the type in the Any is a util::Date and not a DateTime, fdo#74549 The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/9 ------------------------------------------------------------------------ On 2014-03-19T03:58:59+00:00 Markus Mohrhard wrote: attachment 93432 worked without a problem in master. I fixed the issue that I saw with attachment attachment 93526. Hopefully that fixes also the issue that you see with 93432. Backport request for 4-2 pending in gerrit. Please test in a daily build that it is really fixed. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/10 ------------------------------------------------------------------------ On 2014-03-19T10:12:51+00:00 Jorendc wrote: @Markus: bug 76087 is related/a dupe? Thanks for fixing :-)! Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/11 ------------------------------------------------------------------------ On 2014-03-19T10:27:51+00:00 Libreoffice-commits wrote: Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=d5580b252ad4cfea10422c044366c3c6c1ebed83&h=libreoffice-4-2 the type in the Any is a util::Date and not a DateTime, fdo#74549 It will be available in LibreOffice 4.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/12 ------------------------------------------------------------------------ On 2014-03-20T00:16:03+00:00 Markus Mohrhard wrote: *** Bug 76087 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/13 ------------------------------------------------------------------------ On 2014-03-20T00:16:25+00:00 Markus Mohrhard wrote: *** Bug 75711 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/14 ------------------------------------------------------------------------ On 2014-03-21T11:22:15+00:00 Libreoffice-commits wrote: Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-2-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=1b9f2f843723e45c0f5a8899b754f0dab01e5df6&h=libreoffice-4-2-3 the type in the Any is a util::Date and not a DateTime, fdo#74549 It will be available already in LibreOffice 4.2.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/15 ------------------------------------------------------------------------ On 2014-04-01T09:34:05+00:00 Jorendc wrote: *** Bug 76860 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/16 ------------------------------------------------------------------------ On 2014-04-01T17:06:49+00:00 Jaime Carpenter wrote: Created attachment 96738 x axis shows incorrect date information. Should be same as the selected cells Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/17 ------------------------------------------------------------------------ On 2014-04-03T09:21:01+00:00 Jorendc wrote: *** Bug 76969 has been marked as a duplicate of this bug. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1301725/comments/20 ** Changed in: df-libreoffice Status: Unknown => Fix Released ** Changed in: df-libreoffice Importance: Unknown => Critical -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1301725 Title: [Upstream] x-axis displays incorrect information in calc chart To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1301725/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
