Openoffice calc freeze row how to#

There is one formula in Excel (and I presume Calc as well) That I could not figure out and am pretty sure not possible by the software.Р”РЋ. I already do have spreadsheets taking info from main spreadsheet and calculating 10s of thousands of numbers, but I havn't updated that in a year or two and it needs a complete overhaul. Most simple formulas worked, but some of the ones I needed did not work.

Openoffice calc freeze row how to#

I've tried splitting the spreadsheet into several different spreadsheets (files) using excel, but the formulas gave errors and I couldn't figure out how to get the two spreadsheets to work together. Only problem is the size of the spreadsheet grows and it slows down (I solved this problem a year ago by purchasing a new computer). I've still got about 10 hours worth to get the spreadsheet up to date and maybe 40 hours to add a crapload of more calculations I've been wanting to add for years. Several things work similar such as freeze pane (both are found in window->freeze). Now this may become a problem in the future if I ever need to use different rows within that type of formula, but I'm not sure that I would. Excel does not show anything wrong, which I guess is ok since it worked, but I thought it was neat that Calc would not calculate this (or bad). This showed me that the formula itself had an error as I had accidentally put $X$28 instead of the correct $X$27 I was putting in the other parts of the worksheet. One thing I noticed was in Excel I was using this in 4 out of 180 similar formula (typos): I'm still learning some of the formula differences such as Calc using ' ' instead of Excel ','Р”Р„lthough this should be easy since Calc already converted all my formulas, so I know how to do them (look at how it was done, then copy it). I found out that using the backspace key deletes the data without confirmation box. Googling this nuisance I found an answer within 1 minute ( first result). I found out this was not possible by googling within 5 minutes.Р”Р„nother difference is when I was deleting stuff and pressing the 'delete' key a confirm dialog would always popup. This made reading dollar numbers much easier and cleaner. One feature I am currently missing that is not available in Calc is the Accounting text format. Switching say '!' to '.' and ',' to ' ' and calculating everything. It looks to have converted the formulas correctly.

I simply delete the data from previous year, leaving all formulas and fonts/columnwidths/etc intact I don't have time to retype every formula and piece of info, so it would be impractical to start a blank spreadsheet. Since time to implement is important for me, I took my 2007 excel spreadsheet and opened it in Calc, then saved it as is in odf format. The programs are not currently running when I open the spreadsheet (both seem to take about 1-2 seconds to start). So far openoffice takes about 10-11 seconds to open the spreadsheet. So I had a 3.17mb spreadsheet with around 120,000 cells and many formulas and 18 tabs (worksheets). I'll make more posts as I run into some things. I've only done some basic stuff in it so far. I thought I'd post my current experience of switching from Microsoft Excel spreadsheet to Openoffice Calc spreadsheet.