Re-send of previous email, hopefully with more legible formatting!
Sorry.
Hi Felipe,
Many thanks for another thorough and helpful review. The chapter is back in the
Draft folder for second review.
Two matters arising:
(1) Syntax of the GETPIVOTDATA function. The syntax specified in the first
draft of this chapter matches the help and is believed to be correct. The Calc
Functions wiki area is very much a work in progress (see below), and the syntax
quoted there is not currently correct. I have rejected your proposed change to
the first syntax variation but have included a note to explain that the square
brackets are present to indicate optional parameters (which I hope helps).
(2) One tip concerning the changes that you have proposed for various formulas
to use the Code character style. If the formula is in a separate paragraph
which has already been set to the Code paragraph style, then you do not need to
also set the Code character style. Not a problem, just a note for saving time
in the future.
Just for everybody's information, the Calc Functions wiki area is soon to
undergo a major overhaul under the Google Summer of Documents 2020 program.
This will resolve the sort of problem mentioned above, along with many others!
Regards,
Steve
------ Original Message ------
From: "Felipe Viggiano" <felipeviggi...@gmail.com>
To: "Steve (GMail)" <stevemfanning...@gmail.com>
Cc: "LibreOffice Documentation" <documentation@global.libreoffice.org>
Sent: 28/08/2020 03:28:00
Subject: Re: [libreoffice-documentation] Re[2]: Calc Guide v7.0
Hello everyone,
Steve,
Just uploaded the first review on the CG7008 - Pivot Tales in the Feedback
folder.
I did manage to reproduce and understand all the directions made in the
document, so the review contains just a few minor suggestions.
The Calc Status Guide has been updated.
Best regards,
Felipe Viggiano
Em qua., 26 de ago. de 2020 às 18:40, Dan Lewis <elderdanle...@gmail.com>
escreveu:
Recently I have bought new tower computer and have dual booted Windows 10 and
buntu20.04. This afternoon, I downloaded 7.0.1.1 for windows (Dated 14 August 2020)and
installed it. When I ran Calc, I entered 1-10 in column A in rows 1-10. In B1 I entered
this formula: ATAN(A1). Then I drug this formula down to B10. Then I pressed
"Ctrl+`". Cell B1-B10 changed from the arc tangent values to the formulas. So,
this is not a bug for the pre-releases that I use. I will update the bug a little later
today.
Dan
On 8/26/20 14:56, Felipe Viggiano wrote:
Hello Dan,
Apparently it's something with the release version. I did the report on
Bugzilla (https://bugs.documentfoundation.org/show_bug.cgi?id=136129) and this
was confirmed by another user, with the 7.1.0.0.alpha0+ version.
In my case, I have installed the 7.0.0.3 version on Ubuntu (20.04 as well).
Best regards,
Felipe Viggiano
Em qua., 26 de ago. de 2020 às 12:22, Dan Lewis <elderdanle...@gmail.com>
escreveu:
I use Ubuntu 20.04 and 7.0.1.1 (pre-release) from the LibreOffice
website. "Ctrl+`" works just like View > Show Formula. Now there might
be a problem with Ubuntu's release of LibreOffice...
Dan
On 8/25/20 13:56, Steve (GMail) wrote:
> Hi Felipe,
>
> I am a little concerned about the failure of the View > Show Formula
> shortcut on your system. I have seen this shortcut work on an Ubuntu
> installation (albeit using LO 6.4) running in a Virtual Terminal in
> VMware. If there's a problem with the Linux implementation in this
> respect, we'll need to update Appendix A as well.
>
> Does the menu option contain the string "Ctrl+`" in your
> installation? It is simply that the shortcut doesn't work? Are we in
> "bug" territory again?
>
> Regards,
>
> Steve
>
>
> ------ Original Message ------
> From: "Felipe Viggiano" <felipeviggi...@gmail.com>
> To: "Steve (GMail)" <stevemfanning...@gmail.com>
> Cc: "Documentation Team" <Documentation@global.libreoffice.org>
> Sent: 25/08/2020 02:49:35
> Subject: Re: Re[9]: [libreoffice-documentation] Re[2]: Calc Guide v7.0
>
>> Hello Steve,
>>
>> Thanks for the feedback!
>>
>> About the shortcut, I"m currently using Linux (Ubuntu), but it could
>> be a distribution difference. May I suggest something like this:
>>
>> Formulas can be toggled on / off in the menu option View > Show
>> Formula, and, depending on the operational system, by the shortcut
>> Ctrl+` (grave accent).
>>
>> About the multi-threading, I can understand that this could be useful
>> information for advanced users.
>>
>> Best regards,
>> Felipe Viggiano
>>
>> Em seg., 24 de ago. de 2020 às 15:53, Steve (GMail)
>> <stevemfanning...@gmail.com> escreveu:
>>> Hi Felipe,
>>>
>>> Many thanks for the comments on Chapter 7 (Using Formulas and
>>> Functions). I have actioned most of the points you raised, and the
>>> document is now in the Draft for second review.
>>>
>>> A few matters arising:
>>> In the section entitled “Compatibility with other spreadsheet
>>> applications”, I’ve amended the number of functions that are unique to
>>> Calc. It now reads 30, to match the functions listed on the referenced
>>> wiki page, rather than the total number stated on that page!
>>> With regards to your comment that the keyboard shortcut associated with
>>> View > Show Formula does not work for you. I believe that the shortcut
>>> works on Windows and Linux, but I do not think there is a corresponding
>>> key sequence for macOS. This is already reflected in Appendix A and I
>>> have updated the Tip after Figure 19 to clarify further.
>>> In the section entitled “Multi-threading”, I decided to retain the last
>>> paragraph. I think it is quite legitimate to draw a reader’s attention
>>> to there being other ways (for power users) to control multi-threading,
>>> even though they are not described in the guide.
>>>
>>> Thanks again.
>>>
>>> Regards,
>>>
>>> Steve
>>>
>>>
>>>
>>> ------ Original Message ------
>>> From: "Felipe Viggiano" <felipeviggi...@gmail.com>
>>> To: "Steve (GMail)" <stevemfanning...@gmail.com>
>>> Cc: "Documentation Team" <Documentation@global.libreoffice.org>
>>> Sent: 22/08/2020 02:14:18
>>> Subject: Re: Re[7]: [libreoffice-documentation] Re[2]: Calc Guide v7.0
>>>
>>> >Hello everyone,
>>> >
>>> >Steve,
>>> >
>>> >Just uploaded a first review on the CG7007 - FormulasAndFunction.
>>> >
>>> >Only a few minor suggestions. The chapter is very well written and I
>>> >managed to reproduce and understand every step and orientation.
>>> >
>>> >I'm checking out the CG7008 - Pivot Tables for a first review. Expect
>>> >to return it by Thursday (27Ago2020).
>>> >
>>> >The Calc Status Guide has been updated.
>>> >
>>> >Best regards,
>>> >Felipe Viggiano
>>> >
>>> >
>>> >Em qui., 20 de ago. de 2020 às 15:48, Steve (GMail)
>>> ><stevemfanning...@gmail.com> escreveu:
>>> >>All,
>>> >>
>>> >>I have finished updating Appendices A (Keyboard Shortcuts) and B
>>> >>(Error
>>> >>Codes), and placed the files in the Draft folder ready for first
>>> >>review.
>>> >>
>>> >>As with earlier chapters, please do not waste time reviewing the
>>> front
>>> >>matter or the template used for these chapters (other than adding
>>> your
>>> >>name to the list of contributors of course!)
>>> >>
>>> >>Regards,
>>> >>
>>> >>Steve
>>> >>
>>> >> >>>>>>
>>> >> >>>>>>>
>>> >> >>>>>>>------ Original Message ------
>>> >> >>>>>>>From: "Steve (GMail)" <stevemfanning...@gmail.com>
>>> >> >>>>>>>To: "Documentation Team"
>>> <Documentation@global.libreoffice.org>
>>> >> >>>>>>>Sent: 23/07/2020 20:28:44
>>> >> >>>>>>>Subject: Calc Guide v7.0
>>> >> >>>>>>>
>>> >> >>>>>>>>Hi All,
>>> >> >>>>>>>>
>>> >> >>>>>>>>I have started a detailed read through the chapters of
>>> the 6.4
>>> >>Calc
>>> >> >>>>>>>>Guide to identify the changes needed for 7.0.
>>> >> >>>>>>>>
>>> >> >>>>>>>>The first two chapters (0 - Preface and 1 - Introduction)
>>> have
>>> >>been
>>> >> >>>>>>>>updated and placed in the appropriate Draft folder within
>>> >>NextCloud.
>>> >> >>>>>>>>Please could somebody find time to perform a first review of
>>> >>these
>>> >> >>>>>>>>chapters?
>>> >> >>>>>>>>
>>> >> >>>>>>>>Echoing Peter Schofield's comments in relation to the
>>> Impress
>>> >>Guide,
>>> >> >>>>>>>>please do not waste time reviewing the front matter or the
>>> >>template
>>> >> >>>>>>>>used for these chapters (other than adding your name to the
>>> >>list of
>>> >> >>>>>>>>contributors of course!). I will sort out these aspect prior
>>> >>to
>>> >> >>>>>>>>publication, once the 7.0 template is finalised.
>>> >> >>>>>>>>
>>> >> >>>>>>>>Regards and thanks,
>>> >> >>>>>>>>
>>> >> >>>>>>>>Steve Fanning
>>> >> >>>>>>>>
>>> >> >>>>>>--
>>> >> >>>>>>To unsubscribe e-mail to:
>>> >>documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@global.libreoffice.org>>
>>> >><mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%252bunsubscr...@global.libreoffice.org
<mailto:documentation%25252bunsubscr...@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
>>> >> >>>>>>
>>> >> >>>>>>
>>> >> >>>>>
>>> >> >>>>
>>> >> >>>
>>> >> >>
>>> >> >>
>>> >> >>-- To unsubscribe e-mail to:
>>> >>documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@global.libreoffice.org>>
>>> >><mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%252bunsubscr...@global.libreoffice.org
<mailto:documentation%25252bunsubscr...@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
>>> >> >
>>> >>
>>> >>
>>> >>--
>>> >>To unsubscribe e-mail to:
>>> >>documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@global.libreoffice.org>>
>>> >><mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%252bunsubscr...@global.libreoffice.org
<mailto:documentation%25252bunsubscr...@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
>>> --
>>> To unsubscribe e-mail to:
>>> documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@global.libreoffice.org>
>>> <mailto:documentation%2bunsubscr...@global.libreoffice.org
<mailto:documentation%252bunsubscr...@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
--
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
<mailto:documentation%2bunsubscr...@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
-- 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
--
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
