Hello everyone, Just checked out the CG7009 - DataAnalysis for a first review. Expected return by Friday (04Sept2020).
The Calc Guide Status has been updated. Best regards, Felipe Viggiano Em seg., 31 de ago. de 2020 às 07:44, Felipe Viggiano < [email protected]> escreveu: > 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) < > [email protected]> 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" <[email protected]> >> To: "Steve (GMail)" <[email protected]> >> Cc: "LibreOffice Documentation" <[email protected]> >> 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 <[email protected]> >> 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 < >> [email protected]> 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" <[email protected]> >> >>>> > To: "Steve (GMail)" <[email protected]> >> >>>> > Cc: "Documentation Team" <[email protected]> >> >>>> > 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) >> >>>> >> <[email protected]> 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" <[email protected]> >> >>>> >>> To: "Steve (GMail)" <[email protected]> >> >>>> >>> Cc: "Documentation Team" <[email protected]> >> >>>> >>> 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) >> >>>> >>> ><[email protected]> 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)" <[email protected]> >> >>>> >>> >> >>>>>>>To: "Documentation Team" >> >>>> >>> <[email protected]> >> >>>> >>> >> >>>>>>>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: >> >>>> >>> >>[email protected] <mailto: >> documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[email protected]>> >> >>>> >>> >><mailto:documentation%[email protected] >> <mailto:documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[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 >> >>>> >>> >> >>>>>> >> >>>> >>> >> >>>>>> >> >>>> >>> >> >>>>> >> >>>> >>> >> >>>> >> >>>> >>> >> >>> >> >>>> >>> >> >> >> >>>> >>> >> >> >> >>>> >>> >> >>-- To unsubscribe e-mail to: >> >>>> >>> >>[email protected] <mailto: >> documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[email protected]>> >> >>>> >>> >><mailto:documentation%[email protected] >> <mailto:documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[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 >> >>>> >>> >> > >> >>>> >>> >> >> >>>> >>> >> >> >>>> >>> >>-- >> >>>> >>> >>To unsubscribe e-mail to: >> >>>> >>> >>[email protected] <mailto: >> documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[email protected]>> >> >>>> >>> >><mailto:documentation%[email protected] >> <mailto:documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[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 >> >>>> >>> -- >> >>>> >>> To unsubscribe e-mail to: >> >>>> >>> [email protected] <mailto: >> documentation%[email protected]> >> >>>> >>> <mailto:documentation%[email protected] >> <mailto:documentation%[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 >> >>>> >> >>>>-- >> >>>>To unsubscribe e-mail to: >> [email protected] <mailto: >> documentation%[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 >> -- 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 >> >> >> -- >> 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 >> > -- 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
