Calc Guide v7.0

Hi Annie,

Thanks for that. I'm buried in the lengthy Chapter 9 at the moment so it might be a day or two before I review your comments.

In the meantime I have consulted with Olivier and we have decided that, for the moment, we will not mention the (non-working) Send to Bluetooth option in the 7.0 Calc Guide.

Regards,

Steve

All,

I have finished updating Chapter 9, Data Analysis, 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

Thanks Annie.

I have been through all comments and the updated file is back in the Draft folder, ready for second review.

Regards,

Steve

All,

I have finished updating Chapter 10, Linking Data, 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

All,

I have finished updating Chapter 11, Sharing and Reviewing Spreadsheets, 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

All,

I have finished updating Chapter 12, Calc Macros, 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

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

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

All,

I have finished updating Chapter 13, Calc as a Simple Database, 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

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

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

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

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

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

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

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

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

Hello Dan,

Thanks for updating the bug.
I did a few actions suggested by a developer and the issue were still
present.
Apparently, now they have assigned the bug to someone.

Best regards,
Felipe Viggiano

All,

Following discussion at yesterday's team meeting, I have changed the title of this chapter to remove the word "Simple". I have also modified some of the text in the chapter to try to remove any sense that Calc's limited facilities somehow mean that Base is not needed!

The updated file is in the Draft folder ready for first review.

Regards,

Steve

Hi Felipe,

Many thanks for another thorough and helpful review. The chapter is back in the Draft folder for second review.

Two matters arising:
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).
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