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

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+unsubscribe@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