Re: [libreoffice-users] [5.2.6] calc charts do not update

2017-03-30 Thread Frédéric Bron
> I'm guessing, but have you tried Tools | Cell Content > | Recalculate (or > F9) or Ctrl+Shift+F9 (Recalculate Hard)? This doesn't help. A colleague found that that hiding then unhiding the rows that are below the charts solves the issue. Note that these rows are not the ones that contain the

[libreoffice-users] [5.2.6] calc charts do not update

2017-03-30 Thread Frédéric Bron
It is a real nightmare: I cannot find why sometimes charts automatically update and sometimes they don't. In particular, I have a series that sometimes has some points, sometimes not and very often, when later I add some new values to an empty series, the chart do not show the new point. That's

Re: [libreoffice-users] Calculate decimal seconds

2017-03-30 Thread vytas
Hi Steve, For my application using the [SS].00 option did the trick. As I required to determine number of seconds required to move 500m. I also need to sum up the resultant column. Thanks for all the help both on-line and off-line. Vytas On 3/29/2017 3:20 PM, Steve Edmonds wrote: Hi. 2

Re: [libreoffice-users] Copy-Paste(special) times in Calc.

2017-03-30 Thread John Meyer
Usually when I'm pasting in time into a cell formatted for time, I'll paste special. The worst that happens is that the time is affixed with a single quote mark. Then I find and replace "^." with "&" (no quote marks). On 3/29/2017 2:32 PM, Steve Edmonds wrote: Hi. Playing with the