iB::Topic::SIAG dates

	Damn Small Linux :: Damn Small Linux Board The DSL Forums

» Welcome Guest
[ Log In :: Register ]

Damn Small Linux Board » Damn Small Linux » Other Help Topics » SIAG dates

		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 ]

Topic: SIAG dates, date format

< Next Oldest | Next Newest >

JohnJS

Group: Members
Posts: 200
Joined: Oct. 2006

Posted: 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?.

jpeters

Group: Members
Posts: 804
Joined: April 2006

Posted: 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.

JohnJS

Group: Members
Posts: 200
Joined: Oct. 2006

Posted: 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.

jpeters

Group: Members
Posts: 804
Joined: April 2006

Posted: 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....

JohnJS

Group: Members
Posts: 200
Joined: Oct. 2006

Posted: 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.

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 >/

Damn Small Linux Board » Damn Small Linux » Other Help Topics » SIAG dates