Changing the colour of text in Calc, not background
08/06/09 19:49 Filed in: Calc
Question:
As I post accounting I am used to turning those cells in the Cheque Register blue so that I know I have posted those items. I try to change the font colors in the Calc spreadsheets, and no matter how many times I do it, the font remains stubbornly black, even though the background color will change.
Read More...
As I post accounting I am used to turning those cells in the Cheque Register blue so that I know I have posted those items. I try to change the font colors in the Calc spreadsheets, and no matter how many times I do it, the font remains stubbornly black, even though the background color will change.
Read More...
|
Added a lesson on how to create filters easily with AutoFilter
28/01/09 21:31 Filed in: Calc
This lesson will show you how to filter potentially
large amounts of data with AutoFilter. The really fun
part is how easy it actually is to create!
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
The new OpenOffice.org 3.0 has arrived!
13/10/08 12:18 Filed in: OpenOffice
Today there’s good news for us all; the all brand
new version of OpenOffice.org 3.0 is here, and it is
not in beta anymore!
I have used the betas up until now, and have been very happy with the stability, so the final version should be even more stable, and I highly recommend that you do so. It is, of course, still free of charge. You can find the download here. You can find other languages here, but please be advised that not all languages has been implemented for version 3 yet.
OpenOffice.org is being developed for both Mac OS X, Linux, Windows and Solaris.
I have used the betas up until now, and have been very happy with the stability, so the final version should be even more stable, and I highly recommend that you do so. It is, of course, still free of charge. You can find the download here. You can find other languages here, but please be advised that not all languages has been implemented for version 3 yet.
OpenOffice.org is being developed for both Mac OS X, Linux, Windows and Solaris.
Added a lesson on how to create charts
11/09/08 16:59 Filed in: Calc
We have just created a lesson on charts, which is due
to a suggestion on the forums. This lesson will show
you how to create simple charts and edit them to
suit your purpose.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Corrected error in RSS-links
21/08/08 13:09 Filed in: OpenOfficeSchool
Added a lesson on how to create and modify DataPilot -- recommended!
04/05/08 22:13 Filed in: Calc
Just added a lesson on DataPilot that
shows how to master large amounts of data with
DataPilot. This is one of the really, really big
strengths of Calc, and is highly recommended
reading!
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Added a lesson on formatting of text and cells
20/03/08 20:35 Filed in: Calc
Just added a lesson on formatting that
shows how easy it is to change the appearance of a
spreadsheet in no-time. Sometimes changing the
look of a sheet can enhance how the information is
received by the end user, either it is yourself
or, perhaps even more importantly, others.
This is just a quick dip into the water, but it covers the most used features.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
This is just a quick dip into the water, but it covers the most used features.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Added a lesson with =LEN() -- how to count the number of characters in a cell or string
13/03/08 13:27 Filed in: Calc
Just added a lesson with =LEN() which can be
used for counting the number of characters in a
cell or text string. On its own it obviously
doesn’t do very much, but with combined with
other formulas new opportunities are uncovered.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Transition of lessons to one common format is completed
27/02/08 23:12 Filed in: Calc | OpenOfficeSchool
The transition to one, single format for all lessons
has now been completed, and I hope it will benefit us
all. It has taken some time, but now it’s done
I will start focusing on new lessons for Calc, and on improving the lessons in other ways, but more on that at a later stage...
Regards,
Roar Malmin
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
I will start focusing on new lessons for Calc, and on improving the lessons in other ways, but more on that at a later stage...
Regards,
Roar Malmin
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
Changes in lessons already made
24/02/08 20:54 Filed in: Calc | OpenOfficeSchool
We are now in the process of changing some of the
lessons from one format to another.
There are two reasons for this; the first is that we have now gone through the different formats, and came to the conclusion that the format used in lessons like =SUM() and =NOW() (and most other by now) is the most effective one, both for learning and for producing. The second reason is that Microsoft’s Internet Explorer 6 and older are very non-compliant, and messes up the other formats, in varying degrees.
As soon as all lessons have been changed to the chosen format, we will start making new lessons again.
The two formats that will be removed, are the ones where you click to get to the next step. Both of them has the advantage that they provide as little information as possible for each step, which is possibly less confusing, but I truly believe the chosen format will fully usable.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.
There are two reasons for this; the first is that we have now gone through the different formats, and came to the conclusion that the format used in lessons like =SUM() and =NOW() (and most other by now) is the most effective one, both for learning and for producing. The second reason is that Microsoft’s Internet Explorer 6 and older are very non-compliant, and messes up the other formats, in varying degrees.
As soon as all lessons have been changed to the chosen format, we will start making new lessons again.
The two formats that will be removed, are the ones where you click to get to the next step. Both of them has the advantage that they provide as little information as possible for each step, which is possibly less confusing, but I truly believe the chosen format will fully usable.
Click here to subscribe to the RSS feed to be notified whenever a new lesson or other news occur.