Re: [libreoffice-documentation] LibreOffice Base Guide

2020-04-23 Thread Rob Westein

I agree!
Next 4 days off so I hope I can work on the Base 7 Guide.

I would like to change the dates in the sample Database for a more 
actual look. Instead of looking at dates from 7 years ago, it would be 
nice if the reader sees more recent (2020) dates on the screenshots.


/Rob


On 23-04-2020 15:19, Pulkit Krishna wrote:

Hello Rob & Jean,
After a discussion with oliver, and as jean suggested, I think we should
edit the base guide in v7 and not in v6.4. We should also let v6.4 be
released. V7 is a major release with rebranding and all. We should make a
good v7 book.
Pulkit Krishna



--
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Steve Edmonds


On 23/04/2020 22:15, Mike Kaganski wrote:
> 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 could
>>> structure his spreadsheet to gain the maximum performance benefits from the
>>> availability of multiple cores? Or maybe there are ways to organise a
>>> spreadsheet that will frustrate Calc's attempts to multi-thread, which we
>>> 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 formula 
>> (and get different results because of relative cell addressing). In UI 
>> terms, 
>> write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and 
>> extend 
>> 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.
Try dragging a formula down 6000 rows, you have time for a cup of tea
and a snack.
I doubt anyone wanting to use the advantage of multithreading will be
dragging formulae many cells.
So it would be an advantage to know how to optimise for multithreading.
Steve


-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Drew Jensen
Also - I read in a couple of places online that if you have OpenCL support
enabled then the CPU threading stops.

I can't test that to see if it is true because I can't seem to get OpenCL
to work on this Linux desktop.

Trying it on a Windows machine should answer that question.

On Thu, Apr 23, 2020 at 4:56 PM Drew Jensen 
wrote:

> To follow up on that.
>
> Using LO 6.4 & 7.0 pre-release build on Ubuntu. Recalculating one of the
> OpenCL test xls files just now.
>
> Starting up with a command line
> MAX_CONCURRENCY=0 ./soffice
> Does turn the CPU threading off.
>
> Restarting with a command line
> MAX_CONCURRENCY=4 ./soffice
> Turns it back on (for my AMD a5800 processor this will give me two
> threads, because while the CPU is called a 4 core processor and it does
> have 4 accumulators it only has 2 floatingpoint cores and this is the
> limiting factor it seems) with recalculation time for the workbook is ~2x
> faster.
>
>
> On Thu, Apr 23, 2020 at 1:48 PM Drew Jensen 
> wrote:
>
>> BTW I'm copying a paragraph from an email on a different list.
>>
>> "Also - if you set MAX_CONCURRENCY=16 - or somesuch (ie. twice your
>> number of threads) - you may be able to defeat the hyper-threaded
>> halving, and see if this workload happens to be one that does better
>> with hyper-threading than without."M.M.
>>
>> It might be worth mentioning the MAX_CURRENCY setting for controlling CPU
>> thread usage.
>>
>> Also, I wonder if the folks answering could answer one other question:
>> Does LibreOffice OnLine also use cpu threading in the same way it does
>> when run for desktop or headless? It would be with noting in the
>> documentation if it does not, IMO.
>>
>>
>>
>> On Thu, Apr 23, 2020 at 9:56 AM Stephen Fanning <
>> stevemfanning...@gmail.com> wrote:
>>
>>> Mike and  Luboš,
>>>
>>> Many thanks for your help on this topic.
>>>
>>> Regards,
>>>
>>> Steve
>>>
>>> On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
>>> wrote:
>>>
 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
 could
 >> structure his spreadsheet to gain the maximum performance benefits
 from the
 >> availability of multiple cores? Or maybe there are ways to organise a
 >> spreadsheet that will frustrate Calc's attempts to multi-thread,
 which we
 >> 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
 formula
 > (and get different results because of relative cell addressing). In
 UI terms,
 > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell
 and extend
 > 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

>>> ___
>>> LibreOffice mailing list
>>> libreoff...@lists.freedesktop.org
>>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>>
>>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Drew Jensen
To follow up on that.

Using LO 6.4 & 7.0 pre-release build on Ubuntu. Recalculating one of the
OpenCL test xls files just now.

Starting up with a command line
MAX_CONCURRENCY=0 ./soffice
Does turn the CPU threading off.

Restarting with a command line
MAX_CONCURRENCY=4 ./soffice
Turns it back on (for my AMD a5800 processor this will give me two threads,
because while the CPU is called a 4 core processor and it does have 4
accumulators it only has 2 floatingpoint cores and this is the limiting
factor it seems) with recalculation time for the workbook is ~2x faster.


On Thu, Apr 23, 2020 at 1:48 PM Drew Jensen 
wrote:

> BTW I'm copying a paragraph from an email on a different list.
>
> "Also - if you set MAX_CONCURRENCY=16 - or somesuch (ie. twice your
> number of threads) - you may be able to defeat the hyper-threaded
> halving, and see if this workload happens to be one that does better
> with hyper-threading than without."M.M.
>
> It might be worth mentioning the MAX_CURRENCY setting for controlling CPU
> thread usage.
>
> Also, I wonder if the folks answering could answer one other question:
> Does LibreOffice OnLine also use cpu threading in the same way it does
> when run for desktop or headless? It would be with noting in the
> documentation if it does not, IMO.
>
>
>
> On Thu, Apr 23, 2020 at 9:56 AM Stephen Fanning <
> stevemfanning...@gmail.com> wrote:
>
>> Mike and  Luboš,
>>
>> Many thanks for your help on this topic.
>>
>> Regards,
>>
>> Steve
>>
>> On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
>> wrote:
>>
>>> 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
>>> could
>>> >> structure his spreadsheet to gain the maximum performance benefits
>>> from the
>>> >> availability of multiple cores? Or maybe there are ways to organise a
>>> >> spreadsheet that will frustrate Calc's attempts to multi-thread,
>>> which we
>>> >> 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
>>> formula
>>> > (and get different results because of relative cell addressing). In UI
>>> terms,
>>> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and
>>> extend
>>> > 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
>>>
>> ___
>> LibreOffice mailing list
>> libreoff...@lists.freedesktop.org
>> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>>
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-documentation] Calc Guide files

2020-04-23 Thread Olivier Hallot

Hi Steve

Yes I did some work on the calc file, but in a local copy, independent 
local files.


Indeed we have a problem with the export of PDF with hidden section, the 
links result wrong and points to the wrong page. Also, the larger the 
file the worse. The bug affects the exported TOC and its bookmark export 
in the PDF, and perhaps more unseen troubles.


When editing the source file (a large odt file or a large master 
document - odm), LibreOffice links and references does work without any 
flaw (that I could have noticed). The issue is on the exported PDF with 
hidden section. There you'll see the TOC displays the correct page 
number but the link in the TOC is wrong.


The bug has been narrowed by Ilmari and is
https://bugs.documentfoundation.org/show_bug.cgi?id=130151

On the 6.2 chapter files in tdfcloud, I noticed a small and invisible 
issue: the section hide condition in chap 10 ad 14 has a typo. Fixing in 
place (published folder).


Regards
Olivier

Em 23/04/2020 16:32, Stephen Fanning escreveu:

  Hi Olivier,

I am aware that you have been doing some experimentation with the 6.2 Calc
Guide files to investigate problems with the generated PDF.

Have you made any significant changes to any files on your computer that
need to be put back into NextCloud? Or shall I start work on a 6.4 version
using the files in the */LibreOffice Documentation/English/Calc
Guide/6.2/Published* folder in NextCloud?

Regards,

Steve



--
Olivier Hallot
LibreOffice Documentation Coordinator
Comunidade LibreOffice
Rio de Janeiro - Brasil - Local Time: UTC-03:00
http://tdf.io/joinus

--
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-documentation] Find & replace attributes not working

2020-04-23 Thread toki
On 4/23/20 5:51 PM, Kenneth Hanson wrote:

>the current names of those buttons don't really make any sense. Note how the 
>"No Format" button clears both.

That is the normal and expected behaviour.
No format should leave the text with the default font, size, and colour.

jonathon

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-documentation] Find & replace attributes not working

2020-04-23 Thread toki
On 4/23/20 5:08 PM, Toni B wrote:
>Can anyone explain the difference between an attribute and a format in 
>"beginner" or "layperson" language? 

Format is presentation markup.
Attribute is the specific quality associated with the presentation markup.

Presentation markup is the stuff to use to make your document look good,
bad, ugly, etc.

Setting _Comic Sans_ as the font, is setting an attribute (the font) for
the presentation markup.

Setting _Libre Office Green 0_as the foreground colour, is setting an
attribute (ink colour) of the presentation markup.

Note: Attribute can also refer to syntactical markup. However, that
would be beyond the scope of the documentation you are working on.



jonathon



-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Meeting Minutes - Documentation - April 23rd, 2020

2020-04-23 Thread Olivier Hallot

Thursday April 23rd 2020, 18:00 UTC

Presents: Pulkit Krishna (12:00 UTC part, IRC), Olivier, Steve Fanning, 
Toni Blackwelder, Randolph Gamo, Dan Lewis, Leo Moons, Emiliano Vavassori


IRC chanel:
https://irc.documentfoundation.org/?settings=#libreoffice-doc

Telegram Group
https://t.me/joinchat/ALeRuUFCxyZY0wzoddldWQ

TDF Jitsi Room
https://jitsi.documentfoundation.org/tdfdocteam

Topics and Discussion:

SF:
(1) Would like to discuss the proposed revision to Appendix A of the 
Calc Guide (Keyboard Shortcuts) - see my message to the mailing list on 
13th April.

+ Added a 3rd column for Mac + review shortcuts from Customization UI.
   + Contents became dense (Olivier)
   + Suggest a section on Windows/Unix (same kbd) and another for Mac, 
all in same appendix A.

   + Is it going to increase size? (Leo)
   + just 10 pages (SF)

-> Go for 2 sections (all)

(2) Would like to confirm that the team is happy to drop Appendix B 
(Description of Functions) from the next issue of the Calc Guide.


-> Delete the chapter, all information is in Help and is accurate.

(3) Would like to discuss whether a usable alphabetical index would be 
benficial in the Calc Guide.


+ Index is useful (sf)
+ Jean Weber has concerns on quality of the selected words.
+ concordance file? - list of words, not very selective (oh, sf)
+ already tried in Calc, need rework/cleanup (sf)
-> Add it if good enough, otherwise just don't add it. (all)

(4) Discuss whether to produce a 6.4 Calc Guide or target 7.0. (I have 
analysed the Calc changes listed in the 6.3 and 6.4 release notes and 
can brief the meeting). Consider approach of regular small updates 
rather than big bang approach?

Pro 7.0
+ release at time of software, good for community/user
+ magnify release announcement impact
Pro 6.4
   + few addition, manageable
   + target end of May (sf) but depends on revision (sf)
   + I can help in revision of calc (Leo Moons)
-> Keep 6.4 release and prepare for 7.0

PK:
(1)When will Dan and Drew complete their review of the chapter 7 and 9 
of the base Guide Respectively?


+ More work is needed to complete and review, things have changed in the 
contents and needs rework (Dan Lewis)

   + issues in mail merge, new screenshots.

+ Question on tables with no keys, how to have it managed in the UI (Dan)
   + Use SQL to achieve that.

(2)Which version should we use for rewriting the base guide?

+ 4 or 5 items that requires the change.
+ Keep 6.4 and if ready, ok otherwise bump to 7.0.

(3)I have an idea in my mind ever since I joined the docs team. I know 
that it is hard to release the documentation of a partcular version 
along with it. I think a better idea would be to release the 
documentation when the version becomes stable. It will give more tome to 
the volunteers. The website team can add a line near the download button 
for stable version that this version has got documentation. Technology 
enthusiast, early adopter or power user can do without documentation I 
think.


+ topic not discussed -> next meeting

Misc:
+ Find and replace : diff between format and attribute (Toni)
  + confusing UI "attribute" vs "Format" (tb)
  + Seems 'Attribute' is for S of character formats, while 
'Format' is for paragraph formats. (olivier)
  + Help does no Help, will play around on the issue & communicate 
to mailing list (tb)

  + worth review the UI terminology to make it more intuitive (olivier)

Next meeting : *THURSDAY* May 7th 2020 at 18:00 UTC.
--
Olivier Hallot
LibreOffice Documentation Coordinator
Comunidade LibreOffice
Rio de Janeiro - Brasil - Local Time: UTC-03:00
http://tdf.io/joinus

--
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Calc Guide files

2020-04-23 Thread Stephen Fanning
 Hi Olivier,

I am aware that you have been doing some experimentation with the 6.2 Calc
Guide files to investigate problems with the generated PDF.

Have you made any significant changes to any files on your computer that
need to be put back into NextCloud? Or shall I start work on a 6.4 version
using the files in the */LibreOffice Documentation/English/Calc
Guide/6.2/Published* folder in NextCloud?

Regards,

Steve

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-documentation] Find & replace attributes not working

2020-04-23 Thread Kenneth Hanson
Toni,

Based on my current understanding, the current names of those buttons don't
really make any sense. Note how the "No Format" button clears both. I don't
think the current help text is any good either.

I would describe the "formats" you can search for as specific instances or
valuations of the "attributes".
attribute -> format a/b/c
color -> auto, red, blue, ...
font -> Liberation Sans, Liberation Serif...
etc.

But this has nothing to do with any normal meaning of the words "format" or
"attribute". So I wouldn't worry too much about the words themselves, and
just describe what the features do. Examples:
- If you want to search for *any* manually applied font, click the
"Attributes" button and check the box next to "Font", then click "OK".
- If you want to search for *a particular* manually applied font, such as
"Liberation Serif", click the "Format" button, then...

--Kenneth


On Thu, Apr 23, 2020 at 12:09 PM Toni B  wrote:

> Thank you for the helpful comments Luke.  I will plan to put your
> suggestion 4 in the documentation.
> Can anyone explain the difference between an attribute and a format in
> "beginner" or "layperson" language?  I don't think I have a good
> understanding.  I couldn't find it in the documentation, but perhaps I
> overlooked it.
> Have an awesome day!
> Toni
>
> On Wed, Apr 22, 2020 at 8:46 PM Luke (gmail) 
> wrote:
>
> > Four comments...
> >
> > 1/
> > To my mind there's a missing piece of information: the definition of (or
> > how to determine) the default font.
> >
> > Is it the Font used by the Default paragraph style (and if so, is it the
> > Family, the Asian Text Font, or the CTL Font)?
> >
> > Or is it something else, like the Default character style (and if so, is
> > it the Family, the Asian Text Font, or the CTL Font)?
> >
> > Or something else?
> >
> > 2/
> > The information callout says:
> > "If you want to find text with any font by name, click the Format button
> > in the Find & Replace dialog of LibreOffice Writer."
> >
> > Since people may read just the callout, should it perhaps instead say:
> > "If you want to find text with any font by name (that is not the default
> > font), click the Format button in the Find & Replace dialog of
> > LibreOffice Writer."
> >
> > 3/
> > Also, reading the text reminds me of why I originally joined the team -
> > to try to write up what I've been learning about what is meant by direct
> > formatting.
> >
> > I've had so little spare time I still haven't made any contribution in
> > that area.  So I wonder if, in the opening paragraph that opens by
> saying:
> > "You can search for text with attributes that are applied either by
> > direct formatting or by styles."
> > - whether the mention of "direct formatting" could be hyperlinked to any
> > documentation that explains what's meant by that.  Or is that an area
> > where I could still perhaps make a contribution?
> >
> > 4/
> > One final small suggestion: in the "To search for all font changes"
> > section, might it be a good idea to add a sentence like:
> > "To search for a specific font (e.g. Times Roman), or a particular font
> > style (e.g. Italic), select "Format..." instead of "Attributes..." in
> > the Find & Replace panel", followed by the "Font" tab in the provided
> > "Search for formatting" panel.
> >
> > luke
> >
> > On 23/4/20 2:37 am, S Shravz wrote:
> > > Glad if my inputs did sort this out in some way.
> > > I haven't referred to this topic in the guide.
> > >   Yes! few aspects are actually confusing for the end user to
> understand,
> > > even I have been changing it to be even more user friendly.
> > >
> > > Have a nice day!
> > >
> > > Kind regards
> > > Shravani
> > >
> > >
> > >
> > > On Wed, Apr 22, 2020, 9:40 AM Toni B  wrote:
> > >
> > >> Thank you all for the suggestions and research.
> > >> Shravani - I do see the behavior you describe and afterward, the text
> > makes
> > >> better sense.
> > >> As an "end user" I think this behavior is very confusing.  I would
> > expect
> > >> the Find/Replace to work as described in Find and Replace Paragraph
> > >> Styles.  I will have to let this sink in and see if I can find a
> better
> > way
> > >> to describe it for those first using it.  The expectation of choices
> > >> popping up in the Find and the Replace boxes really threw me off and I
> > >> think it may throw others off who are first using the software.  I
> > welcome
> > >> any suggestions or opinions.
> > >> Thanks again!
> > >> Toni
> > >>
> > >>
> > >> On Tue, Apr 21, 2020 at 3:10 PM S Shravz  wrote:
> > >>
> > >>> Hi Toni,
> > >>>
> > >>> I just looked into the steps you have drafted in your first email,
> when
> > >>> looked into online help I found related content in the below link
> which
> > >>> might answer your query:
> > >>>
> > >>>
> > >>
> >
> https://help.libreoffice.org/6.4/en-US/text/shared/guide/find_attributes.html?=WRITER=WIN
> > >>>
> > >>> The link says "For example, if you search for the Font attribute, all
> > >>> 

Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Drew Jensen
BTW I'm copying a paragraph from an email on a different list.

"Also - if you set MAX_CONCURRENCY=16 - or somesuch (ie. twice your
number of threads) - you may be able to defeat the hyper-threaded
halving, and see if this workload happens to be one that does better
with hyper-threading than without."M.M.

It might be worth mentioning the MAX_CURRENCY setting for controlling CPU
thread usage.

Also, I wonder if the folks answering could answer one other question:
Does LibreOffice OnLine also use cpu threading in the same way it does when
run for desktop or headless? It would be with noting in the documentation
if it does not, IMO.



On Thu, Apr 23, 2020 at 9:56 AM Stephen Fanning 
wrote:

> Mike and  Luboš,
>
> Many thanks for your help on this topic.
>
> Regards,
>
> Steve
>
> On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
> wrote:
>
>> 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
>> could
>> >> structure his spreadsheet to gain the maximum performance benefits
>> from the
>> >> availability of multiple cores? Or maybe there are ways to organise a
>> >> spreadsheet that will frustrate Calc's attempts to multi-thread, which
>> we
>> >> 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
>> formula
>> > (and get different results because of relative cell addressing). In UI
>> terms,
>> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and
>> extend
>> > 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
>>
> ___
> LibreOffice mailing list
> libreoff...@lists.freedesktop.org
> https://lists.freedesktop.org/mailman/listinfo/libreoffice
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-documentation] Find & replace attributes not working

2020-04-23 Thread Toni B
Thank you for the helpful comments Luke.  I will plan to put your
suggestion 4 in the documentation.
Can anyone explain the difference between an attribute and a format in
"beginner" or "layperson" language?  I don't think I have a good
understanding.  I couldn't find it in the documentation, but perhaps I
overlooked it.
Have an awesome day!
Toni

On Wed, Apr 22, 2020 at 8:46 PM Luke (gmail)  wrote:

> Four comments...
>
> 1/
> To my mind there's a missing piece of information: the definition of (or
> how to determine) the default font.
>
> Is it the Font used by the Default paragraph style (and if so, is it the
> Family, the Asian Text Font, or the CTL Font)?
>
> Or is it something else, like the Default character style (and if so, is
> it the Family, the Asian Text Font, or the CTL Font)?
>
> Or something else?
>
> 2/
> The information callout says:
> "If you want to find text with any font by name, click the Format button
> in the Find & Replace dialog of LibreOffice Writer."
>
> Since people may read just the callout, should it perhaps instead say:
> "If you want to find text with any font by name (that is not the default
> font), click the Format button in the Find & Replace dialog of
> LibreOffice Writer."
>
> 3/
> Also, reading the text reminds me of why I originally joined the team -
> to try to write up what I've been learning about what is meant by direct
> formatting.
>
> I've had so little spare time I still haven't made any contribution in
> that area.  So I wonder if, in the opening paragraph that opens by saying:
> "You can search for text with attributes that are applied either by
> direct formatting or by styles."
> - whether the mention of "direct formatting" could be hyperlinked to any
> documentation that explains what's meant by that.  Or is that an area
> where I could still perhaps make a contribution?
>
> 4/
> One final small suggestion: in the "To search for all font changes"
> section, might it be a good idea to add a sentence like:
> "To search for a specific font (e.g. Times Roman), or a particular font
> style (e.g. Italic), select "Format..." instead of "Attributes..." in
> the Find & Replace panel", followed by the "Font" tab in the provided
> "Search for formatting" panel.
>
> luke
>
> On 23/4/20 2:37 am, S Shravz wrote:
> > Glad if my inputs did sort this out in some way.
> > I haven't referred to this topic in the guide.
> >   Yes! few aspects are actually confusing for the end user to understand,
> > even I have been changing it to be even more user friendly.
> >
> > Have a nice day!
> >
> > Kind regards
> > Shravani
> >
> >
> >
> > On Wed, Apr 22, 2020, 9:40 AM Toni B  wrote:
> >
> >> Thank you all for the suggestions and research.
> >> Shravani - I do see the behavior you describe and afterward, the text
> makes
> >> better sense.
> >> As an "end user" I think this behavior is very confusing.  I would
> expect
> >> the Find/Replace to work as described in Find and Replace Paragraph
> >> Styles.  I will have to let this sink in and see if I can find a better
> way
> >> to describe it for those first using it.  The expectation of choices
> >> popping up in the Find and the Replace boxes really threw me off and I
> >> think it may throw others off who are first using the software.  I
> welcome
> >> any suggestions or opinions.
> >> Thanks again!
> >> Toni
> >>
> >>
> >> On Tue, Apr 21, 2020 at 3:10 PM S Shravz  wrote:
> >>
> >>> Hi Toni,
> >>>
> >>> I just looked into the steps you have drafted in your first email, when
> >>> looked into online help I found related content in the below link which
> >>> might answer your query:
> >>>
> >>>
> >>
> https://help.libreoffice.org/6.4/en-US/text/shared/guide/find_attributes.html?=WRITER=WIN
> >>>
> >>> The link says "For example, if you search for the Font attribute, all
> >>> instances of text that do not use the default font are found". So I
> guess
> >>> the "Font" function works only to search for the font which doesn't
> >> default
> >>> in the document. Same with the font color option as well when font
> color
> >> is
> >>> changed in the document and the "Find next" option is clicked with the
> >>> "Font color" attribute selected, it works. I tried both the options and
> >> it
> >>> worked for me as per whats mentioned in the link.
> >>>
> >>> Hope my explanation makes sense.
> >>>
> >>> Kind regards
> >>> Shravani
> >>>
> >>> On Tue, Apr 21, 2020 at 12:45 PM Toni B  wrote:
> >>>
>  Is anyone able to get the attributes search to work?
> 
>  On Tue, Apr 21, 2020 at 11:49 AM Ilmari Lauhakangas <
>  ilmari.lauhakan...@libreoffice.org> wrote:
> 
> > Maybe you are seeing
> > https://bugs.documentfoundation.org/show_bug.cgi?id=106076
> >
> > Ilmari
> >
> > Toni B kirjoitti 21.4.2020 klo 18.42:
> >> Hello Team!
> >>
> >> I could use some guidance.  I am double checking some things in
>  updating
> >> the Writer Chapter 3 Guide.  I can not get the *Find & Replace >
> 

[libreoffice-documentation] Re: Getting Started Guide

2020-04-23 Thread randolph gamo
Ok, no problem.

Le jeu. 23 avr. 2020 4:18 PM, Claire Wood  a
écrit :

> Sure, but it will have to be tomorrow now
>
> On Thu, 23 Apr 2020 at 15:41, randolph gamo 
> wrote:
>
>> Great!
>> Besides,
>> the chapter on draw isequally avalaible for a second review.
>> Would you be generous enough to have an eye on it?
>> Regards!
>>
>> Le jeu. 23 avr. 2020 3:38 PM, Claire Wood  a
>> écrit :
>>
>>> Done!
>>>
>>> On Thu, 23 Apr 2020 at 14:03, randolph gamo 
>>> wrote:
>>>
 Hi Claire,
 Great!
 Now you need to modify the guide status file, so that everybody knows
 the second review is done.
 This is how to do it:

1. get to the getting started guide 6.4 folder
2. Open Guide Status GS
3. At line 10, in the column Rev2, add your initials. In the column
Return Date, add today's date.
4. Save the file

 If you have any trouble, let me know
 Regards.





 *GAMO NANA Servais Randolph*,
 "Au service du pauvre et du malheureux"
 TEL: +237 697518768




 On Thu, Apr 23, 2020 at 1:44 PM Claire Wood 
 wrote:

> Hi all, I have done a review of the Getting Started with Impress
> chapter. The only thing I didn’t test was the last bit when you need to
> download an app to your phone. I have regular issues with my phone so I
> didn’t want to complicate matters
>
> Kind regards
>
> Claire
> --
> Best wishes
>
> Claire Wood
>
 --
>>> Best wishes
>>>
>>> Claire Wood
>>>
>> --
> Best wishes
>
> Claire Wood
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Re: Getting Started Guide

2020-04-23 Thread Claire Wood
Sure, but it will have to be tomorrow now

On Thu, 23 Apr 2020 at 15:41, randolph gamo  wrote:

> Great!
> Besides,
> the chapter on draw isequally avalaible for a second review.
> Would you be generous enough to have an eye on it?
> Regards!
>
> Le jeu. 23 avr. 2020 3:38 PM, Claire Wood  a
> écrit :
>
>> Done!
>>
>> On Thu, 23 Apr 2020 at 14:03, randolph gamo 
>> wrote:
>>
>>> Hi Claire,
>>> Great!
>>> Now you need to modify the guide status file, so that everybody knows
>>> the second review is done.
>>> This is how to do it:
>>>
>>>1. get to the getting started guide 6.4 folder
>>>2. Open Guide Status GS
>>>3. At line 10, in the column Rev2, add your initials. In the column
>>>Return Date, add today's date.
>>>4. Save the file
>>>
>>> If you have any trouble, let me know
>>> Regards.
>>>
>>>
>>>
>>>
>>>
>>> *GAMO NANA Servais Randolph*,
>>> "Au service du pauvre et du malheureux"
>>> TEL: +237 697518768
>>>
>>>
>>>
>>>
>>> On Thu, Apr 23, 2020 at 1:44 PM Claire Wood 
>>> wrote:
>>>
 Hi all, I have done a review of the Getting Started with Impress
 chapter. The only thing I didn’t test was the last bit when you need to
 download an app to your phone. I have regular issues with my phone so I
 didn’t want to complicate matters

 Kind regards

 Claire
 --
 Best wishes

 Claire Wood

>>> --
>> Best wishes
>>
>> Claire Wood
>>
> --
Best wishes

Claire Wood

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Re: Getting Started Guide

2020-04-23 Thread Claire Wood
Done!

On Thu, 23 Apr 2020 at 14:03, randolph gamo  wrote:

> Hi Claire,
> Great!
> Now you need to modify the guide status file, so that everybody knows the
> second review is done.
> This is how to do it:
>
>1. get to the getting started guide 6.4 folder
>2. Open Guide Status GS
>3. At line 10, in the column Rev2, add your initials. In the column
>Return Date, add today's date.
>4. Save the file
>
> If you have any trouble, let me know
> Regards.
>
>
>
>
>
> *GAMO NANA Servais Randolph*,
> "Au service du pauvre et du malheureux"
> TEL: +237 697518768
>
>
>
>
> On Thu, Apr 23, 2020 at 1:44 PM Claire Wood 
> wrote:
>
>> Hi all, I have done a review of the Getting Started with Impress chapter.
>> The only thing I didn’t test was the last bit when you need to download an
>> app to your phone. I have regular issues with my phone so I didn’t want to
>> complicate matters
>>
>> Kind regards
>>
>> Claire
>> --
>> Best wishes
>>
>> Claire Wood
>>
> --
Best wishes

Claire Wood

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Re: Getting Started Guide

2020-04-23 Thread randolph gamo
Great!
Besides,
the chapter on draw isequally avalaible for a second review.
Would you be generous enough to have an eye on it?
Regards!

Le jeu. 23 avr. 2020 3:38 PM, Claire Wood  a
écrit :

> Done!
>
> On Thu, 23 Apr 2020 at 14:03, randolph gamo 
> wrote:
>
>> Hi Claire,
>> Great!
>> Now you need to modify the guide status file, so that everybody knows the
>> second review is done.
>> This is how to do it:
>>
>>1. get to the getting started guide 6.4 folder
>>2. Open Guide Status GS
>>3. At line 10, in the column Rev2, add your initials. In the column
>>Return Date, add today's date.
>>4. Save the file
>>
>> If you have any trouble, let me know
>> Regards.
>>
>>
>>
>>
>>
>> *GAMO NANA Servais Randolph*,
>> "Au service du pauvre et du malheureux"
>> TEL: +237 697518768
>>
>>
>>
>>
>> On Thu, Apr 23, 2020 at 1:44 PM Claire Wood 
>> wrote:
>>
>>> Hi all, I have done a review of the Getting Started with Impress
>>> chapter. The only thing I didn’t test was the last bit when you need to
>>> download an app to your phone. I have regular issues with my phone so I
>>> didn’t want to complicate matters
>>>
>>> Kind regards
>>>
>>> Claire
>>> --
>>> Best wishes
>>>
>>> Claire Wood
>>>
>> --
> Best wishes
>
> Claire Wood
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Stephen Fanning
 Mike and  Luboš,

Many thanks for your help on this topic.

Regards,

Steve

On Thu, 23 Apr 2020 at 11:16, Mike Kaganski 
wrote:

> 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
> could
> >> structure his spreadsheet to gain the maximum performance benefits from
> the
> >> availability of multiple cores? Or maybe there are ways to organise a
> >> spreadsheet that will frustrate Calc's attempts to multi-thread, which
> we
> >> 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
> formula
> > (and get different results because of relative cell addressing). In UI
> terms,
> > write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and
> extend
> > 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
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Draw Guide 6.4 Preface and Chapter 5

2020-04-23 Thread Peter Schofield
The Preface and Chapter 5 of the Draw Guide 6.4 have been uploaded to FEEDBACK 
02 folder on LO NextCloud.

They are ready for review and comment.

Hopefully Preface and Chapters 1 thru 5 can then be published.

Regards
Peter Schofield
psaut...@gmail.com




-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy



[libreoffice-documentation] LibreOffice Base Guide

2020-04-23 Thread Pulkit Krishna
Hello Rob & Jean,
After a discussion with oliver, and as jean suggested, I think we should
edit the base guide in v7 and not in v6.4. We should also let v6.4 be
released. V7 is a major release with rebranding and all. We should make a
good v7 book.
Pulkit Krishna

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] LibreOffice Base Guide 6.2

2020-04-23 Thread Pulkit Krishna
A reviewer with windows system and a good knowledge of Base Macros is
needed for review of access2base documentation in base guide. I have not
written this portion yet but I want to make sure there is a reviewer who
can add the screenshots as well. I will copy most of the info from A2B
website as I do not have a windows system to test new documentation on.

Drew: After a discussion with Oliver, I have started this work. I know that
you were doiing this work but you are taking too much time and I wanted the
base guide 6.2 to be released as soon as possible because base guide has
not been updated since v4.0. We will make it error free in version 7.0 If
you want to continue with your work then you can write to me.
Pulkit Krishna

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Re: Getting Started Guide

2020-04-23 Thread randolph gamo
Hi Claire,
Great!
Now you need to modify the guide status file, so that everybody knows the
second review is done.
This is how to do it:

   1. get to the getting started guide 6.4 folder
   2. Open Guide Status GS
   3. At line 10, in the column Rev2, add your initials. In the column
   Return Date, add today's date.
   4. Save the file

If you have any trouble, let me know
Regards.





*GAMO NANA Servais Randolph*,
"Au service du pauvre et du malheureux"
TEL: +237 697518768




On Thu, Apr 23, 2020 at 1:44 PM Claire Wood 
wrote:

> Hi all, I have done a review of the Getting Started with Impress chapter.
> The only thing I didn’t test was the last bit when you need to download an
> app to your phone. I have regular issues with my phone so I didn’t want to
> complicate matters
>
> Kind regards
>
> Claire
> --
> Best wishes
>
> Claire Wood
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


[libreoffice-documentation] Getting Started Guide

2020-04-23 Thread Claire Wood
Hi all, I have done a review of the Getting Started with Impress chapter.
The only thing I didn’t test was the last bit when you need to download an
app to your phone. I have regular issues with my phone so I didn’t want to
complicate matters

Kind regards

Claire
-- 
Best wishes

Claire Wood

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Mike Kaganski
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 could
>> structure his spreadsheet to gain the maximum performance benefits from the
>> availability of multiple cores? Or maybe there are ways to organise a
>> spreadsheet that will frustrate Calc's attempts to multi-thread, which we
>> 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 formula 
> (and get different results because of relative cell addressing). In UI terms, 
> write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and extend 
> 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

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Luboš Luňák
On Wednesday 22 of April 2020, Olivier Hallot wrote:
> Hi Developers
>
> Can charitable soul involved with threading in Calc spend a couple of
> minutes to write an outline of what we should look to write a section on
> the topic in our guide and Help? Just the outline and some pointers for
> our investigation.
>
> We think this feature is a plus, but it is not clear if and how an end
> user will benefit.

 The "Enable multi-threaded calculation" checkbox is one of those settings 
that aren't actually a preference, in an ideal world they should always be 
enabled, and in fact shouldn't even exist as the thing should Just Work(TM). 
We have others like that, 'Allow use of OpenCL', 'Use OpenGL/Skia for all 
rendering', etc. So AFAICT the purpose of those settings is to admit that we 
don't live in an ideal world and the setting allows people to disable the 
feature in case it turns out it's buggy (which incidentally is relatively 
more likely for all the settings I mentioned).

 So the way I see it the best thing the docs can say about it is something 
along the lines of "this does roughly that, don't touch it unless you know 
you want to touch it".

...
> One of the issues we chose to ignore in the 6.2 Calc Guide was
> multi-threading. The 6.2 Calc Guide contains the following mention of it,
> when describing the Tools > Options > LibreOffice Calc > Calculate page:
>
> CPU threading settings section
> Enable multi-threaded calculation controls the use of multi-threading /
> parallelism, which can be used to speed up LibreOffice Calc calculations on
> computers with multiple processing cores.

-- 
 Luboš Luňák
 l.lu...@collabora.com

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Luboš Luňák
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 could
> structure his spreadsheet to gain the maximum performance benefits from the
> availability of multiple cores? Or maybe there are ways to organise a
> spreadsheet that will frustrate Calc's attempts to multi-thread, which we
> 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 formula 
(and get different results because of relative cell addressing). In UI terms, 
write e.g. "=A1*2" to B1, grab the bottom-right corner of the cell and extend 
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.

-- 
 Luboš Luňák
 l.lu...@collabora.com

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: Fwd: [libreoffice-documentation] Multi-threading in Calc

2020-04-23 Thread Stephen Fanning
Hi Luboš,

Many thanks for your thoughts on the checkbox, which confirms what I
expected.

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 could
structure his spreadsheet to gain the maximum performance benefits from the
availability of multiple cores? Or maybe there are ways to organise a
spreadsheet that will frustrate Calc's attempts to multi-thread, which we
ought to advise against?

Any further help would be greatly appreciated.

Regards,

Steve

On Thu, 23 Apr 2020 at 09:58, Luboš Luňák  wrote:

> On Wednesday 22 of April 2020, Olivier Hallot wrote:
> > Hi Developers
> >
> > Can charitable soul involved with threading in Calc spend a couple of
> > minutes to write an outline of what we should look to write a section on
> > the topic in our guide and Help? Just the outline and some pointers for
> > our investigation.
> >
> > We think this feature is a plus, but it is not clear if and how an end
> > user will benefit.
>
>  The "Enable multi-threaded calculation" checkbox is one of those settings
> that aren't actually a preference, in an ideal world they should always be
> enabled, and in fact shouldn't even exist as the thing should Just
> Work(TM).
> We have others like that, 'Allow use of OpenCL', 'Use OpenGL/Skia for all
> rendering', etc. So AFAICT the purpose of those settings is to admit that
> we
> don't live in an ideal world and the setting allows people to disable the
> feature in case it turns out it's buggy (which incidentally is relatively
> more likely for all the settings I mentioned).
>
>  So the way I see it the best thing the docs can say about it is something
> along the lines of "this does roughly that, don't touch it unless you know
> you want to touch it".
>
> ...
> > One of the issues we chose to ignore in the 6.2 Calc Guide was
> > multi-threading. The 6.2 Calc Guide contains the following mention of it,
> > when describing the Tools > Options > LibreOffice Calc > Calculate page:
> >
> > CPU threading settings section
> > Enable multi-threaded calculation controls the use of multi-threading /
> > parallelism, which can be used to speed up LibreOffice Calc calculations
> on
> > computers with multiple processing cores.
>
> --
>  Luboš Luňák
>  l.lu...@collabora.com
>

-- 
To unsubscribe e-mail to: documentation+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/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy