[libreoffice-users] LO 3.4.2 Calc - charts don't automatically refresh

2011-08-05 Thread Gordon Burgess-Parker

(This happened with the previous release of 3.4 as well)
I add data to the sheet but the chart based on that data doesn't 
automatically reflect the additional data - I have to double-click on 
the data lines in order to refresh the chart.
Am I missing something here? (The data ranges in the chart cover the 
whole amount of data to be entered, so it's not a case of the range not 
covering the data...)


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] LO 3.4.2 Calc - charts don't automatically refresh

2011-08-05 Thread Sigrid Carrera
Hello Gordon, 

On Fri, 05 Aug 2011 08:37:32 +0100
Gordon Burgess-Parker gbpli...@gmail.com wrote:

 (This happened with the previous release of 3.4 as well)
 I add data to the sheet but the chart based on that data doesn't 
 automatically reflect the additional data - I have to double-click on 
 the data lines in order to refresh the chart.
 Am I missing something here? (The data ranges in the chart cover the 
 whole amount of data to be entered, so it's not a case of the range not 
 covering the data...)

I'm no Calc expert, but have you by any chance disabled the auto calculate 
feature in Calc? If you can update the chart by pressing F9, this would 
indicate that you might have. So try enabling this feature and see how it goes 
then. 

Sigrid

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted



Re: [libreoffice-users] LO 3.4.2 Calc - charts don't automatically refresh

2011-08-05 Thread Gordon Burgess-Parker

On 05/08/2011 08:57, Sigrid Carrera wrote:

Hello Gordon,

On Fri, 05 Aug 2011 08:37:32 +0100
Gordon Burgess-Parkergbpli...@gmail.com  wrote:


(This happened with the previous release of 3.4 as well)
I add data to the sheet but the chart based on that data doesn't
automatically reflect the additional data - I have to double-click on
the data lines in order to refresh the chart.
Am I missing something here? (The data ranges in the chart cover the
whole amount of data to be entered, so it's not a case of the range not
covering the data...)

I'm no Calc expert, but have you by any chance disabled the auto calculate 
feature in Calc? If you can update the chart by pressing F9, this would indicate that you 
might have. So try enabling this feature and see how it goes then.

Sigrid



Interesting. Autocalculate is ON, and if I enter data AFTER clicking on 
the charts, then the charts automatically update. It only seems to 
happen on first opening...(the charts are in different sheets to the 
data - would that have a bearing?)


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted