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


Hi Felipe,

With regards to your second point, about the Tools > Options > LibreOffice Calc > General > Expand formatting option.

For background information, please note that Bug 94499 <https://bugs.documentfoundation.org/show_bug.cgi?id=94499> highlights a possible bug with this function. We should of course be aware of this bug but there's no need to mention it in the Guide.

With regards to understanding the issue that Celia would like addressed in the Calc Guide, try the following steps:

1. Enable the Expand formatting option on the Tools > Options >
   LibreOffice Calc > General dialog. (It should be unticked by default)
2. Create an empty sheet.
3. Enter something (e.g. the string "test") into the empty cell A1.
4. Set the formatting of cell A1 to something that is easily recognised
   visually (e.g. the Good cell style).
5. Enter something into the empty cell A2 and press enter. Cell A2
   should be displayed using the Good cell style.
6. Repeat previous step for cell B2.
7. Repeat as required by entering data in cells that are adjacent
   (either horizontally or vertically) to any of the cells that have
   already assumed the expanded format. (There are occasions when I've
   been able to expand to a diagonally adjacent cell but I'm not sure
   of the logic and so would ignore that "feature" for the moment).
8. When you do something in a non-adjacent cell, that stops the process
   of automatically applying the original cell's formatting.

It's that last step that probably should be mentioned in the Guide, and possibly the help as well (https://help.libreoffice.org/latest/en-GB/text/shared/optionen/01060300.html).

I hope that makes some sense, and helps you.

Regards,

Steve


On 11/04/2021 04:43, Felipe Viggiano wrote:
Hello everyone,


The following chapters of Calc Guide 7.1 are available for a first review:

CG7114 - SettingUpCustomizing

CG7115 - KeyboardShortcuts

CG7116 - CalcErrorCodes


About the Chapter 14, some observations about the requested changes:

    i. "/English guide mentions that logical values and dates are green when this////option is enabled, but it is not true. In fact, they are blue,////because they are numbers, internally. Only results from formulas are////green/"

_Observation:_ In my LO, the behavior was exactly as stated in the guide (logical and dates values were highlighted in green. Is this a OS difference?

    ii. "/There's a need to indicate that this “magic” stops for the range whenever the user does something else and returns back to range entry. SF opinion – the paragraph in the document is unclear; review needed to establish exactly     what the function does and then to make sure it //is documented clearly./"

_Observation:_ Here I couldn't figure out the issue, if somebody could give me some help on this would be great!


All those changes are noted in the Calc Status Guide.

Best regards,

Felipe Viggiano


Em 05/04/2021 23:51, Felipe Viggiano de Souza escreveu:
Em sábado, 3 de abril de 2021, às 16:10:22 -03, Felipe Viggiano de Souza escreveu:
Hello everyone,

Updates on Calc Guide 7.1:

CG-7112-CalcMacros was uploaded to the WIP folder and it is ready for
a first review.

The Calc Guide Status was updated.

Best regards,
Felipe Viggiano


Hello everyone,

Updates on Calc Guide 7.1:

CG-7111-SharingAndReviewing was uploaded to the WIP folder and it is ready for
a first review.

The Calc Guide Status was updated.

Best regards,


Em sábado, 3 de abril de 2021, às 09:55:18 -03, Felipe Viggiano de Souza
escreveu:
Hello everyone,

Updates on Calc Guide 7.1:

CG-7110-LinkingCalcData was uploaded to the WIP folder and it is ready for a
first review.

The Calc Guide Status was updated.

Best regards,
Felipe Viggiano


Em terça-feira, 30 de março de 2021, às 23:24:00 -03, Felipe Viggiano de
Souza
escreveu:
Hello everyone,

Updates on Calc Guide 7.1:

CG7109-DataAnalysis 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









--
To unsubscribe e-mail to: documentation+unsubscribe@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

Context


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.