Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 06 Jun 2013 12:09:18 +0200LibreOffice Calc X/Y range Problem for a plot (automatic update )https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/Dear all !
My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin.
I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".
Could Someone find a solution to this ! ?? ( LibreOffice 3.6.2.2)
Sebastien Mon, 03 Jun 2013 12:39:55 +0200https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/Comment by sebberth for <p>Dear all !
My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin. </p>
<p>I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".</p>
<p>Could Someone find a solution to this ! ?? ( LibreOffice 3.6.2.2)</p>
<p>Sebastien </p>
https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?comment=18590#post-id-18590Thanks for your help !!! Your solution work perfectly ! SebastienThu, 06 Jun 2013 12:07:57 +0200https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?comment=18590#post-id-18590Comment by moggi for <p>Dear all !
My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin. </p>
<p>I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".</p>
<p>Could Someone find a solution to this ! ?? ( LibreOffice 3.6.2.2)</p>
<p>Sebastien </p>
https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?comment=18484#post-id-18484See fdo#55697Tue, 04 Jun 2013 01:06:31 +0200https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?comment=18484#post-id-18484Answer by sebberth for <p>Dear all !
My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin. </p>
<p>I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".</p>
<p>Could Someone find a solution to this ! ?? ( LibreOffice 3.6.2.2)</p>
<p>Sebastien </p>
https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?answer=18591#post-id-18591Thanks for your help moggi and mariosv !!! Your solution work perfectly ! SebastienThu, 06 Jun 2013 12:09:18 +0200https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?answer=18591#post-id-18591Answer by ROSt52 for <p>Dear all !
My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin. </p>
<p>I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".</p>
<p>Could Someone find a solution to this ! ?? ( LibreOffice 3.6.2.2)</p>
<p>Sebastien </p>
https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?answer=18487#post-id-18487@mariosv 's proposal of inserting rows is in most cased most likely the best solution. However, the inserting point for a new row(s) must be above the above the last data row.
![image description](/upfiles/13703073713668891.png)Tue, 04 Jun 2013 02:56:47 +0200https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?answer=18487#post-id-18487Answer by m.a.riosv for <p>Dear all !
My problem is : I'm in LibreOffice Calc. I want to plot (x-y plot) the value from column A in function of column B. As these two columns are appended each days by new lines, I don't want to update the x-range and y-range values each days. So I put try to put in these two field A1:A10000 and B1:B10000, even if these two column are currently filled with only 500 values. The problem is that it's seems that LibreOffice Calc autmoatically update the values of these two field, and adjust these to the exactly size of the filled column. When I log off, my 10000 value is changed to 500, and I have to do the job again and agin. </p>
<p>I have tried an anohter method (use concatenate function to auomaticaly edit in a cell the string "A1:A500", but didn't find the way to send this information on the field X-range of the figure. It's seem that Libre office calc reject me each time I try to put a function (indirect, index or else... ), by showing red color in the field and I cannot click on "ok".</p>
<p>Could Someone find a solution to this ! ?? ( LibreOffice 3.6.2.2)</p>
<p>Sebastien </p>
https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?answer=18480#post-id-18480Enable the Menu/Tools/Options/LibreOffice calc/General - Expand references when new columns/rows are inserted.
Instead of add data, use insert row below the last row with data.
Tue, 04 Jun 2013 00:44:18 +0200https://ask.libreoffice.org/en/question/18460/libreoffice-calc-xy-range-problem-for-a-plot-automatic-update/?answer=18480#post-id-18480