Re: [libreoffice-users] Calc SLOW with filtering large data set

2018-02-20 Thread Jean-Baptiste Faure
Le 20/02/2018 à 04:49, Carl Paulsen a écrit : [...] What might cause this slow filtering? Perhaps xlsx format. Save your file as .ods and try again. Best regards JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. Disclaimer: my Internet Provider being located

Re: [libreoffice-users] Calc SLOW with filtering large data set

2018-02-20 Thread Carl Paulsen
I realized this morning that the version I installed was the "fresh" release and not the "still" release. I did that because it was at the top of the download page for the installer and was the only one that showed on my browser screen (I didn't think to scroll down because convention seems

Re: [libreoffice-users] Calc SLOW with filtering large data set

2018-02-19 Thread Carl Paulsen
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

[libreoffice-users] Calc SLOW with filtering large data set

2018-02-19 Thread Carl Paulsen
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