Thanks Gordon. I can see the files okay.
Steve
------ Original Message ------
From: "Kevin Berry" <[email protected]>
To: "Steve (GMail)" <[email protected]>
Cc: "Documentation Team" <[email protected]>
Sent: 28/06/2020 23:32:31
Subject: Re: Re[2]: Helping with the 7.0 Calc Guide
Okay, got it finished!
Gordon Bates
[email protected]
github.com/jdoes
On Sun, Jun 28, 2020 at 2:44 PM Steve (GMail)
<[email protected]> wrote:
Thanks Gordon.
Once you have created the folders and the tracking spreadsheet, you
shouldn't need to take any extra steps for others to access them.
Regards,
Steve
------ Original Message ------
From: "Kevin Berry" <[email protected]>
To: "Steve (GMail)" <[email protected]>
Cc: "Documentation Team" <[email protected]>
Sent: 28/06/2020 22:24:32
Subject: Re: Helping with the 7.0 Calc Guide
I am creating the folder structure in NextCLoud. Does everybody
automatically get access to this, or does that take extra steps?
Gordon Bates
[email protected]
github.com/jdoes
On Thu, Jun 25, 2020 at 5:29 AM Steve (GMail)
<[email protected]> wrote:
Hi Gordon,
I hope that you are okay.
During the coming days, I intend making some tidy-ups to the Calc
Guide’s .ODT files, in preparation for the 7.0 update. This is
probably a one-person job.
However, while I am doing these edits. there are a few related
matters that somebody could address. As you have expressed an
interest in continuing to help with the Calc Guide, maybe you would
like to address some or all of these?
Somebody could create a 7.0 structure in the Calc Guide area of
NextCloud. This will require the same folders as the 6.4 structure.
It will also need a tracking spreadsheet like that used for 6.4, but
with the various dates etc. deleted, ready to start afresh.Somebody
could investigate the LO extension called “Code Highlighter”
(https://extensions.libreoffice.org/en/extensions/show/code-highlighter)
to see whether we can use it to improve the appearance of the macro
code segments that appear in Chapters 12 and 13 of the Calc Guide.
This extension was discussed and recommended in a recent
Documentation Team meeting, but I have not had time to see what
impacts it will have on our chapters.Reading the 7.0 Release Notes,
you may have noticed that Calc 7.0 has two new functions, RAND.NV()
and RANDBETWEEN.NV(). Although we do not need to discuss the gory
detail of these two in the Calc Guide (covered in Help and,
eventually, on the Calc Functions wiki), their very existence leads
to asking “what is a volatile function?”. Therefore, I think we need
to draft a new (short) section to be put into Chapter 7 (Using
Formulas and Functions) of the Calc Guide to discuss the concept of
a volatile function in Calc. (The word “volatile” does not appear in
the 6.4 version). Somebody could have a go at drafting such a
section in a standalone ODT file, to be entitled “Volatile
functions”? Sources of background information include: •
The Release Notes for 7.0
(https://wiki.documentfoundation.org/ReleaseNotes/7.0#New_spreadsheet_functions)
and maybe the discussions that took place in progressing the
associated bug (127831).
• ODF version 1.2
(http://docs.oasis-open.org/office/v1.2/OpenDocument-v1.2-part2.html)
– see Section 3.5 “When recalculation occurs”.
• The source code contains a function entitled
“IsOpCodeVolatile” which determines whether a function called by a
user is volatile or not. From this code I have gleaned that the
volatile Calc functions are: RAND, RANDBETWEEN, NOW, TODAY, FORMULA,
INFO, INDIRECT, and OFFSET.
• The descriptions of the two new functions that have
been included in the Help system at
https://help.libreoffice.org/7.1/en-US/text/shared/05/new_help.html.
Let me know if you need any more information or help.
Regards,
Steve
--
To unsubscribe e-mail to: [email protected]
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
