Quote:
You want a flat list of approximately 900 commands, no OOP?

Not much has changed visually, other than a new formula popup editor, but I'll just mention that CellBasics now handles date/time/boolean types and supports following commands:

- AND
- FALSE
- IF
- NOT
- OR
- SWITCH
- TRUE
- XOR

- AVERAGE
- SUM
- MIN
- MAX
- ROUND
- ROUNDUP
- ROUNDDOWN
- INT
- MOD
- ABS

- DATE
- DATEVALUE
- DAY
- DAYS
- EDATE
- EOMONTH
- HOUR
- ISOWEEKNUM
- MINUTE
- MONTH
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- YEAR
- YEARFRAC

Great. I want to try this baby. Hope It can be soon!

@jacadcaps

that's wonderful news. May I ask for 2 operations to be considered? One is TRIM and the other is VLOOKUP. Both very handy and highly used, but I get it if they're out of scope.

@vulture

Have not gotten around to string functions just yet, but TRIM would definitely be on the list. VLOOKUP is apparently obsolete by now and you're supposed to use XLOOKUP :P I'll get to it eventually.

splendid!

wow, this looks great!

Oh damn, this seems awesome!

Been focusing on styles/frames/text improvements lately...

An application that can not display a poop emoji in all its glory definitely feels less complete these days, so thumbs up ! ;)

Great!

Oh yes, a complete office suite would be a dream come true. I hope there will soon be an opportunity to test CellBasic it myself.

[ Editiert durch gothor 16.01.2026 - 10:25 ]

Been a while since the last post, but that doesn't mean there was no progress - I'm putting some time into CellBasics almost daily. I've completely refactored the internal several times in order to get closer to how Excel handles formulas and values of different types. My initial implementation had no coercion for example (being able to translate "5" to a number and handling a number as a string value, depending on context).

There's also this:

Things are moving fast and a first public beta is near. CellBasics supports almost 400 Excel functions by now and has a robust arexx interface that essentially lets you script the whole app (great for automated tests).

Wow! Can't wait.....

I really want to try this.

Great work!

Impressive!

CellBasics 0.57 (initial public beta) out now!

https://memtrash-pandas.ca/cellbasics/

Please note that this is a beta. While it's been extensively tested, there are bugs and there is missing functionality. Feel free to report bugs and requests here or to me directly.

Many thx jaca! That's pretty amazing!

Cool!!!

Fantastic! Lets try it!

Thansk Jaca!

It looks beautiful but seems ASL requesters are wrong (the filter is #?). I cant see any file, only directories.

Happends with all of them (load, import...)

[ Editado por tolkien 08.07.2026 - 21:08 ]

@tolkien

Import XLSX will only show files with .xlsx extension. CSV would only show .csv.

Thanks jaca!

Now we need the big CellBasics <-> Sigma comparison review :)

Quote:

But then would be better to have the asl filter to #?.xlsx or #?.csv.
CellBasics is doing an internal filtering that is nice but the asl is confusing then.

Anyway, it has all the basic features I need (perhaps pdf export to be perfect) so Im really happy.


[ Editado por tolkien 09.07.2026 - 06:27 ]