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
