Hello Steve, "* So,*
*=GETPIVOTDATA(target field; pivot table)is fine. But you wouldn't normally enter=GETPIVOTDATA(target field; pivot table;)*" Yes, now I can see the proposed semicolon position in the formula. Thanks for the explanation! Best regards, Felipe Viggiano Em seg., 31 de ago. de 2020 às 09:23, Steve (GMail) < stevemfanning...@gmail.com> escreveu: > Hi Felipe, > > I think that the change you are proposing to the GETPIVOTDATA syntax is > not correct. For example, if you are going to call the function with > just two parameters then you do not need to include a semicolon after > the second parameter. > > So, > =GETPIVOTDATA(target field; pivot table) > is fine. But you wouldn't normally enter > =GETPIVOTDATA(target field; pivot table;) > > The proposed syntax of GETPIVOTDATA(TargetField; pivot table; [Field 1; > Item 1];...; [Field 126; Item 126]) implies that the semicolon is > necessary after "pivot table" which is not so - it is optional and only > needed when one or more optional Field/Item pairs follow. > > I propose to retain the syntax in the chapter as is. > > Regards, > > Steve > > > ------ Original Message ------ > From: "Felipe Viggiano" <felipeviggi...@gmail.com> > To: "Steve (GMail)" <stevemfanning...@gmail.com> > Cc: "documentation list" <documentation@global.libreoffice.org> > Sent: 31/08/2020 11:44:40 > Subject: Re: Fw: Re[2]: [libreoffice-documentation] Re[2]: Calc Guide > v7.0 > > >Hello Steve, > > > >Once again, many thanks for the feedback, as always they provide me a > >great learning opportunity. > > > >About the matters: > > > >1) The square brackets are OK, but I still feel strange about the > >semicolons positions: > >Maybe instead of this: > >GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field > >126; Item 126]] > > > >It could be something like this: > >GETPIVOTDATA(TargetField; pivot table; [Field 1; Item 1];...; [Field > >126; Item 126]) > > > >2) Sorry, I did not notice that. I'm gonna keep that in mind for the > >next reviews. > > > >Best regards, > >Felipe Viggiano > > > >Em sáb., 29 de ago. de 2020 às 16:41, Steve (GMail) > ><stevemfanning...@gmail.com> escreveu: > >>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>>> > >> >>>> >>> >><mailto:documentation%2bunsubscr...@global.libreoffice.org > >><mailto:documentation%252bunsubscr...@global.libreoffice.org> > >><mailto:documentation%252bunsubscr...@global.libreoffice.org > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org>> > >> >>>> >>> <mailto:documentation%252bunsubscr...@global.libreoffice.org > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org> > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org > >><mailto:documentation%2525252bunsubscr...@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>>> > >> >>>> >>> >><mailto:documentation%2bunsubscr...@global.libreoffice.org > >><mailto:documentation%252bunsubscr...@global.libreoffice.org> > >><mailto:documentation%252bunsubscr...@global.libreoffice.org > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org>> > >> >>>> >>> <mailto:documentation%252bunsubscr...@global.libreoffice.org > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org> > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org > >><mailto:documentation%2525252bunsubscr...@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>>> > >> >>>> >>> >><mailto:documentation%2bunsubscr...@global.libreoffice.org > >><mailto:documentation%252bunsubscr...@global.libreoffice.org> > >><mailto:documentation%252bunsubscr...@global.libreoffice.org > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org>> > >> >>>> >>> <mailto:documentation%252bunsubscr...@global.libreoffice.org > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org> > >><mailto:documentation%25252bunsubscr...@global.libreoffice.org > >><mailto:documentation%2525252bunsubscr...@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 > >><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