Report Offensive Message
I have been using Apache OpenOffice 3.4.0 on my XP desktop. One spreadsheet is a simple way to keep track of my checkbook. I installed Lubuntu on a laptop, and opened the spreadsheet with LibreOffice 220.127.116.11. The first 16 rows work fine, then starting with row 17, the cells all the way down that show results of formulas, indicate "#VALUE!". I can't find any difference in formatting when comparing cells 16 & 17. I have other similar spreadsheets that do the same thing (the problem does start in different rows) There is one that works fine! I did check "value highlighting" and the cells with numbers (currency) show blue, the ones with formulas are green. I have done a lot of searching on Google, but can't find anything remotely like this. I really hope you can help.