Installing Open Office
FedoraForum.org - Fedora Support Forums and Community
Results 1 to 15 of 15
  1. #1
    Join Date
    Oct 2007
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Installing Open Office

    I have Open Office installed on a Windows PC and found a link to install in F30. Followed instructions but the process said it conflicted with LibreOffice so I couldn't install. How do I remove LibreOffice? I like OpenOffice, LibreOffice is OK but not easy to use Libre calc. I suppose I should remove OpenOffice and start again. Any help would be appreciated. I suppose the easiest way is to do a netinstall and not include LibreOffice.
    Last edited by anglicus; 9th June 2019 at 04:04 PM.

  2. #2
    PabloTwo's Avatar
    PabloTwo is offline "Registered User" T-Shirt Winner
    Join Date
    Mar 2007
    Location
    Seville, FL
    Posts
    7,952
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    How do I remove LibreOffice?
    Well, you could use whatever gui package manager you have to remove any installed LibreOffice packages, or you could use a command terminal. From command terminal, to determine which LibreOffice packages you currently have installed,
    Code:
    $ rpm -qa | grep libreoffice
    Then you could use dnf to uninstall each package in the resulting list.
    Code:
    # dnf erase package1 package2 package3.....etc
    Or probably a more simple,
    Code:
    # dnf erase libreoffice\*
    Take careful note of what will be removed and if it wants to remove too many other non-libreoffice packages that look like it might break other things, then reply "n" to the "Is this OK" prompt.

  3. #3
    Join Date
    Mar 2019
    Location
    Pathum Thani, THAILAND
    Posts
    80
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Quote Originally Posted by anglicus
    .
    .
    LibreOffice is OK but not easy to use Libre calc.
    .
    .
    Sorry for cutting in, can you please give me some of your pain points in brief that LO Calc is not as good as OO Calc ?
    Last edited by fdrnkfdrnk; 10th June 2019 at 01:23 AM.

  4. #4
    Join Date
    Oct 2007
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Thanks for replies. After a lot of coffee and head scratching, finally cracked it. Librecalc makes it difficult when adding columns etc. OpenOffice just needs =(sum.....) similar to Excel.

  5. #5
    Join Date
    Feb 2005
    Location
    London, UK
    Posts
    1,020
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Quote Originally Posted by anglicus
    Librecalc makes it difficult when adding columns etc. OpenOffice just needs =(sum.....) similar to Excel.
    Libre calc also supports "=sum(A1:A3)" etc.

  6. #6
    Join Date
    Jun 2005
    Location
    Montreal, Que, Canada
    Posts
    6,019
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    If you still have problems, install wps (wps.com). This software is as close to MS Office as any.
    Leslie in Montreal

    Interesting web sites list
    http://forums.fedoraforum.org/showth...40#post1697840

  7. #7
    Join Date
    Feb 2005
    Location
    London, UK
    Posts
    1,020
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Quote Originally Posted by lsatenstein
    If you still have problems, install wps (wps.com). This software is as close to MS Office as any.
    One thing I really wish Open/Libre/Star or any of the other free and open source Offices did better was MS compatibility. I know it's not their fault and how MS got their "open" standards accepted as the standard is beyond me. However, using Linux on the desktop at work can be a bit of a complete pain when a word document I'm sharing with someone else has a completely different format in Libre/Open office. Sadly I don't think WPS would work for me either unless I pay for the subscription, no pivot tables etc? ugh. I end up using MS Office over Citrix if I need consistency which is less than ideal.

  8. #8
    Join Date
    Oct 2007
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    If you use Chrome you can install Office 365 live, outlook account needed. Linux distro Peppermint has it included, c'mon Fedora.

  9. #9
    Join Date
    Jun 2005
    Location
    Montreal, Que, Canada
    Posts
    6,019
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    I write spreadsheets in LO and have saved and reloaded them in MS EXCEL, and without issues. Save spreadsheets in the older format that Excel used
    Leslie in Montreal

    Interesting web sites list
    http://forums.fedoraforum.org/showth...40#post1697840

  10. #10
    Join Date
    Mar 2019
    Location
    Pathum Thani, THAILAND
    Posts
    80
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Quote Originally Posted by anglicus
    .
    OpenOffice just needs =(sum.....) similar to Excel.
    .
    Can you please show your screenshot of such sum calcualtion in OO Calc ?

    In LO Calc :
    Use keyboard to enter "=sum" and enter, it will give ..................... =sum()
    Then use mouse to drag for a range of cells and enter again ....... =sum(A1:K6)
    But in MS Office, there is the menu ion of summation for it is used most often.
    I have to find that in LO Calc.

  11. #11
    Join Date
    Feb 2009
    Location
    Florida
    Posts
    668
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Here's my attempt...

    Notiice the sumation character on the third tool bar.
    Click image for larger version. 

Name:	Screenshot from 2019-06-12 00-08-45.png 
Views:	11 
Size:	58.1 KB 
ID:	30411

    When you press the summation icon you get.
    Click image for larger version. 

Name:	Screenshot from 2019-06-12 00-08-11.png 
Views:	7 
Size:	62.1 KB 
ID:	30412

    You will also note I added a summation icon in the first position of the first toolbar by using Tools> Customize and selecting the toolbars tab. Then move items of your choice to the toolbar.
    Last edited by Kobuck; 12th June 2019 at 05:20 AM.
    Laptop: Toshiba / Intel B960 2.20Ghz x2/ 4GB/ 320GB SataII/ Intel HD/ fc30.x86_64
    Tower: GigaByte (970A) / AMD FX 8320 3.5Ghz x8/ 16GB/ 9TB Sata III/ AMD 6770HD/ fc30.x86_64
    Bookshelf: Shuttle DS61 (H61)/ i3-3225 3.3Ghz x2/ 16GB/ 320GB Sata II/ Intel HD 4000/ fc29.x86_64
    Embedded: BeagleBone Blk / ARM AM3358 1 GHz x1/ 512MB/ 2GB eMMC/ PowerVR SGX530/ fc27.armv7hl

  12. #12
    Join Date
    Mar 2019
    Location
    Pathum Thani, THAILAND
    Posts
    80
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Quote Originally Posted by Kobuck
    .
    Tools> Customize and selecting the toolbars tab.
    .
    I overlooked the summation icon, it is next to cell content box.

    From your examples:
    MS Excel, we only double left click on it for the result.
    But in LO Calc, we have to left click on it and left click on the Enter icon again.

    Thank you so much for your information.
    And I'm waiting for the screenshot of OO Calc from anglicus.
    Last edited by fdrnkfdrnk; 12th June 2019 at 12:24 PM.

  13. #13
    Join Date
    Feb 2009
    Location
    Florida
    Posts
    668
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    Quote Originally Posted by fdrnkfdrnk
    From your examples:
    MS Excel, we only double left click on it for the result.
    But in LO Calc, we have to left click on it and left click on the Enter icon again.
    Not sure what we are trying to resolve here ......??

    In my example, there is no difference between the behavior of the summation icon between LO Calc and MS Excel.
    Left click summation icon <enter>

    LibreOffice Calc Version: 6.2.4.2.0+
    Office 365 Excel Version 1905
    Laptop: Toshiba / Intel B960 2.20Ghz x2/ 4GB/ 320GB SataII/ Intel HD/ fc30.x86_64
    Tower: GigaByte (970A) / AMD FX 8320 3.5Ghz x8/ 16GB/ 9TB Sata III/ AMD 6770HD/ fc30.x86_64
    Bookshelf: Shuttle DS61 (H61)/ i3-3225 3.3Ghz x2/ 16GB/ 320GB Sata II/ Intel HD 4000/ fc29.x86_64
    Embedded: BeagleBone Blk / ARM AM3358 1 GHz x1/ 512MB/ 2GB eMMC/ PowerVR SGX530/ fc27.armv7hl

  14. #14
    Join Date
    Mar 2019
    Location
    Pathum Thani, THAILAND
    Posts
    80
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    I have only LO Calc installed.
    But from this clip >> https://youtu.be/pj6M20H71JQ - OO Calc and LO Calc does the same in SUM function.

    That's all.

  15. #15
    Join Date
    Jun 2005
    Location
    Montreal, Que, Canada
    Posts
    6,019
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Installing Open Office

    I prepared my income taxes with LO's spreadsheet.
    I had columnar sums and row sums in the spreadsheet.
    Both worked as expected. I clicked on the first cell, and dragged the mouse to the last one, and completed the column or row sum.
    Frankly I just tested a row/column integrated sum =SUM(E7:G8) and it worked just fine.
    I am staying with LO.
    Leslie in Montreal

    Interesting web sites list
    http://forums.fedoraforum.org/showth...40#post1697840

Similar Threads

  1. installing open office and avg
    By jeb3121 in forum Using Fedora
    Replies: 10
    Last Post: 21st November 2011, 03:54 PM
  2. Installing Open Office
    By optimistique1 in forum Using Fedora
    Replies: 3
    Last Post: 2nd January 2009, 11:39 PM
  3. Help Installing Open Office
    By rickyF8 in forum Installation, Upgrades and Live Media
    Replies: 1
    Last Post: 19th December 2007, 01:25 AM
  4. Replies: 2
    Last Post: 11th December 2006, 11:22 AM
  5. Replies: 4
    Last Post: 7th March 2006, 07:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •