Libreoffice sum column1/31/2024 ![]() ![]() 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. You can enter A:A in some places, but it's then converted to A1:A1048576 which is not the same thing. 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. You could do the same with your Date columns. 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. You might also want to right click the cell with the letter (e.g., A, B, C) at the top of your Amt Paid column (the blue C in ebot’s video above), click Format Cells, and select Currency from the Category list. 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.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |