Search Members Help

» Welcome Guest
[ Log In :: Register ]

Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic
Pages: (5) </ 1 [2] 3 4 5 >/

[ Track this topic :: Email this topic :: Print this topic ]

 reply to topic new topic new poll
Topic: SIAG dates, date format< Next Oldest | Next Newest >
jpeters Offline





Group: Members
Posts: 804
Joined: April 2006
Posted: Mar. 22 2007,20:06 QUOTE
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").
Back to top
Profile PM 
JohnJS Offline





Group: Members
Posts: 200
Joined: Oct. 2006
Posted: Mar. 23 2007,17:31 QUOTE
Thanks jpeters:

Works like a charm.
Back to top
Profile PM 
jpeters Offline





Group: Members
Posts: 804
Joined: April 2006
Posted: Mar. 23 2007,20:21 QUOTE
...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......)
Back to top
Profile PM 
JohnJS Offline





Group: Members
Posts: 200
Joined: Oct. 2006
Posted: Mar. 23 2007,21:05 QUOTE
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..
Back to top
Profile PM 
jpeters Offline





Group: Members
Posts: 804
Joined: April 2006
Posted: Mar. 24 2007,02:16 QUOTE
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.
Back to top
Profile PM 
21 replies since Oct. 22 2006,15:27 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

Pages: (5) </ 1 [2] 3 4 5 >/ 		reply to topic new topic new poll
Quick Reply: SIAG dates

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code