Calc Guide v7.0

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

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

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

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

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

Hello everyone,

Just uploaded a first review of the CG7010 - LinkingData on the Feedback
folder.

I would like to raise some questions about a few issues in the chapter and
would love to read some comments from the members of the team:

1. The *Note* on page 24 says that the Status column on the Edit links
dialog aways shows the string Manual for a link created and does not
reflect the "*Update every ... seconds*" option on the External Data
dialog.

*Is there a reason for this?*

2. The Control Properties dialog, referred in page 19 (Editing Hyperlinks)
does not hold the regulars *OK* and *Cancel *buttons.

*Again, is there any reason for this? *

The reason I pointed this out here is that I'm thinking about reporting
those issues in Bugzilla and I'm not sure that it is wrong or it supposes
to be exactly like this.

PS: The Calc Guide Status has been updated.

Best regards,
Felipe Viggiano

Hello everyone,

Just uploaded the first review on the CG7011-Sharing and Reviewing on the
Feedback Folder.

The Calc Status Guide has been updated.

Best regards,
Felipe Viggiano