OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
Menu
Forums
Topics
FAQ
Memberlist
Usergroups
Edit Profile
PM Inbox

Links
OpenOffice.org
OOoMacros.org
OOExtras.org
OOoDocs.org
LinuxSelfhelp.com
more...

Books & Training
Getopenoffice.org
Digitaldistribution.com
8daysaweek.co.uk
more...

Search
 

Search Options

Poll question
Have you ever had to recover documents when you shut down properly?
Yes [ 1 ]
No [ 0 ]
You cannot vote in polls in this forum
View Results

User of the Moment
Viewing profile :: jmg_
Joined: 567 Days
Posts: 2
Location:

Forum Topics Posts
OpenOffice.org Forums
Setup and Troubleshooting
Discuss OpenOffice.org setup and installation issues
11151 41722
OpenOffice.org Writer
Discuss the OpenOffice.org word processor
25114 110218
OpenOffice.org Calc
Discuss the OpenOffice.org spreadsheet application
18443 79290
OpenOffice.org Impress
Discuss the OpenOffice.org presentation application
3328 9868
OpenOffice.org Draw
Discuss the OpenOffice.org drawing application
1333 4825
OpenOffice.org Math
Discuss the OpenOffice.org formula editor
747 3060
OpenOffice.org Base
Discuss the OpenOffice.org database features
9009 36258
OpenOffice.org Macros and API
Discuss OpenOffice.org programming issues
16377 59732
OpenOffice.org Code Snippets
Discuss and share OpenOffice.org code snippets
484 2218
Community Forums
General Discussion
Discuss anything you want
5169 24858
Site Feedback
Provide site feedback and suggestions
423 2222

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


Sad

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

Log in
Username:

Password:

Log me on automatically
 

Latest Discussion
Sat Jan 28, 2012 5:36 am floris_v
General input/output erro...
Sat Jan 28, 2012 5:30 am kevin.burton
Number Formats and Locale...
Sat Jan 28, 2012 5:11 am gpaciga
Default font colour will ...
Sat Jan 28, 2012 4:18 am officestar
formatting cells as TIME
Sat Jan 28, 2012 2:09 am nebstah1
Copying values (not formu...

Downloads
Download OpenOffice.org (en)
OOo 2.3.0 Split Download Set
OOo 2.3.0 for Windows
OOo 2.3.0 for Linux
OOo 2.3.0 for Solaris (x86)
OOo 2.3.0 for Mac OS X (Intel)
OOo 2.3.0 for FreeBSD 6.2

Top Ten Posters
1. cheapclothessneaker 16777206
2. Villeroy 9643
3. JohnV 8686
4. jrkrideau 6416
5. David 5670
6. Hagar Delest 5169
7. acknak 4302
8. AndrewZ 4140
9. DannyB 3992
10. 9point9 3882

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:
UnitedLayer

Powered by phpBB © 2007 phpBB Group.