Hello! Please, can anyone help me to write the graph of the function y=2*x^2+5 in calc? Do I need to make any table first, or is the formula enough? How to get graph directly from the formula?
Many thanks!
You will need to make a table first and then the graph as x-y-scatter.
Helloe, JohnSUN! PLEASE, how did U get this animated?
Many thanks!!!
Oh, that's easy enough. Fifty presses of PrintScreen button and this program
Hi JohnSUN, how did you make that trick? I meant Formula you put in $B$2 = 2X^2+5, the sheet turned back the value as if you type = 2[A2]^2 + 5.
@TingliChan Just open a spreadsheet document, choose Tools - Options - LibreOffice Calc - Calculate and check Automatically find column and row labels
I followed the steps in animation. Cells A2 and B2 being copied down A(n) went as expected, B(n) turned out constant which is 205. Why is that so?
Mm-hmm, =2*A2^2+5 was expected to be typed in B2 as a regular spreadsheet user. But I saw the illustration you gave out, it stunned me that a question came to my mind "Is there such a way to make things like that works out?" To me it seems like a new way to work things out. Very much thank you for your kind responses and patience to the newbie like I am.
It seems to me that yesterday, when I explained about "column labels", everything worked correctly. Now I checked it, I see the same as you. If you save, close and open the document, the results are correct, but the Recalculate (F9) and Recalculate Hard (Ctrl+Shift+F9) have no effect. BTW, select (for example) B7 while it show 205 and press Ctrl+F2 (Function Wizard). Do you see? It show correct result 55. I think that it is bug of current version
Asked: 2013-09-10 18:26:26 +0100
Seen: 1,669 times
Last updated: Sep 10 '13
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
