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: [email protected]
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
