Calc Guide 7.1

Hello everyone,

How are we on the LO 7.1 Guides?

I am thinking of starting to work on the Calc Guide 7.1, just checked out
the CG-7001, expect to return by 26-feb.

Best regards,
Felipe Viggiano

Hi Felipe,

I hope that you are well.

Regarding a 7.1 Calc Guide, great news that you are starting on it. Let me know how I can assist you.

I have recently created a folder structure in NextCloud and drafted a major upgrade to Chapter 13 (Calc as a Database) to remove the macros and (hopefully) improve the description of the 12 Database functions. This was discussed at various Documentation Team meetings.

Regards,

Steve

Hey Steve!

Everything is fine! Have been away due to lack of time, but now I believe I
can come back for a while.

I just went through the Calc Guide 7.1 folder and saw that you also
prepared a file with the changes needed for the Guide, that is excellent!
In the readme.md file, there is a reminder to the reviewers to take a look
at this file before starting to work on the chapter!

Keep around, your assistance is much appreciated!

Best regards,
Felipe Viggiano

Hello Team,

In the Calc Guide 7.0 Preface, there is a note on page 5, saying:

*The What’s This? facility and extended tips are being improved but in

LibreOffice 7.0 this work is incomplete and so they are not fully
functional.*

And the LibreOffice 7.1 Community: Release Notes report this feature:

*Reactivated extended tips in dialogs*

It's safe to say that the work is done and the mentioned Note can be
deleted?

Best regards,
Felipe Viggiano

Hi Felipe,

Olivier has done a lot of work with the extended tips through Bug 118148. You can now view some extended tips if you enable the configuration option and know where to hover your mouse pointer. (There are clues in the Bug about where to hover!)

As for the "What's This" facility, I'm not sure of its status; I have not witnessed it doing anything useful. Maybe Olivier can comment?

I would certainly remove the note about the extended tips not being fully functional.

Regards,

Steve

Hi
Yes I copied the extended tips from the Help to the dialogs for 7.1 (the
<ahelp> tags in Help when applied to dialogs only).

The "?" button in dialogs is not working (it may depend on the windows
manager of the operating system).

Olivier

Olivier and Steve,
Thanks for the help!

Team,
I have uploaded the CG7100-Preface on the WIP folder and it is ready for a
first review.
Just checked out the CG-7101-Introduction, expect to return it by Friday
(26feb).

A few notes:
i. Do we need to refer to LibreOffice as LibreOffice Community all the
times?
ii. LO 7.0 Calc Guide's Preface says that LO is available in over 40
languages (Page 9), but the wiki page says 115 (
https://en.wikipedia.org/wiki/LibreOffice), and I have counted 119 in the
LO Download page (
https://www.libreoffice.org/download/download/?type=rpm-x86_64&version=7.1.0&lang=pick).
The reason Iḿ pointing this out is because the prefaces from others guides
(Writer, Impress...) might display the same message.

Best regards,
Felipe Viggiano

Hi Felipe,

With regards to your query on the number of languages stated on page 9 of the 7.0 Calc Guide.

My opinion is that we should update this statement in the next issue. However, I'm not sure the exact number really matters in the context of the Calc Guide Preface and I'd prefer that we didn't have to update that number at every issue of the guide. Could we just say that there are "over 100"?

Maybe also look at the next sentence in the Preface which states "Additionally, there are over 70 spelling, hyphenation, and thesaurus dictionaries available for languages, and dialects that do not have a localized program interface." There seem to be 109 entries in  the Extension Center with a Dictionary tag at the moment. Again, maybe update to "over 100"?

Regards,

Steve

Hello team,

Steve,
Just did as you said, changed the both information to over 100 hundred.

Everyone,
The Calc Guide 7101 - Introduction was uploaded to the WIP folder and it is
ready for a first review.
By next week I expect to deliver the next chapter.
All these changes are on the Calc Guide Status file.

Best regards,
Felipe Viggiano

Hello everyone,

Chapter CG7102-Enter, Edit, and Format Data is ready for review on the WIP
folder.

Best regards and a great week!
Felipe Viggiano

Hello everyone,

Chapter CG7103-Charts and Graphs is ready for review on the WIP folder.

Best regards,
Felipe Viggiano

Hello everyone,

Chapter CG7104-Styles and Templates is ready for review on the WIP folder.

Best regards,
Felipe Viggiano

Hello everyone,

CG7105-UsingGraphics was uploaded to the WIP folder and it is ready for a
first review.

The Calc Guide Status has been updated.

Best regards,
Felipe Viggiano

Hello everyone,

CG7106-PrintExportEmailSign was uploaded to the WIP folder and it is ready
for a first review.

The Calc Guide Status has been updated.

Best regards,
Felipe Viggiano

Hello everyone,

CG7107-FormulasAndFunctions was uploaded to the WIP folder and it is ready
for a first review.

The Calc Guide Status has been updated.

Best regards,
Felipe Viggiano

Hello everyone,

Updates on Calc Guide 7.1:

CG7105-UsingGraphics was reviewed and uploaded to the WIP folder, ready for
a second review.
CG7108-PivotTables was uploaded to the WIP folder and it is ready for a
first review.

The Calc Guide Status is updated with these changes.

Best regards,
Felipe Viggiano