Re: [libreoffice-documentation] What is data hierarchy in pivot table data field options?
I have amended the Help page with a note on the subject. Em 21/08/2020 11:12, Steve (GMail) escreveu: > Kohei, > > Many thanks for that insight. > > In terms of the Calc Guide, I'm not keen to fully explain a feature that > doesn't exist without using an extension! Would you be happy with the > following note? > "For the majority of users, Calc does not provide multiple hierarchies > for a single field and so this option is normally grayed. If you use a > pivot table data source extension, that extension could define multiple > hierarchies for some fields and then the option could become available. > See the documentation supplied with that extension for more details". > > Regards, > > Steve > > > -- Original Message -- > From: "Kohei Yoshida" > To: "Steve (GMail)" > Cc: "Documentation Team" ; > "LibreOffice Developers" > Sent: 21/08/2020 14:33:56 > Subject: Re: [libreoffice-documentation] What is data hierarchy in pivot > table data field options? > >> Hi Steve and Celia, >> >> On 21.08.2020 05:31, Steve (GMail) wrote: >> >>> Just for information, anything you attach to your email will be >>> stripped off again by this mailing list; we can't see your screenshot. >> >> >> I'm assuming we are talking about the dialog that is described here? >> >> https://help.libreoffice.org/7.0/en-US/text/scalc/01/12090106.html >> >>> >>> Nevertheless I fully understand your question. Unfortunately I do not >>> recall ever seeing the Hierarchy drop-down on the Data Field Options >>> dialog in any state other than grayed. I don't know what circumstances >>> might lead to it becoming available - maybe one of the developers >>> could have a look at the code to see? (email copied to Developers >>> mailing list) >> >> I provided my own explanation below. >> What is data hierarchy in pivot tables? >> >> Data hierarchy in a pivot table is an additional layer of grouping >> applied to the source values of a field. I will explain this concept >> as follows. >> >> First, when you initially create a pivot table with source data within >> your Calc document, the table output is created with however many >> fields you may have in the source data. Let's say you have the >> following field values: >> >> Field1 >> 1 >> 2 >> 3 >> 4 >> 5 >> 6 >> 7 >> 8 >> 9 >> 10 >> >> then the pivot table will create a field for this Field1, initially >> with no hierarchy i.e. the raw values will get shown. >> >> You can assign grouping to this field, by moving the cell cursor to >> where this field data is displayed within pivot table, and either >> press F12, or select Data -> Group and Outline -> Group from the >> menu. For this set of values, you can only create a numeric range >> group, to group the values in some specific intervals. If you have a >> set of date values, you can also apply date-based grouping i.e. years, >> quarter, months, days, and so on. >> >> This grouping is what is referred to as hierarchy. The two are >> interchangeable, but in the source code, this is referred to as >> hierarchy pretty much exclusively. >> >> Under normal circumstances, each field can have only one hierarchy, or >> none at all, as far as I know. Someone please correct me please if >> this is not accurate, but I'm certain this is the case. >> This is a question for concept: What is a data hierarchy in this option dialog? And more, when/how do I use it? >> >> As Steve said, this option is always grayed, because it will get >> active only when the field has more than one hierarchies, which, as I >> said above, almost never happens under normal circumstances. >> >> Having said this, here is a scenario where that option may become >> active, but it needs a bit of an explanation. >> >> Calc's pivot table implementation is split into two parts. You can >> refer to them as the front end and back end portions. Some people may >> hate these terms, but I don't care. The back-end part takes care of >> defining the structure of the source data, in terms of fields (or >> dimensions as they are referred to in the code) and the structure of >> each field. Each field consists of three layers - first layer is >> hierarchies, the second layer is levels, and the last layer is >> members. A hierarchy is the type of grouping applied (i.e. value >> range, years, quarters etc), a level is a specific bucket within the >> defined hierarchy i.e. range 1-4, year 1980, month of August etc. A >> member is an original value. >> >> The front-end part receives this structure provided by the back-end, >> and displays it in sheets, or recently in charts, and/or provides >> various dialogs for tweaking the parameters. >> >> The back-end part is implemented as a UNO component, and in theory it >> can be swapped with one implemented by an extension. But when your >> data source is Calc's own sheet, you are using Calc's own back-end >> implementation, and this one does not allow multiple hierarchies in a >> field. This is why that hierarchy option is a
Re: [libreoffice-documentation] Re[2]: Calc Guide v7.0
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" To: "Steve (GMail)" Cc: "Documentation Team" 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) 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" To: "Steve (GMail)" Cc: "Documentation Team" 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) > 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)" >> >>>To: "Documentation Team" >> >>>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
[libreoffice-documentation] Chart Data Labels, text label displayed with "Show category"
There was a bug report about displaying data labels, which are pulled from a cell range: https://bugs.documentfoundation.org/show_bug.cgi?id=132280 It appears to me that the passages in Help and Calc Guide might benefit from more elaboration on this topic. Just thought I would throw this out here immediately for feedback. I can do a patch for Help, if someone comes up with a proposal. Ilmari -- 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] Re[2]: Calc Guide v7.0
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 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" > > To: "Steve (GMail)" > > Cc: "Documentation Team" > > 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) > >> 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" > >>> To: "Steve (GMail)" > >>> Cc: "Documentation Team" > >>> 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) > >>> > 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)" > >>> >> >>>To: "Documentation Team" > >>> > >>> >> >>>Sent: 23/07/2020 20:28:44 > >>> >> >>>Subject: Calc Guide v7.0 > >>> >> >>> > >>> >> Hi All, > >>> >> > >>>
Re[7]: [libreoffice-documentation] Re[2]: Calc Guide v7.0
All, I have finished updating Chapter 14, Setting up and Customizing, and placed the file 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 this chapter (other than adding your name to the list of contributors of course!) Regards, Steve -- Original Message -- From: "Steve (GMail)" To: "Documentation Team" Sent: 23/08/2020 14:23:00 Subject: Re[6]: [libreoffice-documentation] Re[2]: Calc Guide v7.0 -- Original Message -- From: "Steve (GMail)" To: "Documentation Team" 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 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
Re: [libreoffice-documentation] Chart Data Labels, text label displayed with "Show category"
Thanks Ilmari. As you are aware, the Calc Guide is currently being updated for LO7. I'll revisit Chapter 3 (Creating Charts and Graphs) to include some clarification. Regards, Steve -- Original Message -- From: "Ilmari Lauhakangas" To: "LibreOffice Documentation" Sent: 26/08/2020 18:40:58 Subject: [libreoffice-documentation] Chart Data Labels, text label displayed with "Show category" There was a bug report about displaying data labels, which are pulled from a cell range: https://bugs.documentfoundation.org/show_bug.cgi?id=132280 It appears to me that the passages in Help and Calc Guide might benefit from more elaboration on this topic. Just thought I would throw this out here immediately for feedback. I can do a patch for Help, if someone comes up with a proposal. Ilmari -- 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
Re: [libreoffice-documentation] Re[2]: Calc Guide v7.0
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 mailto: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" mailto:felipeviggi...@gmail.com>> > To: "Steve (GMail)" mailto:stevemfanning...@gmail.com>> > Cc: "Documentation Team" mailto: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) >> mailto: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" mailto:felipeviggi...@gmail.com>> >>> To: "Steve (GMail)" mailto:stevemfanning...@gmail.com>> >>> Cc: "Documentation Team" mailto: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