Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

Hi Felipe,

The following comments have arisen from my high-level (skim) review of the full PDF:

1. General. Did we take a conscious decision in the LO 7 template to
   show the text “Calc Guide 7.0” in the footers of even numbered
   pages? (This wasn’t the case in the 6.4 CG)
2. General. There are some cases where figures could be moved around to
   reduce the amount of white space at the bottom of pages. However,
   there is always a trade off between minimising white space and
   retaining a figure in a reasonably logical/natural position relative
   to its associated text.
3. Page 57. The two steps directly above Figure 34 should probably be
   numbered 4) and 5) rather than 1) and 2).
4. Page 209, Figure 178. When we took the screen grab of this dialog,
   we unintentionally had an irrelevant tooltip displayed which causes
   unnecessary distraction. Could we replace this figure with a similar
   screen grab but without the tooltip?
5. Page 218, Figure 188. The caption is present, but the figure is not
6. On paging through Chapter 6 (in Adode Acrobat Reader DC on my
   Windows 10 computer), I received the following Acrobat Reader error
   message: “Cannot extract the embedded font
   ‘BAAAAA+LiberationSans-Bold’. Some characters may not display or
   print correctly.” It is possibly a problem only with my computer
   configuration but it may be worth checking that others don’t get
   such a message.
7. Page 225, just after Figure 195. The numbered items in the section
   below this figure should be reset to start from 1.
8. Page 266, Table 11. Recommend widening the first column so that the
   column heading remains on one line.
9. Page 444, section heading “Working with VBA Macros”. For consistency
   with other sections, I don’t think the word “Macros” needs an
   initial upper case letter in this section heading.
10. Page 444, section “Working with VBA Macros”, 1st paragraph. I’m not
   sure repetition of the word “Basic” is needed before “programming
   language”. Also, change “a different mechanisms” to either
   “different mechanisms” or “a different mechanism”.
11. Page 444, section “Working with VBA Macros”, 2nd paragraph. Delete
   “a” from before “VBA”?
12. Page 444, section heading “Loading VBA Code”. For consistency with
   other sections, I don’t think the word “Code” needs an initial upper
   case letter in this section heading.
13. Page 444, section “Loading VBA Code”, 1st paragraph. Change “Option”
   to “Options”.
14. Page 445, paragraph immediately after Figure 451. Suggest changing
   “Microsoft Basic” to “VBA”. Also recommend making the same change in
   the following paragraph.
15. Page 445, “Option VBA Support statement” section. In this section,
   we sometimes have a space between “VBA” and “Support” but sometimes
   not. Consistency would be better.
16. Page 445, paragraph immediately before Listing 13. I think the word
   “functions” is redundant after “VBA” and could be deleted. Also, in
   the 2nd sentence, suggest changing “of” to “from”.
17. Page 445, 1st bullet point after Listing 14. Change “letter” to
   either “a letter” or “letters”.
18. Page 446, paragraph directly above Listing 15. The first sentence is
   not grammatically correct. Does the following read better -
   “UserForms (Dialogs) appear frequently in macros that demand your
   interaction and parameter selections.”?
19. Page 446, Note after Listing 16. Do the two occurrences of the word
   “Dialog” require initial upper case letters?
20. Page 446, 1st paragraph of Conclusion section. “Macros” does not
   need an initial upper case letter. Also, it may be worth inserting
   “Basic” after “LibreOffice”.
21. Chapters 12 and 13. A few figure captions within these sections are
   centred, which is inconsistent with the majority of figure captions
   in the document.
22. Chapter 14, section entitled VBA Properties, beginning on page 481.
   This section repeats material now covered in Chapter 12 (Macros). Do
   we want to retain this repetition or could we cross-reference here
23. Page 511 at the beginning of Appendix A has the wrong footer.
24. In Appendix A, the footers of odd numbered pages include the text
   “Calc Guide 7.0” which is inconsistent with the remainder of the
25. In the alphabetical index at the back of the document, footers on
   odd numbered pages use text from a section of the previous appendix.
   This looks a little odd.
26. Do we need an entry or entries in the alphabetical index to refer to
   the new VBA-related material in the Chapter 12 (Macros)?



On 06/11/2020 00:05, Felipe Viggiano wrote:
Hello everyone,

I appreciate very much the thanks! But what I'm doing is just a small part
of great work from everyone involved!

Of course I can wait!. The more feedbacks on the guide before publishing
the better!
About the links, apparently, the "Figures" links are OK and the "Pages"
ones are the issue. As I could observe here, they are leading to where they
are supposed to, but the exhibited numbers are incorrect.
Example: On page 22, the link mentioned is taking the user to the correct
section - Using the navigator (which is in fact on page 39), however, it
wrongfully shows the number 41.
I'm starting to work on that issue right now.

As soon as I can fix every issue pointed I will surely let you know.

One question to the group:
I'm using the Published folder for the files, should I move to the Draft
folder and put back on Published only after finishing?

Best regards,
Felipe Viggiano

Em qui., 5 de nov. de 2020 às 16:43, Dave Barton <>

Hi Martin,

This was "briefly" discussed at today's Docs meeting.

"Briefly", because some recent attempts to use the odtclean script have
failed and it was agreed that Oliver will contact Milos about this issue.

Be assured we (The Docs Team) always take into account that the guides
must be made available in a translatable format. However, you must  also
understand that the Calc Guide is currently still "work in progress" and
has not yet reached it's fully "Published" state.

Best Regards

On 05/11/2020 19:14, Martin Srebotnjak wrote:

could this guide's chapters - as well as other guides' chapters upon
finished - be cleaned with the odtclean script my Milos to remove
formatting code and help l10n teams?

I suggest this becoming a part of the official procedure, as documented
the guide for writing guides (Producing LO Guides): I suggest adding a
point/step in the "Publishing Chapters" subchapter (between points 7 and
Lp, m.

V V čet., 5. nov. 2020 ob 05:38 je oseba Felipe Viggiano <> napisala:

Hello everyone,

Just uploaded the newest version of the Calc 7.0 Guide on the Published
All the chapters and the compiled version were updated with Jeans's
comments and some more corrections.

I'm planning to upload the .pdf files from each chapter by tomorrow.

Best regards,
Felipe Viggiano

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.