| Poll question |
|
Have you ever had to recover documents when you shut down properly?
|
| User of the Moment |
Viewing profile :: jmg_
Joined: 567 Days
Posts: 2
Location:
|
|
| formatting cells as TIME |
Author:
officestar ::
Posted:
Sat Jan 28, 2012 4:18 am
Hello,
working with open office spreadsheets, and I have already a sheet with content
and want to change a column from "default format" to "TIME
format".
I am only dealing with minutes and seconds, so I set up the "user-defined
cells" to MM:SS.
When I change the column to the new format, all my seconds disappear, in all
cells is 00:00.
F.e. my number 13, which means 13 seconds, change into 00:00.
What do I wrong?
Also is there a way that I can put in a new times like 1121 and a MM:SS
formatted cell converts that automatically into 11:21??
thanks
|
| WILL PAY EXPERIENCED CALC CODER |
Author:
NickMMM ::
Posted:
Fri Jan 27, 2012 6:04 pm
EMAIL ME AT NMARTINENGINEERING@GMAIL.COM
I'm trying to import data(numbers) from a website where these numbers
consistently change. So I would like to tie a macro to a button that when
pressed it grabs the current data. When you Ctrl-F and type in "dB"
the numbers are to the left of dB. The numbers I need are the 2nd, 3rd, &
4th numbers to the left of where dB comes up in the document search. How can I
do this in Calc. Also these numbers may sometimes have 1 number after the
decimal and need to have the 3 values put into their own cells. Thanks for any
help anyone can provide!
|
| Default font colour will not change |
Author:
gpaciga ::
Posted:
Fri Jan 27, 2012 3:54 pm
I am trying to change the default font colour.
I have tried Styles & Formatting (F11) and setting every item in there to
use the font colour I want. I have also changed all the font colours in the
Master slide (although, the bullets of the various outline levels do not
change). Nothing seems to actually affect the colour of the text when I start
typing on the slides with the text tool.
What am I missing? I am really getting annoyed with changing the font colour of
every individual text box on every presentation I make.
|
| Noob question about summing a range of
numbers |
Author:
sy662 ::
Posted:
Fri Jan 27, 2012 2:20 pm
Hi there,
I have a sales table with over 3 million rows. Obviously it's too big to import
into Excel or Calc.
One of the Fields is CompanyX_Gross which is a [DECIMAL]
All I want to do is add up all of the numbers in this field, but I can find no
obvious way of doing it and I've been searching for the last hour.
Any help would be really appreciated.
Thanks,
Sy
|
| Changing default file extensions |
Author:
tobindia ::
Posted:
Fri Jan 27, 2012 1:47 pm
Is there any way to change the default file extensions from .odt and .ods to
.doc and .xls?
|
|
| Welcome |
Welcome to OOoForum.org, the OpenOffice.org Forum!
Register
|
| Stats |
Our users have posted a total of 374271 articles.
We have 240535 registered users.
The newest registered user is Vessplapy.
In total there are 81 users online:
Godwin, 80 Guests
|
| This site is sponsored by: |
 |
|
