SIAG dates
Forum: Other Help Topics
Topic: SIAG dates
started by: JohnJS
Posted by JohnJS on Oct. 22 2006,15:27
Using DSL 3.0.1.Having problem entering dates when using SIAG. The year reverts to 1969.
Tried different formats when entering ie., 12/31/2006 2006/12/31, 12.31.2006 etc to no avail.
What am I doing wrong?.
Posted by jpeters on Mar. 21 2007,07:31
Too bad nobody responded to this; I just noticed the same thing.The only solution I found was to enter the date as a label (i.e., May 20, 2007).
EDIT: I just figured it out; use the menu under "Data" for entering date, and use mm/dd/yy format.
Posted by JohnJS on Mar. 21 2007,17:10
Thanks jpeters,I figured it out through trial and error.
www.siag.nu/siag has a lot of info but not very helpful on the basics.
Haven't figured out how to retain column formats (default, fixed etc) from column to column without using mouse to change each cell.
Posted by jpeters on Mar. 22 2007,07:08
Hi John,Block out an area, format, and save....should work, although I had to
do it twice initially to clear prior formating from individual cells. I stopped formating entire columns when I found it increased loading time substantially. (i.e, loading formating for hundreds of unused lines).
Now if I could just find a way to have Siag import in formulas from other formats instead of just labels, I'd love this spreadsheet....
Posted by JohnJS on Mar. 22 2007,16:34
Hi jpeters,I too like SIAG.
I noticed it does not require the equal sign when entering a formula.
I use it as a checkbook register so my columns have different formats.
I've been entering similar format entries at one time, ie. defaults then fixed then dates.
A little slower but it works.
Block "Smart fill" only seems to work on two cells at a time, when used to adjust balance instead of retyping formula.
Did you check out the web site?
Regards.
Posted by jpeters on Mar. 22 2007,20:06
I haven't found any problems getting Siag to smartcopy formulas across a series of cells in a block:Copy formula you want to smartcopy and paste into first of a series
of cells. <shift click> the last cell of the series to create the block.
Select "Block/Smart Fill Block." That should do it.
Formulas get entered beginning with "+", unlike "=" in excell and OO.
There are lots of other differences also (e.g. "+power(5,2)" vs "=5^2" in 00"
I've checked out the site you listed in addition to several others I found doing google searches for specific questions (e.g., "Siag dates").
Posted by JohnJS on Mar. 23 2007,17:31
Thanks jpeters:Works like a charm.
Posted by jpeters on Mar. 23 2007,20:21
...although very non-intuitive. The more I struggle with Siag, the more willing I am to wait for OO to load. (Try out a few IF statements......)
Posted by JohnJS on Mar. 23 2007,21:05
No problems using IF statements in SIAG ver 3.5.7.For more involved calculations I save as csv and use OO callc
edit CALC. not callc..
Posted by jpeters on Mar. 24 2007,02:16
Hi John,Please post REF to conditional operators. (I figured there's a way to do it that works..).
Saving to csv format removes all the formulas.
Posted by JohnJS on Mar. 24 2007,16:07
You're correct. After importing csv file to OO I then add formulae.Here's a couple of straightforward IF stmnts.
#if(e5>10,e5+g4,"none")#
#if(e5,g4-e5,g4+f5)#
Note: I don't place = or + before the IF. Seems to work okay.
e5 g5 f4 formatted to 'fixed'.
Used above for my checkbook register.
oops: should be e5 g4 f5
Have you checked out /knoppix/usr/local/share/siag/siag ?
Especially 'functions.scm'
Posted by jpeters on Mar. 24 2007,19:56
That's what I tried, and it doesn't work; instead it selects the first choice no matter what. I tried your example; same error.Thus:
if(5>10, 9,0) produces 9. I'm surprised it works on your copy, since I'm using ver 3.5.7
Posted by JohnJS on Mar. 26 2007,15:35
Hi jpeters,The second example I gave was for my cb register it has been working.
if(debit,bal-debit,bal+credit)
The > or < does not seem to work with the IF stmnt. Must be another way to do it. Have been searching the Web but no success so far.
Will let you know if I find the solution.
Edit:
So far I determined SIAG IF statement with < or > works as " if ...then" only.
Have been used to: "if..then..otherwise"
edit:
My mistake, > or < still not working with IF. Darn it.
edit: 3/26 130pm
You're right. So far SIAG is doing the basics for me.
That's all I need most of the time.
Thanks for all the info.
Posted by jpeters on Mar. 26 2007,19:46
| Quote (JohnJS @ Mar. 26 2007,10:35) |
| My mistake, > or < still not working with IF. Darn it. |
Actually, it isn't working with anything. "if(23==45,1,0)" produces "1"
No sense beating a dead horse; Schemes don't work either, meaning a lot of the functions have been stripped out; great if you need a basic chart, but for all else, oo.
Posted by andrewb on Mar. 26 2007,23:05
There's always Gnumeric - see the UNC repositry. It now only needs GTK loaded to work & is more powerful than Siag, yet not as slow to load as OO.
Posted by jpeters on Mar. 27 2007,02:32
I seriously want to love UNC's, and have tried loading 3.2 several times now with the best of intentions, but things tend to freeze up.....I fear UCI's are out of fashion. (sorry...this should be left for another thread)
Posted by andrewb on Mar. 27 2007,03:05
There is also a DSL version in the GTK repositry
Posted by jpeters on Mar. 27 2007,05:19
(oops...)
Posted by jpeters on Mar. 27 2007,05:20
Bingo....that's it...perfect. Thanks, andrewb; I owe you a seltzerh20!! 
Posted by andrewb on Mar. 27 2007,06:55
I've sent the DSL vesion of Gnumeric with the missing libraries (so gnupg & gnu-utils aren't required) to Robert for posting in the repositry. Look out for the update version of Gnumeric in the GTK2 section.
Posted by andrewb on Mar. 29 2007,04:52
Robert has posted the update version of Gnumeric.dsl in the testing area if you are looking for it. Please read the info file. Only GTK is required now - NOT gnupg & gnu-utils
Posted by jpeters on Mar. 31 2007,01:39
Thanks andrewb! (not for this forum, but I'm back to oo....too slow doing things I do all the time, like insert a new line, save, some problems doing web links, etc, etc. Nice for small spreadsheets, though!EDIT: I made another xls copy of the same spreadsheet (from oo) and Grumeric opens new lines and saves rapidly. Haven't been able to find why it hangs on one and not the other, since everything else seems identical. Anyway, I'll give it some more time....