That was beyond the scope of what I was doing with Mathcell when I wrote it. It's an interesting idea and I'll give it some thought. At this point, the extent Mathcell handles text operations is to add them together or simply reference them.
On Wednesday, July 20, 2016 at 4:16:04 AM UTC-5, Ste Wilson wrote: > > IF OR AND & ELSE > > One of the things I do use in excel is conditional statements in cells. > I've had a go putting this in a field with: > =@if(accel="?") text = "blah" > > Which hopefully means that if the field accel =? then return the text > blah. > My question then is, is this not working due to my appalling syntax or is > it beyond the scope of Mathcell? > > My follow up question is can text be inserted depending on the value of a > field using a widget or macro? > > > > On Wednesday, 23 March 2016 03:22:51 UTC, Stephen Kimmel wrote: >> >> My TiddlyWiki math project, which I'm calling Mathcell, has progressed >> far enough to actually be of some use to people. So I'm unleashing it on >> the unsuspecting public in hopes of getting some feedback and comments. >> >> A bit of background. About the only software I use more than TiddlyWiki >> is Microsoft Excel. Inspired by a programming effort that created a Tiny >> Excel-like app in plain vanilla javascript with no libraries and just 30 >> lines of code, http://jsfiddle.net/ondras/hYfN3/, I set to work creating >> my own version. I succeeded and Mathcell (math in a cell) is the result. >> The essential tiddlers are about 3,000 bytes in total and there are three >> examples and two datatiddlers that total about another 5,000 bytes. >> >> In essence, you can enter a macrocall, <$macrocall $name="eval1" >> datatiddler="$:/sk/data" cell="a1"/> in any tiddler and create a Mathcell. >> In that Mathcell, you can enter formulas or javascript math functions and >> using a button toggle back and forth between the data entry form and the >> result. The routine can handle complex math operations, string >> concatenation and has circular reference protection. >> >> This routine is no match for Excel or even some of the much bigger add-in >> spreadsheets, but if you need some very flexible mathematics in your wiki, >> this may suit your needs. >> >> You'll find Mathcell at http://mathcell.tiddlyspot.com/ >> >> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/tiddlywiki. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/0d121b73-385c-49a2-b0b5-40f1256995e2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
