OK, a little more info. I just ended up trying the spreadsheet on the
older machine running windows 7 and LibreOffice 5 and the filtering was
nearly instantaneous. Odd because Excel (2007) on that same machine is
very slow. So why would Calc run so slow when filtering using LO 6 on a
Windows 10 machine but so fast when running LO 5 on a Windows 7
machine? And is there any connection to Excel being so slow on both
machines?
Thx
On 2/19/18 10:49 PM, Carl Paulsen wrote:
I work with large spreadsheets and have used both Excel and Calc in
the past. I have a large file with 10 or so sheets, many of which are
large and one has just over 35,000 records. In this sheet there is a
field that is boolean (0 or -1). When I filter on this field in Excel
it takes several minutes to complete. When filtering in Calc it takes
10-15 minutes or more. I'm using Excel on an older and slower i5
windows 7 machine and Libreoffice on a newer i5 (8th gen) with windows
10. I may try to switch machines to see what happens, but I'm pretty
busy and taking the time to do that is tricky. Also, I've tried using
Excel 360 (trial) on the newer windows 10 machine and it loads 30
seconds or so faster than the older machine running excel, much faster
than Libreoffice.
What might cause this slow filtering? I'd love to use Calc
exclusively, but occasional problems like this keep scaring me away
from fully embracing Libreoffice.
Thanks for any insights or ideas about how to speed it up.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
