Recently I have bought new tower computer and have dual booted Windows
10 and buntu20.04. This afternoon, I downloaded 7.0.1.1 for windows
(Dated 14 August 2020)and installed it. When I ran Calc, I entered 1-10
in column A in rows 1-10. In B1 I entered this formula: ATAN(A1). Then I
drug this formula down to B10. Then I pressed "Ctrl+`". Cell B1-B10
changed from the arc tangent values to the formulas. So, this is not a
bug for the pre-releases that I use. I will update the bug a little
later today.
Dan
On 8/26/20 14:56, Felipe Viggiano wrote:
Hello Dan,
Apparently it's something with the release version. I did the report
on Bugzilla
(https://bugs.documentfoundation.org/show_bug.cgi?id=136129) and this
was confirmed by another user, with the 7.1.0.0.alpha0+ version.
In my case, I have installed the 7.0.0.3 version on Ubuntu (20.04 as
well).
Best regards,
Felipe Viggiano
Em qua., 26 de ago. de 2020 às 12:22, Dan Lewis
<[email protected] <mailto:[email protected]>> escreveu:
I use Ubuntu 20.04 and 7.0.1.1 (pre-release) from the LibreOffice
website. "Ctrl+`" works just like View > Show Formula. Now there
might
be a problem with Ubuntu's release of LibreOffice...
Dan
On 8/25/20 13:56, Steve (GMail) wrote:
> Hi Felipe,
>
> I am a little concerned about the failure of the View > Show
Formula
> shortcut on your system. I have seen this shortcut work on an
Ubuntu
> installation (albeit using LO 6.4) running in a Virtual Terminal in
> VMware. If there's a problem with the Linux implementation in this
> respect, we'll need to update Appendix A as well.
>
> Does the menu option contain the string "Ctrl+`" in your
> installation? It is simply that the shortcut doesn't work? Are
we in
> "bug" territory again?
>
> Regards,
>
> Steve
>
>
> ------ Original Message ------
> From: "Felipe Viggiano" <[email protected]
<mailto:[email protected]>>
> To: "Steve (GMail)" <[email protected]
<mailto:[email protected]>>
> Cc: "Documentation Team" <[email protected]
<mailto:[email protected]>>
> Sent: 25/08/2020 02:49:35
> Subject: Re: Re[9]: [libreoffice-documentation] Re[2]: Calc
Guide v7.0
>
>> Hello Steve,
>>
>> Thanks for the feedback!
>>
>> About the shortcut, I"m currently using Linux (Ubuntu), but it
could
>> be a distribution difference. May I suggest something like this:
>>
>> Formulas can be toggled on / off in the menu option View > Show
>> Formula, and, depending on the operational system, by the shortcut
>> Ctrl+` (grave accent).
>>
>> About the multi-threading, I can understand that this could be
useful
>> information for advanced users.
>>
>> Best regards,
>> Felipe Viggiano
>>
>> Em seg., 24 de ago. de 2020 às 15:53, Steve (GMail)
>> <[email protected]
<mailto:[email protected]>> escreveu:
>>> Hi Felipe,
>>>
>>> Many thanks for the comments on Chapter 7 (Using Formulas and
>>> Functions). I have actioned most of the points you raised, and the
>>> document is now in the Draft for second review.
>>>
>>> A few matters arising:
>>> In the section entitled “Compatibility with other spreadsheet
>>> applications”, I’ve amended the number of functions that are
unique to
>>> Calc. It now reads 30, to match the functions listed on the
referenced
>>> wiki page, rather than the total number stated on that page!
>>> With regards to your comment that the keyboard shortcut
associated with
>>> View > Show Formula does not work for you. I believe that the
shortcut
>>> works on Windows and Linux, but I do not think there is a
corresponding
>>> key sequence for macOS. This is already reflected in Appendix
A and I
>>> have updated the Tip after Figure 19 to clarify further.
>>> In the section entitled “Multi-threading”, I decided to retain
the last
>>> paragraph. I think it is quite legitimate to draw a reader’s
attention
>>> to there being other ways (for power users) to control
multi-threading,
>>> even though they are not described in the guide.
>>>
>>> Thanks again.
>>>
>>> Regards,
>>>
>>> Steve
>>>
>>>
>>>
>>> ------ Original Message ------
>>> From: "Felipe Viggiano" <[email protected]
<mailto:[email protected]>>
>>> To: "Steve (GMail)" <[email protected]
<mailto:[email protected]>>
>>> Cc: "Documentation Team" <[email protected]
<mailto:[email protected]>>
>>> Sent: 22/08/2020 02:14:18
>>> Subject: Re: Re[7]: [libreoffice-documentation] Re[2]: Calc
Guide v7.0
>>>
>>> >Hello everyone,
>>> >
>>> >Steve,
>>> >
>>> >Just uploaded a first review on the CG7007 - FormulasAndFunction.
>>> >
>>> >Only a few minor suggestions. The chapter is very well
written and I
>>> >managed to reproduce and understand every step and orientation.
>>> >
>>> >I'm checking out the CG7008 - Pivot Tables for a first
review. Expect
>>> >to return it by Thursday (27Ago2020).
>>> >
>>> >The Calc Status Guide has been updated.
>>> >
>>> >Best regards,
>>> >Felipe Viggiano
>>> >
>>> >
>>> >Em qui., 20 de ago. de 2020 às 15:48, Steve (GMail)
>>> ><[email protected]
<mailto:[email protected]>> escreveu:
>>> >>All,
>>> >>
>>> >>I have finished updating Appendices A (Keyboard Shortcuts) and B
>>> >>(Error
>>> >>Codes), and placed the files in the Draft folder ready for first
>>> >>review.
>>> >>
>>> >>As with earlier chapters, please do not waste time reviewing
the
>>> front
>>> >>matter or the template used for these chapters (other than
adding
>>> your
>>> >>name to the list of contributors of course!)
>>> >>
>>> >>Regards,
>>> >>
>>> >>Steve
>>> >>
>>> >> >>>>>>
>>> >> >>>>>>>
>>> >> >>>>>>>------ Original Message ------
>>> >> >>>>>>>From: "Steve (GMail)" <[email protected]
<mailto:[email protected]>>
>>> >> >>>>>>>To: "Documentation Team"
>>> <[email protected]
<mailto:[email protected]>>
>>> >> >>>>>>>Sent: 23/07/2020 20:28:44
>>> >> >>>>>>>Subject: Calc Guide v7.0
>>> >> >>>>>>>
>>> >> >>>>>>>>Hi All,
>>> >> >>>>>>>>
>>> >> >>>>>>>>I have started a detailed read through the chapters of
>>> the 6.4
>>> >>Calc
>>> >> >>>>>>>>Guide to identify the changes needed for 7.0.
>>> >> >>>>>>>>
>>> >> >>>>>>>>The first two chapters (0 - Preface and 1 -
Introduction)
>>> have
>>> >>been
>>> >> >>>>>>>>updated and placed in the appropriate Draft folder
within
>>> >>NextCloud.
>>> >> >>>>>>>>Please could somebody find time to perform a first
review of
>>> >>these
>>> >> >>>>>>>>chapters?
>>> >> >>>>>>>>
>>> >> >>>>>>>>Echoing Peter Schofield's comments in relation to the
>>> Impress
>>> >>Guide,
>>> >> >>>>>>>>please do not waste time reviewing the front matter
or the
>>> >>template
>>> >> >>>>>>>>used for these chapters (other than adding your
name to the
>>> >>list of
>>> >> >>>>>>>>contributors of course!). I will sort out these
aspect prior
>>> >>to
>>> >> >>>>>>>>publication, once the 7.0 template is finalised.
>>> >> >>>>>>>>
>>> >> >>>>>>>>Regards and thanks,
>>> >> >>>>>>>>
>>> >> >>>>>>>>Steve Fanning
>>> >> >>>>>>>>
>>> >> >>>>>>--
>>> >> >>>>>>To unsubscribe e-mail to:
>>> >>[email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[email protected]>>
>>> >><mailto:documentation%[email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[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
>>> >> >>>>>>
>>> >> >>>>>>
>>> >> >>>>>
>>> >> >>>>
>>> >> >>>
>>> >> >>
>>> >> >>
>>> >> >>-- To unsubscribe e-mail to:
>>> >>[email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[email protected]>>
>>> >><mailto:documentation%[email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[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
>>> >> >
>>> >>
>>> >>
>>> >>--
>>> >>To unsubscribe e-mail to:
>>> >>[email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[email protected]>>
>>> >><mailto:documentation%[email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[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
>>> --
>>> To unsubscribe e-mail to:
>>> [email protected]
<mailto:documentation%[email protected]>
>>> <mailto:documentation%[email protected]
<mailto:documentation%[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
--
To unsubscribe e-mail to:
[email protected]
<mailto:documentation%[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
--
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
