https://bugs.documentfoundation.org/show_bug.cgi?id=159876
BenTpe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Severity|normal |minor Status|UNCONFIRMED |RESOLVED --- Comment #7 from BenTpe <[email protected]> --- Hi, I've been working on my file again and I found the problem. I had imported the data from Excel, and as the way to define range in libreoffice differs from Excel, I had a lot of formulas with SUMPRODUCT on whole ranges like B:B because otherwise my calculations would bring a #REF error when refreshing the SQL. It's only today that I found out I can make named ranges for individual columns, and it doesn't mess up calculations when I import the data from my database. Once I replaced the formulas to named ranges of columns instead of full column, everything went back to an acceptable speed, including saving and calculations. Sorry for being a beginner and not knowing well enough how things work on Libreoffice or not finding out quick enough. It is quite a learning curve from Excel, but worth it :) -- You are receiving this mail because: You are the assignee for the bug.
