Hello Steve,
Thank you very much for both explanations. I was doing some steps
differently and getting erroneous results. Now I can see the issues.
I'm updating the CG7114 right now.
Here's my suggestions:
*Expand formatting (p. 13)
*
"/...This feature will function only while you are inserting data in
adjacent cells with the previous formatting style, if you insert some
data in a non-adjacent cell the Expand formatting will no longer work.
In order to get it to function once more, you will need to format a cell
again (it could be the same one if you like) and insert data into its
adjacent cells./"
*Value highlighting (p. 15)
*
"/Select this option to highlight all values, or results of formulas, in
the sheet. Text is highlighted in black; numbers, dates and logical
values in blue, since they are all handled as number by Calc; formulas
are displayed in green. When this option is active, any colors assigned
in the document are not displayed./"
Once again, thank you very much!
Best regards,
Felipe Viggiano
Em 11/04/2021 06:51, Steve Fanning escreveu:
Hi Felipe,
With regards to the first point, about Calc's View > Value
Highlighting functionality, I have just experimented on my Windows 10
computer on which LibreOffice Community 7.1.1.2 (x64) is installed.
The behaviour I am witnessing matches that described on the relevant
Help page - see
https://help.libreoffice.org/latest/en-GB/text/scalc/01/03080000.html.
To be a bit more specific about my test, with value highlighting enabled:
1. I visited the Tools > Options > LibreOffice > Application Colors
dialog, scrolled down to the section containing Spreadsheet colors
and made sure that the "Values", "Formulas", and "Text" options were
set to Automatic. With this selection, the color setting options are
blue, green, and black respectively.
2. I typed the number 1 into an empty cell and it was displayed in blue
text.
3. I typed the formula =SUM(1+2) into an empty cell and the result 3
was displayed in green text.
4. I typed 2021-04-11 into an empty cell (today's date in ISO 8601
format) and it was displayed in blue text. (I would expect this
because Calc handles dates as numbers).
5. I typed TRUE into an empty cell (taking care to stop Calc from
converting this into a call to the TRUE() function!) and again it
was displayed in blue text. (I would expect this because Calc
handles logical values as numbers).
Did I do anything significantly different to 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
