Hi, I am using linux kubuntu feisty 7,06 with openoffice calc 2.2.0.
I have created a chart, I would like to extend the data range.
I should able to extend the data range in 2 ways; heither doubleclicking on the chart (the data range is showed in a blue box) and dragging the range or clicking on the edit menu in main toolbar and select chart data.
Unfortunatelly both methods do not work for me
The range gets highlighted but I can not drag the range
and the edit chart data in the edit manu is not active (grey).
Any idea, many thanks
Gennaro
Edit chart data - extend the data range
Edit chart data - extend the data range
Last edited by gennaro on Tue Jul 08, 2008 5:01 pm, edited 1 time in total.
OOo 2.2.X on Ubuntu 7.x + linux kubuntu feisty 7,06
Re: edit chart data - extend the data range
I don't have any problem with your second method using 2.3.1 under XP. We have heard any number of reports of problems with Ubuntu versions of OOo. If you're using the kubuntu version of OOo you might want to consider updating to 2.3 or 2.4 from the official OOo site.
LibreOffice 7.3.7. 2; Ubuntu 22.04
- Hagar Delest
- Moderator
- Posts: 32657
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Edit chart data - extend the data range
Have you tried the official version? [Ubuntu] Installing OOo on Debian and Co.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Edit chart data - extend the data range
A third way to extend your data:
3a Insert a row/column for each newly entered record.
3b Insert new rows/columns for all records to be pasted.
This will extend formula references as well, such as =SUM($A$1:$A:9) --> =SUM($A$1:$A:9)
[Calc, Python] expand/shrink list ranges
3a Insert a row/column for each newly entered record.
3b Insert new rows/columns for all records to be pasted.
This will extend formula references as well, such as =SUM($A$1:$A:9) --> =SUM($A$1:$A:9)
[Calc, Python] expand/shrink list ranges
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice