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


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 <elderdanlewis@gmail.com <mailto:elderdanlewis@gmail.com>> 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" <felipeviggiano@gmail.com
    <mailto:felipeviggiano@gmail.com>>
    > To: "Steve (GMail)" <stevemfanning.wh@gmail.com
    <mailto:stevemfanning.wh@gmail.com>>
    > Cc: "Documentation Team" <Documentation@global.libreoffice.org
    <mailto:Documentation@global.libreoffice.org>>
    > 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)
    >> <stevemfanning.wh@gmail.com
    <mailto:stevemfanning.wh@gmail.com>> 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" <felipeviggiano@gmail.com
    <mailto:felipeviggiano@gmail.com>>
    >>> To: "Steve (GMail)" <stevemfanning.wh@gmail.com
    <mailto:stevemfanning.wh@gmail.com>>
    >>> Cc: "Documentation Team" <Documentation@global.libreoffice.org
    <mailto:Documentation@global.libreoffice.org>>
    >>> 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)
    >>> ><stevemfanning.wh@gmail.com
    <mailto:stevemfanning.wh@gmail.com>> 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)" <stevemfanning.wh@gmail.com
    <mailto:stevemfanning.wh@gmail.com>>
    >>> >> >>>>>>>To: "Documentation Team"
    >>> <Documentation@global.libreoffice.org
    <mailto:Documentation@global.libreoffice.org>>
    >>> >> >>>>>>>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:
    >>> >>documentation+unsubscribe@global.libreoffice.org
    <mailto:documentation%2Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@global.libreoffice.org>>
    >>> >><mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%252Bunsubscribe@global.libreoffice.org
    <mailto:documentation%25252Bunsubscribe@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
    >>> >> >>>>>>
    >>> >> >>>>>>
    >>> >> >>>>>
    >>> >> >>>>
    >>> >> >>>
    >>> >> >>
    >>> >> >>
    >>> >> >>-- To unsubscribe e-mail to:
    >>> >>documentation+unsubscribe@global.libreoffice.org
    <mailto:documentation%2Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@global.libreoffice.org>>
    >>> >><mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%252Bunsubscribe@global.libreoffice.org
    <mailto:documentation%25252Bunsubscribe@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
    >>> >> >
    >>> >>
    >>> >>
    >>> >>--
    >>> >>To unsubscribe e-mail to:
    >>> >>documentation+unsubscribe@global.libreoffice.org
    <mailto:documentation%2Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@global.libreoffice.org>>
    >>> >><mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%252Bunsubscribe@global.libreoffice.org
    <mailto:documentation%25252Bunsubscribe@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
    >>> --
    >>> To unsubscribe e-mail to:
    >>> documentation+unsubscribe@global.libreoffice.org
    <mailto:documentation%2Bunsubscribe@global.libreoffice.org>
    >>> <mailto:documentation%2Bunsubscribe@global.libreoffice.org
    <mailto:documentation%252Bunsubscribe@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

-- To unsubscribe e-mail to:
    documentation+unsubscribe@global.libreoffice.org
    <mailto:documentation%2Bunsubscribe@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


--
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.