Fwd: [libreoffice-documentation] Multi-threading in Calc
stevemfanning.wh at gmail.com
Thu Apr 23 13:56:39 UTC 2020
Mike and Luboš,
Many thanks for your help on this topic.
On Thu, 23 Apr 2020 at 11:16, Mike Kaganski <mikekaganski at hotmail.com>
> On 23.04.2020 13:12, Luboš Luňák wrote:
> > On Thursday 23 of April 2020, Stephen Fanning wrote:
> >> As for the processing itself, I remain unclear about how Calc allocates
> >> tasks to threads. Can we give the user any general advice on how he
> >> structure his spreadsheet to gain the maximum performance benefits from
> >> availability of multiple cores? Or maybe there are ways to organise a
> >> spreadsheet that will frustrate Calc's attempts to multi-thread, which
> >> ought to advise against?
> > Technically threads are generally used only for formula groups, which
> are a
> > sufficient number of adjacent cells in a column that use the same
> > (and get different results because of relative cell addressing). In UI
> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and
> > down. But it's implementated this way because that's usually how large
> > spreadsheets are created. So I think it's a needless complication to be
> > specific about this.
> IMO it's still useful to mention that the optimization is column-based.
> Because many people don't realize that row-based layout is potentially
> less efficient. This would be beneficial to those who don't create
> spreadsheets according to how it's "usually" done.
> Best regards,
> Mike Kaganski
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the LibreOffice