Is there a way to add times that total greater than 24 hrs?
I'm trying to add a sum of cells with the format HH:MM. If the sum exceeds 24h I get strange results like 3:55h
I tried [H]:MM:S
Which format should I choose?
I'm using open-office calc.
...
Copying Formulas to Show
Good afternoon,
I'm trying to copy a page of formulas to a text document (final target will be scribus - but this is irrelevant). What I'm wanting is to copy the actual formulas - create a table containing the formulas and not, instead, their values.
I've looked th...
Opening Open office documents is slow on Windows 2003 server
While trying to open/access open office documents on Windows 2003 server it gives a very slow response same but while accessing the same document using Microsoft Office 2007 it opens up instantly.
The version of open office installed on windows 2003 server is 3.2. I have even trie...
What is the least-error-prone way to share CSV data?
One of my jobs is to upload product data to the company store. The data is initially pulled from the company database by my supervisor, and she puts it into an Excel spreadsheet and exports as CSV. I then convert the CSV file into the format the store software desires and upload it. I generally u...
How NOT to print sheet name and page number in OpenOffice.org Calc?
When I print a spreadsheet in OpenOffice.org Calc (latest version), it keeps adding the name of my current sheet to the top, and a page number to the bottom of my print out.
How do I turn this OFF???
Thank you.
P.S. I am running it on Mac OS X 10.6....
How to remove unused columns and rows from being displayed in calc.
Does anyone know how to remove unused columns and rows from being displayed in an openoffice.org calc file? I want the display to just be solid grey or white with no grid or column/row names.
...
Can I add zero line index to OpenOffice.org Calc?
In a task of mine it'd be better if the very first line in a table had index 0 instead of 1. Is this possible in OpenOffice.org Calc?
...
Down arrow key not working in OpenOffice Calc
How do I make the down arrow key work again in OpenOffice Calc?
The down arrow key used to work, but now the Calc installation is in a different state. The other arrow keys work fine....
Database access through odbc driver and excel
Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file?
The program I am accessing data only allows an ODBC connection in. Not sure what database it is.
...
How to set default number of sheets in new OpenOffice Calc files?
In Micro$oft Excel and OpenOffice.org, new spreadsheet files always come with three sheets by default (i.e. Sheet 1, Sheet 2, Sheet 3).
How to I change the default to just one sheet in OpenOffice.org??
Thanks!
...
Repeat rows at top of printed page
In Excel, under Page Setup, there is an option for "Print Titles", where you can specify a number of rows to repeat at the top of the printed page, as well as a number of columns to repeat at the left of a printed page.
Is there a similar setting in OpenOffice? If so, under what ...
Recover password from OpenOffice.org spreadsheet
Is there a way one can recover a lost password on an OpenOffice.org Calc spreadsheet?
I forgot what mine was and can't access these important files any more.
i've been searching in the internet and i saw interlore tool. does anyone tried this one?
...
Excel: How to sum values in a column based on multiple criteria
I have a list of criteria in row 20, like this:
A20: "My Company, Inc."
B20: "Client Expenses"
C20: "Travel"
The data is below, like this:
B40: "Client Expenses"
C40: "My Company, Inc."
D40: "Travel"
...
How do I use address data in Calc to populate labels in Writer in the OpenOffice.org suite?
I have a list of mailing addresses in a calc spreadsheet - one column per line in the address. I want to print them out on a sheet of labels. When I open a new labels document, there doesn't appear to be an option to set the source of the label text as a spreadsheet. The only options it gives ...
How can I create a toolbar button that applies a thousands-separated number style in OpenOffice.org Calc?
In OpenOffice.org Calc I very often want to format numbers with a thousands separator.
How can I create a toolbar button to do this?
Via the menus, the appropriate format can be applied with Format -> Format Cells -> Number, and the number format is #,##0...
Excel or open office calc how to remove last white space?
Excel or open office calc how to remove last white space?
...
Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?
I'd like to refer to an entire column, like you can in Excel by using A:A. I found a discussion on the openoffice.org forums which is a few years old, and suggests there is/was no n...
Disabling Autoformat in Openoffice
I'm trying to enter the number 3.10 into a field in Openoffice Calc. Unfortunately, the default setting is to be "smart" and reformat my input as 3.1. Since my column represents section headers, 3.10!=3.1. Also, my document is a CSV file, so I can't reformat the cell as a "-1234.12". How do I dis...
Freeze both row and column in openoffice calc
how can i use freeze in openoffice calc for both row and column so that 1st row and 1st column will always be visible? :O
...
Inserting scientific data into open office Calc
hello, i have some scientific data that i want to insert into oo.org calc. when i do this, instead of displaying 0.35678 in a cell it displays 0.35 (only the first 2 digits after the decimal). but on clicking the cell, the formula bar shows the correct value...please help
...