Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
DDebbil

Alternatives to Excel that aren't LibreOffice Calc

Recommended Posts

Posted · Original PosterOP

I'm scouting around for programs that are very similar MS Excel. I tried LibreOffice, but unfortunately Calc seems to have quite poor filter options, so that is a no go. Can anyone recommend anything else?

Link to post
Share on other sites
Posted · Original PosterOP

OpenOffice and LibreOffice appear to have the same limitations regarding filtering. For example, you cannot do something as simple as filtering according to cell colour (unless, I assume, you want to do some coding of your own). Google sheets also does not appear to support this functionality. Googling around, it is dismaying to see people repeatedly asking for this functionality and being told in reply that they shouldn't want it.

Link to post
Share on other sites
20 minutes ago, DDebbil said:

OpenOffice and LibreOffice appear to have the same limitations regarding filtering. For example, you cannot do something as simple as filtering according to cell colour (unless, I assume, you want to do some coding of your own). Google sheets also does not appear to support this functionality. Googling around, it is dismaying to see people repeatedly asking for this functionality and being told in reply that they shouldn't want it.

You want the program to filter by the color of the cell? Unfortunately, I had found Google Sheets didn't support this.

I did found a way around it.

 

For some context; I have a sheet where I track some collectables; where red = I don't have it and green = I have it. I couldn't just color the cell green/red and be done with it.. The way I achieve this, was simply by making two filters:

1. when just the singular number '1' was entered in the cell; the text color and background color of this cell become green.

2. when the singular word 'no' appeared in the cell; the text and background color become red. 

 

So when, for example, I have column B filled with all the 1's and 'no's; I can simply do a  'COUNTA' of B to see the amount of entries, and a 'SUM' of B to get the amount of times I filled in '1'.

Code to do the Sum and Count:

=SUM(B:B) & "/" & COUNTA(B:B)

For example, if I had five row in column B, two of which filled with 'no', three with '1' this formula would look a little something like this:

image.png.4e216dfe8ac8b423658c2dbb6deb9b00.png

 

This is achieved with conditional formatting (which can be found in the 'Format' tab of Google Sheets) and can be put to use quite effectively.

Options:

Spoiler

image.thumb.png.ae9579c3123b0e2b6bc3648425c450ba.png

 

It's probably best though to maybe do conditional formatting on something not as simple as 'no' or '1', as of course data you don't want to be formatted shouldn't be formatted because it includes either one of these things.

You could do conditional formatting on some rather specific strings (e.g. 1 = A1234 and no = A9876) and count them like this (instead of Sum on the 1's):

=COUNTIF( B:B ; "A1234" )

 

 

This may not be exactly what you're looking for, but maybe it helps at least?


"There's no such thing as perfect. You're beautiful as you are Courage. With all your imperfections you can do anything." - Bathtub Barracuda

"How can someone win if winning means that someone loses" - Scatman John

"64 bits, 32 bits, 16 bits, 8 bits, 4 bits, 2 BITS, 1 BIT, HALF BIT, QUARTER BIT, THE WRIST GAAAAAAME!!!" - Angry Video Game Nerd

Gear:                           .                                                                                                                         .

Spoiler

PC:

CPU: AMD Ryzen 7 1700 || Motherboard: MSI X370 Gaming Pro Carbon || RAM: 2x8GB G.Skill TridentZ RGB 3200Mhz (running at 2933Mhz) || GPU: Gigabyte Auros RX 580 4GB || Storage: Samsung 960 EVO 250GB + Seagate Barracuda 2TB || Cooling: Be Quiet! Dark Rock 3 || Case: Thermaltake Core G21 TG || PSU: Corsair RMx 750W

Peripherals:

Headphones: Beyerdynamic DT-990 250 Ohm || Mouse: Roccat Kiro || Keyboard: Coolermaster Masterkeys Pro S RGB || Mousepad: CM Storm Swift-RX XXL || Graphics tablet: Wacom Intuos Pen Small

Old PC:

CPU: AMD Athlon X2 255 || Motherboard: ASUS M4A89GTD PRO || RAM: 4x2GB DDR3 || GPU: Nvidia Quadro 512MB || Case: Antec Sonata III || PSU: Antec Earthwatts 500W Bronze

Minibois' Digital Art Thread

Reviews: Coolermaster Masterkeys Pro S RGB || Wacom Intuos Pen Small || Roccat Kiro

Threads: Pokémon Thread || Dutch Talk || Super Smash Bros. Melee Thread

Setup: Current setup

Link to post
Share on other sites
1 hour ago, DDebbil said:

I'm scouting around for programs that are very similar MS Excel. I tried LibreOffice, but unfortunately Calc seems to have quite poor filter options, so that is a no go. Can anyone recommend anything else?

WPS office, if you are willing to pay, deal with annoying startup ads, or fight your way through ccircumventing them. Closest to MS I've seen, arguably better in many ways (like its night mode that prevents eye burn without just inverting color schemes).

 

Softmaker Office also has a decent free version, without invasive ads. More similar to Libreoffice, but in my experience worked better in Windows (I've had no problem in Linux, but my attempts at OpenOffice first and Libreoffice later all ran like shit on Windows-java).

 

I've tried a different one that was OK as well, but can't remember its name :P I'm always on the look for office software, especially spreadsheets. I think I could be on the paid version of WPS, but when I last checked pricing was quite steep even compared to MS (it may even have been subscription-based, which it's just not going to happen for me).

Link to post
Share on other sites
Posted · Original PosterOP

I had a look at WPS office - and it is very close to MS Office but with a pricing model to match. Also the country of origin and the propensity to spam ads all over the place makes me wonder about security. 

 

Softmaker FreeOffice does seem to have a slightly better filter function than LibreOffice (at least for my needs) and a pretty decent interface - but still no filter by colour! I can probably use a helper column to aid the colour sorting, but still it baffles me that only Excel and WPS have managed to include this function.

Link to post
Share on other sites

If out of recommendations, you can always work your way through the results at https://alternativeto.net/

The downside is that the comments there are unlikely to tell you if the specific feature you are after exists in a particular program.

 

@DDebbil : I've remembered the name of the other: Onlyoffice. It seems it may have some sort of color sort/filtering:

 

https://helpcenter.onlyoffice.com/ONLYOFFICE-Editors/ONLYOFFICE-Spreadsheet-Editor/UsageInstructions/SortData.aspx

 

Good luck!

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×