Ask Your Question

Garoolgan's profile - activity

2019-02-01 20:49:15 +0100 received badge  Popular Question (source)
2019-01-31 09:32:46 +0100 asked a question Cells copied automatically from previous entries

Cells copied automatically from previous entries Hello, This function which, after the first numbers or letters entered

2018-07-22 19:46:24 +0100 commented answer write an email address?

Thanks erAck

2018-07-22 19:10:24 +0100 received badge  Notable Question (source)
2018-07-17 12:44:20 +0100 received badge  Popular Question (source)
2018-07-16 20:17:43 +0100 received badge  Famous Question (source)
2018-07-16 19:43:36 +0100 asked a question write an email address?

write an email address? Is there any way to write a clear email address without it being "presented" in orange behind a

2018-01-05 21:02:26 +0100 received badge  Notable Question (source)
2017-10-10 13:27:29 +0100 received badge  Popular Question (source)
2017-10-09 20:36:11 +0100 asked a question How to remove header and footer in Calc by default?

How to remove header and footer in Calc by default? I use Calc for lots of things, lists etc. Each time I print out a pa

2017-04-02 09:53:23 +0100 received badge  Enthusiast
2017-03-20 22:38:06 +0100 asked a question "Frames" around cells or groups pf cells

Hi, Very, very new to Calc (ex, Excel) and I'm trying to find: 1 >> Where in Calc I can add a line, light or heavey around a cell or groups of cells. 2 > I just did a sort on an imported spreadsheet (now in .ods) which didn't work as in Excel!? Overview: This is my Home account sheet where the first two columns are A=Date of transaction and B=Date on which the bank debits/credits this transaction. Formulas use these dates along with the amount in the corresponding credit or debits columns to calculate my balance according to me in one column and in another the balance once the bank has debited or credited the transaction. Exemple: When I first register a transaction in column A, the column B is of course empty until I see, sometimes many days later, that the bank has debited or credited the transaction, but I have always sorted first by column B so that my records are as close as possible to my bank statements. When I did a sort in Excel, (B then A) the fact that B was empty, Excel sorted by the first available cell with information = A. When I do it in Calc, nothing happens! I suppose as Calc sees nothing in the first cell (B) it just stops? Things are more complicated than the above as I have piles of credits and debits all the way through to December, hence the Data sort by date. How do I get Calc to do the same sort as I did in Excel? Thanks in advance for any help Garoolgan

2016-03-07 23:12:25 +0100 received badge  Popular Question (source)
2016-02-24 15:06:25 +0100 asked a question Changing Base Fields?

Hello, I'm a complete and absolute novice with Base but I've managed to create a "Member's Form". When I set up the fields I made a couple of fields too short (number of characters). Is there any way of being able to modify this or do I have to start again? My idea was to enter about 20 members and then experiment with creating reports and queries as honestly I find the "Base Handbook" that I downloaded very, very, heavy going. Thanks for any input Garoolgan