I'm happy to announce today that I'm releasing QSpread 3.02 and it's sources and it's now available on GitHub (MIT License). It is written as GST MAC assembler code with additional tools like QMake or from the early SMS build toolchain.
As you can't probably build it yourself (yet) the corresponding ZIP and the last PDF are attached here. There is also a 4.04 version which appears to have some small issues and we're still tracking down the source code to rebuild it. It will also be release, but first I like to clean up what we have with 3.02 so that the changes also nicely trace back.
A very special THANKS to Marcel for finding and sheltering the sources and for agreeing to the Open Source plans, and also to Jochen and Bernd for taking over when I left.
The repo is https://github.com/olifink/qspread/
Reach out here if you have questions...
enjoy! O
QSpread 3.02 now released on GitHub
QSpread 3.02 now released on GitHub
- Attachments
-
- qspread302.zip
- (231.52 KiB) Downloaded 137 times
-
- QSpread.pdf
- (223.17 KiB) Downloaded 128 times
-
- Font of All Knowledge
- Posts: 3957
- Joined: Mon Dec 20, 2010 11:40 am
- Location: Sunny Runcorn, Cheshire, UK
Re: QSpread 3.02 now released on GitHub
Hi,
QSpread is one of best QL Applications. Alas Qbranch did not want to sell me a copy. Maybe the issues with my success with the Q60, upset him. Pity as I bought all the software. But he did not support me.
I disassembled the demo version and made it save.
Is it possible to write macros using SBASIC?
QSpread is one of best QL Applications. Alas Qbranch did not want to sell me a copy. Maybe the issues with my success with the Q60, upset him. Pity as I bought all the software. But he did not support me.
I disassembled the demo version and made it save.
Is it possible to write macros using SBASIC?
Regards,
Derek
Derek
Re: QSpread 3.02 now released on GitHub
Olifink,
I found the section in the documentation about user defined functions. It is not clear from the manual how they are used and if they are functions or formula's. Can you provide an example?
Thanks,
Tim
I found the section in the documentation about user defined functions. It is not clear from the manual how they are used and if they are functions or formula's. Can you provide an example?
Thanks,
Tim
Re: QSpread 3.02 now released on GitHub
Derek_Stewart wrote: QSpread is one of best QL Applications.
thanks (blush)
no - that would have been a very complex undertaking at the time. I don't know how a job could call into SBASIC - maybe it's possible now, but it was written partly on/for SMS2 which didn't even have any BASIC available, and SMSQ was just getting complete.Derek_Stewart wrote: Is it possible to write macros using SBASIC?
Compiled SBASIC filters could be way, QSpread uses filters quite intensively for saving and printing, and to me it's one of the most neglected functions the QL offers. The original Toolkit showed great ways very similar to *nix pipes to use it, but it in TK2 it wasn't much talked about.
Depends on what you're looking for, I could image it shouldn't be too difficult to make all of QSpread a Thing and let SBASIC commands interface with it.
Just some ideas - no plans really
hehe, I found that myself and was wondering if I was really responsible for it or if it was one of Jochens ideas. It's actually very easy (but also very different from, uhm, Excel). It's not at all like DEF FN in code where you'd give it a name and use that name in another formula, it more like a static textual templace replace.swensont wrote:I found the section in the documentation about user defined functions. It is not clear from the manual how they are used and if they are functions or formula's. Can you provide an example?
Say you often calculate the VAT and it has the formula
Code: Select all
value*0.15
now instead of typing it in, you can just define a user fn (DO/right click the text field in the F6 dialog) and enter
Code: Select all
\r*1.15
hope that helps
Re: QSpread 3.02 now released on GitHub
olifink,
Thanks that does help. I was really hoping for it to be a function, but the details was leading me more towards a form of clipboard for formulas.
Tim Swenson
Thanks that does help. I was really hoping for it to be a function, but the details was leading me more towards a form of clipboard for formulas.
Tim Swenson