![]() In which Calc corrected it for me, and then I noticed what it did and fixed them myself. Had to name it something normal first (kmgal) and then change it after I put in the formula to calculate the average. 'Km/Gal' confused Calc until I realized I needed them. though in cases of Title characters that use functions such as / (which was an issue I was having) you need to remember to put apostrophes before and after ie. I just used that instead of renaming the column and worked basically the same without as many issues. This just kept causing me issues though, and like the way I found better, if it's applicable to whoever else finds this post's needs. this you rename to give the column a name. The answer referring to naming the column was unclear to me when I read it.įrom this beginner's view it was trying to say that when you select the whole row, in the drop down box in the upper left hand corner it says to the effect A1:A1048576. Was looking for the answer to this myself and found another option along the way. If you move rows around, it becomes broken, for instance.Īlso it seems that if you use it to make charts, your charts will become hundreds of MB inside the zip file and slow down the computer, etc. It doesn't actually treat A:A as it should. Click the button to delete the current row. Click the button to insert a column left to the current column. Click the button to insert a row above the current row. You can enter A:A in some places, but it's then converted to A1:A1048576 which is not the same thing. How do you add columns in LibreOffice To insert or delete a row or column: Click on any cell of the row or column. ![]() ![]() This clearly gives a big advantage to LibreOffice, which will develop quicker and incorporate more features and improvements.Įdit: Actually this is not really fixed. In the long run, this means that big improvements to OpenOffice can be incorporated into LibreOffice, while big improvements to LibreOffice can’t be incorporated into OpenOffice. I don't know if they incorporate changes like this from LibreOffice, but I found this: No, but it will be available in a future version of Calc: Įdit: Actually, it's already downloadable in " LibreOffice Fresh".Īlso this question is about OpenOffice, which is a separate product now.
0 Comments
Leave a Reply. |