https://bugs.documentfoundation.org/show_bug.cgi?id=100380
--- Comment #15 from branestawm <[email protected]> ---
(In reply to robert from comment #14)
> Created attachment 125716 [details]
> Date formatted as integer - linechart and xy-chart are shown right
>
> Have tested a little bit more. If you will change the date to an
> integer-value, you could use the date for line-charts and xy-charts.
Thank you for your very helpful suggestion. Although your test file works OK
for me, when I tried to use your DATEDIFF function in my test file, I had to
change the parameters. In my LO v5.1.3.2, DATEDIFF has only 2 parameters: 'dd'
is omitted/assumed and your 2nd & 3rd parameters are reversed.
Perhaps you could add your workaround (and this note) to your Base handbook?
Unfortunately when I try it with my full database which has 1000+ records with
grouping, and an xy chart in the group footer, Report Builder shows only some
of the data points (10) on the first Chart and when executed produces each
chart with all 1000+ data points (no grouping). But the charts do have correct
x-axes. I won't have time to work on it some more this weekend, but If I get
anywhere next week, I'll post an update.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
