Hello:
My install of OO (3.3.0, build 9567), when initiated without the command
line option -norestore, says that it wants to restore a small CSV
file that ALWAYS exists on my system. If I click OK, it aborts
after throwing an instance of 'com::sun::star::uno::RuntimeException'.
A long dump of
I am reviewing the records of a local shop to help him convert to Open
Office. I have found no problems with the simple Word documents that
he uses, but he is using MS Excel where he should have a real
database. We all know about efforts to teach an old dog new tricks, so
let's just be glad that
I checked the archive and I could not find anything like this. I want
to take data from one sheet from a series of cells that will be
changing but might repeat themselves and take that data and check it
against the data in a column on another sheet and if the data is
already listed there do
Can someone please help me?
I open CALC and there is a large window offering a selection of themes,
backgrounds, etc. How do I make this window go away?
Many thanks,
Irv.
--
“Experience hath shewn, that even under the best forms (of government) those
entrusted with power have, in time, and
Hello:
Calc now offers VERY LARGE numbers of rows and columns. On the surface
this seems great, but I have recently encountered problems updating a
spreadsheet which uses just IT columns and 1055 rows on the main sheet,
and about 9 subordinate sheets, mostly with just a few cells filled.
One
Hi,
I have got a question concerning your experiences with the collaboration
feature of openoffice.org calc.
Does this feature work well? Are there any problems likely to occur?
I am aware of the limitations mentioned in:
OOo 3.2.1 (I know, I know; but as far as I'm concerned it ain't broke so
...) on Vista Home Premium.
How do I get Calc to restart its page numbering at the start of each new
sheet?
Also, I'd like each sheet to have its pages numbered in the form Page n
of m where m is the number of pages
I'm running Windows XP with Oo 3.3
Can anyone tell me where I can get a converter to change a Calc ODS as an
XLS file for Excel 2003 or 2007?
In Ubuntu 10.04 the Oo I have will convert to 2003 xls.
With 3.3 the only option is to save the ODS as an Excel 2000 XLS.
--
Hello,
I have a Calc spreadsheet I use to keep track of time, kind of a time card.
I use the 24 Hrs. format. I have a Sheet for each client for the current
month (so it would include 31 rows maximum, not including the first one used
for the headers):
Column A has the Start Time (i.e.: 09:15)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My spreadsheet has a tiny monthly calendar on it that has 1 cell for
each day. So, it has 7 columns across and 8 rows down. When you select
the cells it has a range like this- A1:G8
I want to put the contents of cells A1 to G8 into 1 cell on
Den 2011-02-18 21:56:45 skrev . pe...@aleksandrsolzhenitsyn.net:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
My spreadsheet has a tiny monthly calendar on it that has 1 cell for
each day. So, it has 7 columns across and 8 rows down. When you select
the cells it has a range like this-
On 2/4/2011 2:05 PM, . wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I hit Shift- F5 so I can Trace Dependents.
How do I remove the Trace Dependent lines as they're all over my sheet?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla -
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I hit Shift- F5 so I can Trace Dependents.
How do I remove the Trace Dependent lines as they're all over my sheet?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
Thank you
On 02/04/2011 03:55 PM, openoffice.mbou...@spamgourmet.com wrote:
. - pe...@aleksandrsolzhenitsyn.net wrote:
I hit Shift- F5 so I can Trace Dependents.
How do I remove the Trace Dependent lines as they're all over my sheet?
Tools Detective Remove All Traces
There is no
I have used a simple macro linked to a button to enter the current date
and time in a cell for several years. It is not working now that I have
installed version 3.3.0 on Windows XP, SP3. So I re-recorded the macro.
But when I look at the macro, the =now() function is not included. The
jump
Den 2011-02-02 03:33:47 skrev . pe...@aleksandrsolzhenitsyn.net:
On 02/01/2011 11:26 AM, Michael D. Roush wrote:
On 2/1/11 11:13 AM, . wrote:
How do I get Calc to put any year (listed in cell A1) and the month
(listed in B1) into C1 so that it would look like this; January 2011
Given
Does Calc have an unsync option for window splits?
Even though you can split the window vertically the scrolling is
simultaneous between the split window.
signature.asc
Description: OpenPGP digital signature
On 01/02/11 13:34, . wrote:
Does Calc have an unsync option for window splits?
Even though you can split the window vertically the scrolling is
simultaneous between the split window.
Don't forget the screen splits horizontally too. And both at once, for
those with a clear head :-)
--
Mike
All I want to know is how to unsync them.
On 02/01/2011 08:38 AM, Mike Scott wrote:
On 01/02/11 13:34, . wrote:
Does Calc have an unsync option for window splits?
Even though you can split the window vertically the scrolling is
simultaneous between the split window.
Don't forget the
Hi,
2011/2/1 . pe...@aleksandrsolzhenitsyn.net:
All I want to know is how to unsync them.
I don't think that this is possible. This kind of defeats the purpose
of this feature.
You can split the window of a large table. The intention behind this
feature is, that you always see the row/column
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
How do I get Calc to put any year (listed in cell A1) and the month
(listed in B1) into C1 so that it would look like this; January 2011
Please don't reply unless you know exactly how to do it.
-BEGIN PGP SIGNATURE-
Version: GnuPG
Den 2011-02-01 17:13:10 skrev . pe...@aleksandrsolzhenitsyn.net:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
How do I get Calc to put any year (listed in cell A1) and the month
(listed in B1) into C1 so that it would look like this; January 2011
Please don't reply unless you know exactly
On 02/01/2011 11:26 AM, Michael D. Roush wrote:
On 2/1/11 11:13 AM, . wrote:
How do I get Calc to put any year (listed in cell A1) and the month
(listed in B1) into C1 so that it would look like this; January 2011
Given that you have 2011 in cell A1, and January in cell B1, the
correct
On 1/26/2011 9:27 AM, Sigrid Carrera wrote:
Hi,
2011/1/26 .pe...@aleksandrsolzhenitsyn.net
I figured it out. Due to very poor explanation at this link-
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_IF_function
the author fails to mention one important part; the
signature.asc
Description: OpenPGP digital signature
yes, calc has one.
2011/1/26 . pe...@aleksandrsolzhenitsyn.net
If you need more information, you should describe, where you have problems.
I don't have a glass sphere that can tell me, what everyone needs to know.
Sigrid
PS: Please reply to the list only.
Den 2011-01-09 02:11:52 skrev Brewster Gillett b...@fdi.us:
On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote:
I ran into a few other bad bugs with the Ubuntu-version of
OpenOffice.org
and finally I just couldn't stand it any more, so I kicked it out and
installed the ”real”
I have explicitly followed the OOHelp instructions - FORMAT-PRINT
RANGES-EDIT, done the instructed highlighting for the top two rows that
I seek to have printed on every page, and have gotten the echo
that is displayed on the help screen - $1:$2. But when I go to
exit, I get a tiny popup that
I have scoured the OOHelp files for an answer and cannot come up with
one. Is it even possible to print out a Calc spreadsheet in
double-space?
Thanks,
Brewster
--
***
Embrace a sharing community of sustainable justice
At 13:12 08/01/2011 -0800, Brewster Gillett wrote:
I have explicitly followed the OOHelp instructions - FORMAT-PRINT
RANGES-EDIT, done the instructed highlighting for the top two rows
that I seek to have printed on every page, and have gotten the echo
that is displayed on the help screen -
On 1/8/2011 4:14 PM, Brewster Gillett wrote:
I have scoured the OOHelp files for an answer and cannot come up with
one. Is it even possible to print out a Calc spreadsheet in
double-space?
Thanks,
Brewster
Increase the row height of all rows to double what it is currently. The
effect will
At 13:14 08/01/2011 -0800, Brewster Gillett wrote:
I have scoured the OOHelp files for an answer and cannot come up
with one. Is it even possible to print out a Calc spreadsheet in double-space?
First, it's not generally helpful to think of doing anything
double-space. This is typewriter
At 13:12 08/01/2011 -0800, Brewster Gillett wrote:
I have explicitly followed the OOHelp instructions - FORMAT-PRINT
RANGES-EDIT, done the instructed highlighting for the top two rows
that I seek to have printed on every page, and have gotten the echo
that is displayed on the help screen
Den 2011-01-09 01:11:42 skrev Brewster Gillett b...@fdi.us:
At 13:12 08/01/2011 -0800, Brewster Gillett wrote:
I have explicitly followed the OOHelp instructions - FORMAT-PRINT
RANGES-EDIT, done the instructed highlighting for the top two rows
that I seek to have printed on every page, and
On 1/8/2011 4:14 PM, Brewster Gillett wrote:
I have scoured the OOHelp files for an answer and cannot come up with
one. Is it even possible to print out a Calc spreadsheet in
double-space?
Thanks,
Brewster
Gene Young wrote:
Increase the row height of all rows to double what it
At 13:14 08/01/2011 -0800, Brewster Gillett wrote:
I have scoured the OOHelp files for an answer and cannot come up
with one. Is it even possible to print out a Calc spreadsheet in
double-space?
Brian Barker wrote:
First, it's not generally helpful to think of doing anything
On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote:
I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org
and finally I just couldn't stand it any more, so I kicked it out and
installed the ”real” OpenOffice.org. Worked like a charm since then. I
don't know if
Hi Brewster,
2011/1/9 Brewster Gillett b...@fdi.us:
On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote:
I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org
and finally I just couldn't stand it any more, so I kicked it out and
installed the ”real” OpenOffice.org.
On Sat Jan 08 2011 17:11:52 GMT-0800 (PST) Brewster Gillett wrote:
On Sun, 2011-01-09 at 01:45 +0100, Johnny Rosenberg wrote:
I ran into a few other bad bugs with the Ubuntu-version of OpenOffice.org
and finally I just couldn't stand it any more, so I kicked it out and
installed the ”real”
At 17:06 08/01/2011 -0800, Brewster Gillett wrote:
But as it happens, that is *exactly* what I want. A blank line,
every other row, demarcated by the half-tone grid I prefer. IOW a
space in which to manually add new data as it arises, for later transcription.
Aha! That wasn't clear anywhere
Dear Sir/Madam,
We have one ods file attached which has
some problem, Please check and tell how to rectify the problem.
Thanks Regards.
Shabbir Shaikh.
There is no substitute for hard work.
Girish K.ods
Description:
Original message
Date: Tue, 04 Jan 2011 09:42:28 -0500
From: . pe...@aleksandrsolzhenitsyn.net
Subject: [users] Calc- several sheets all in sync
To: users@openoffice.org
I've created a Monthly Calendar Generator in
Calc- you can see the
template here-
http
Original message
Date: Tue, 04 Jan 2011 09:42:28 -0500
From: . pe...@aleksandrsolzhenitsyn.net
Subject: [users] Calc- several sheets all in sync
To: users@openoffice.org
I've created a Monthly Calendar Generator in
Calc- you can see the
template here-
http
Original message
Date: Mon, 03 Jan 2011 11:42:05 +0100
From: Uwe Fischer uwe.fisc...@oracle.com
Subject: Re: [users] Calc shows Sort greyed-out
To: users@openoffice.org
On 12/31/10 05:29, Lee wrote:
Using version 3.2.1 in OoCalc, I have a list of
movie names to sort
Original message
Date: Sat, 01 Jan 2011 11:15:29 +0100
From: Franz Wein f.w...@f-wein.com
Subject: Re: [users] Calc
To: users@openoffice.org
Hi Joe
use the right mousebottom - on the tabulator at
the screenbuttom. Select
the in the dropdown-menue insert spreadsheet
Original message
Date: Thu, 30 Dec 2010 10:53:16 -0800 (PST)
From: J Halka jhjh...@yahoo.com
Subject: [users] Calc
To: users@openoffice.org
I have used Lotus 123 and later some Excel. How
do I open a new spreadsheet in
Calc. Thanks, JoeH
Original message
Date: Sat, 01 Jan 2011 11:15:29 +0100
From: Franz Wein f.w...@f-wein.com
Subject: Re: [users] Calc
To: users@openoffice.org
Hi Joe
use the right mousebottom - on the tabulator at
the screenbuttom. Select
the in the dropdown-menue insert spreadsheet
At 14:17 05/01/2011 +0530, Shabbir Shaikh wrote:
We have one ods file attached which has some problem, Please check
and tell how to rectify the problem.
May I be bold and say that you are expecting a lot here? You
shouldn't, I suggest, expect subscribers to a mailing list simply to
take
I've created a Monthly Calendar Generator in Calc- you can see the
template here-
http://templates.services.openoffice.org/en/node/4973
All you do is enter an Event (like your birthday) in one cell and the
date of the event in the cell next to it. The Event is automatically
entered in the
On 12/31/10 05:29, Lee wrote:
Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether
I select all (CTRL A), select the specific columns, or select the range of
cells, the Sort function under Tools is greyed out. Saving the file, closing
and reopening didn't help.
Please
Hi Joe
use the right mousebottom - on the tabulator at the screenbuttom. Select
the in the dropdown-menue insert spreadsheet - its siimilar to excel.
Franz
J Halka schrieb:
I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in
Calc. Thanks, JoeH
I have used Lotus 123 and later some Excel. How do I open a new spreadsheet in
Calc. Thanks, JoeH
Using version 3.2.1 in OoCalc, I have a list of movie names to sort. Whether
I select all (CTRL A), select the specific columns, or select the range of
cells, the Sort function under Tools is greyed out. Saving the file, closing
and reopening didn't help.
Please advise; thanks much.Lee
--
Had you meant to attach a file? Anyway, this is certainly highly unusual behavior, not at all what
I've ever seen (admittedly, I'm only a very casual user of Calc). I built a simple spreadsheet with
some empty cells and could not reproduce this behavior (Windows 7 64-bit, OOo 3.1.1). This is
Eustace wrote:
Is there a way to set my own day of week abbreviation? Instead of Mon
Tue... I would rather have MO TU... -emf
Yes there is. You first need a spreadsheet open in
OpenOffice.org. Then open Help using the F1 key. Click the Index tab
near the top. Enter sort lists in the
At 22:42 25/11/2010 -0500, Eustace Fril wrote:
Is there a way to set my own day of week abbreviation? Instead of
Mon Tue... I would rather have MO TU...
At 15:38 26/11/2010 -0500, Eustace Fril wrote:
... I have a column with dates, that use 1999-12-31 Fri in the
Format Cells - Numbers -
Wow, elegant! Thanks, Brian, for the tutorial. Tony
Is there a way to set my own day of week abbreviation? Instead of Mon
Tue... I would rather have MO TU... -emf
--
It ain't THAT, babe! - A radical reinterpretation
https://files.nyu.edu/emf202/public/bd/itaintmebabe.html
-
By solver specs I mean the data entered in the
Solver dialog box, i.e. the data labelled:
* target cell
* Optimize result to
* By changing cells
* Limiting Conditions
in that dialog box.
Unfortunately, each time I exit calc and restart with
the same file, I have to reenter this data.
Is there
Hi,
In Excel 2K3, you can right-click on the sheet navigation arrows and have
a list of all the sheets in the current workbook, so you can click on the
one you need and go there directly. It makes it easier to navigate from
one sheet to the other.
What's the equivalent in Calc?
Thanks,
L
Hi
try the navigator
press F5 key
HTH
Laurent
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Dear Laurent:
I create this easily on a regular basis in Calc, However it is not just
1 click.
I add an extra sheet at the beginning (leftmost tab) then add hyperlinks
to each of the sheets in Column B or C. Column A is a sequence number
(or a priority number) so that I can sort by
Den 2010-11-18 14:22:19 skrev L Duperval lduper...@yahoo.com:
Hi,
In Excel 2K3
Very OT:
2K3? In my world that means 2300 (except that the ”k” shouldn't be
capitalised…), like 2k3 Ω means 2,3 kΩ and so on.
Well, have a nice day.
--
Kind regards
Johnny Rosenberg
I have a set of data (from bonnie++) that represents different test cases
each with 3 samples. I would like to chart the data but average the
samples.
Subtotals and Data Pilot give me nearly what I want but not quite.
Ideally I would like to be able to paste data in one sheet and have charts
On 11/15/2010 4:53 PM, Alan Evans wrote:
I have a set of data (from bonnie++) that represents different test cases
each with 3 samples. I would like to chart the data but average the
samples.
Subtotals and Data Pilot give me nearly what I want but not quite.
Ideally I would like to be able to
Seems that's unique from Microsoft 2007, don't know on this function in Calc
till now.
Xiaoqi
On 10/30/10 6:29 AM, Phil Pinkerton pcpinker...@gmail.com wrote:
I found a way to do this using MS Excel 2007 and was looking for a way
to do the same in OpenOffice Calc.
Anyone had success
On 29/10/10 23:29, Phil Pinkerton wrote:
I found a way to do this using MS Excel 2007 and was looking for a way
to do the same in OpenOffice Calc.
Anyone had success with counting of cells of a particular color ?
Phil
Nothing's new :-) See
I found a way to do this using MS Excel 2007 and was looking for a way
to do the same in OpenOffice Calc.
Anyone had success with counting of cells of a particular color ?
Phil
-
To unsubscribe, e-mail:
On 06/10/10 18:34, JOE Conner wrote:
On 10/6/2010 10:22 AM, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
(2) When mousing over the various menus, the yellow
AG wrote:
On 06/10/10 18:34, JOE Conner wrote:
On 10/6/2010 10:22 AM, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
1. Click on the cell below and to the
On 23/10/10 20:01, Richard Detwiler wrote:
AG wrote:
On 06/10/10 18:34, JOE Conner wrote:
On 10/6/2010 10:22 AM, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains
On 10/08/2010 10:21 AM, Mike Scott wrote:
On 08/10/10 16:52, John Bowling wrote:
OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4
On openSUSE 11.3
Work fine until an update in the last few days.
Now simple calculations such as =A15+1 (in A16) will not change if the
value in A15
At 20:14 11/10/2010 -0700, John Bowling wrote:
I checked the spreadsheet that had the problem before, and
Auto-calculate was not checked. It was a sheet that had been used a
few hundred times over the last few years without changes except
data additions at the bottom. Auto-calculate had been
Den 2010-10-08 20:44:00 skrev Brad Rogers b...@fineby.me.uk:
On Fri, 08 Oct 2010 10:50:09 -0700
JOE Conner joeconner2...@gmail.com wrote:
Hello JOE,
You could have just hidden the column. FORMAT = COLUMN = HIDE.
You're right, but as the column was being used as a spacer anyway, I
opted
On Sat, 09 Oct 2010 14:57:46 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Hello Johnny,
Well, you could insert a new column and then hide it…
:-)
--
Regards _
/ ) The blindingly obvious is
/ _)radnever immediately apparent
Dream on white boy,
Hello All,
I'm trying to get text printed in a cell in Calc based on the values
found in other cells, as follows;
Col1 Col2
Row1 Cat2
Row2 Dog4
Row3 Mouse 3
The text I want to output to the result cell is from Col1, based on the
values in Col2. Specifically, the lowest value.
On 08/10/10 15:00, Brad Rogers wrote:
Hello All,
I'm trying to get text printed in a cell in Calc based on the values
found in other cells, as follows;
Col1 Col2
Row1 Cat2
Row2 Dog4
Row3 Mouse 3
The text I want to output to the result cell is from Col1, based on the
values in
OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4
On openSUSE 11.3
Work fine until an update in the last few days.
Now simple calculations such as =A15+1 (in A16) will not change if the
value in A15 changes. A16 remains the old value.
It does effect other calculations also, but
John Bowling wrote:
OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4 On
openSUSE 11.3 Work fine until an update in the last few days.
Now simple calculations such as =A15+1 (in A16) will not change if
the value in A15 changes. A16 remains the old value. It does effect
other
On 08/10/10 16:52, John Bowling wrote:
OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4
On openSUSE 11.3
Work fine until an update in the last few days.
Now simple calculations such as =A15+1 (in A16) will not change if the
value in A15 changes. A16 remains the old value.
It does
On Fri, 08 Oct 2010 15:58:57 +0100
Mike Scott m...@scottsonline.org.uk wrote:
Hello Mike,
Is vlookup() of any help? It seems in the right sort of direction
It is indeed; I don't seem to be able to get that function to do a
lookup right to left, rather than left to right, but I've overcome
On 10/8/2010 9:10 AM, Brad Rogers wrote:
On Fri, 08 Oct 2010 15:58:57 +0100
Mike Scottm...@scottsonline.org.uk wrote:
Hello Mike,
Is vlookup() of any help? It seems in the right sort of direction
It is indeed; I don't seem to be able to get that function to do a
lookup right to left,
On Fri, 08 Oct 2010 10:50:09 -0700
JOE Conner joeconner2...@gmail.com wrote:
Hello JOE,
You could have just hidden the column. FORMAT = COLUMN = HIDE.
You're right, but as the column was being used as a spacer anyway, I
opted for white on white.
--
Regards _
/ ) The
On Thursday 07 October 2010 06:22, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
(2) When mousing over the various menus, the yellow text bubble that
Hi all
I cannot figure out how to make the header on a spreadsheet bold (/ or
underlined). On a regular sheet I do the following:
Format Page Header Edit Custom Text Attributes Font Effects
Overlining Bold
But this doesn't seem to have any influence on the actual text in the
On 07/10/2010 18:57, AG wrote:
Hi all
I cannot figure out how to make the header on a spreadsheet bold (/ or
underlined). On a regular sheet I do the following:
Format Page Header Edit Custom Text Attributes Font Effects
Overlining Bold
But this doesn't seem to have any influence on
On 07/10/10 19:09, Mike Scott wrote:
On 07/10/2010 18:57, AG wrote:
Hi all
I cannot figure out how to make the header on a spreadsheet bold (/ or
underlined). On a regular sheet I do the following:
Format Page Header Edit Custom Text Attributes Font Effects
Overlining Bold
But this
On Thursday 07 October 2010 06:22, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
(2) When mousing over the various menus, the yellow text bubble that
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
(2) When mousing over the various menus, the yellow text bubble that
explains what the item does conceals the menu items
On 10/6/2010 10:22 AM, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
(2) When mousing over the various menus, the yellow text bubble that
explains what the
On Wed Oct 06 2010 10:22:48 GMT-0700 (PDT) AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
On the top of the scroll bar, just above the up arrow, you should see
On 2010-10-06 1:34 PM, JOE Conner wrote:
1. Click on the cell below and to the right of the rows and columns you
want to freeze.
2. Click WINDOW - FREEZE (or CTRL F)
Interesting, didn't know you could do it this way. Thanks!
On 06/10/10 18:34, JOE Conner wrote:
On 10/6/2010 10:22 AM, AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
(2) When mousing over the various menus, the yellow
On 06/10/10 18:36, RA Brown wrote:
On Wed Oct 06 2010 10:22:48 GMT-0700 (PDT) AG wrote:
Hello all
Two (unrelated) questions on using Calc:
(1) How do I freeze a row so that scrolling through the rest of the
spreadsheet the top/ frozen row remains visible?
On the top of the scroll bar,
On 06/10/10 18:40, Tanstaafl wrote:
On 2010-10-06 1:34 PM, JOE Conner wrote:
1. Click on the cell below and to the right of the rows and columns you
want to freeze.
2. Click WINDOW - FREEZE (or CTRL F)
Interesting, didn't know you could do it this way. Thanks!
Fascinating. Something new
On Thursday 07 October 2010 07:09, Mike Scott wrote:
On 06/10/10 18:40, Tanstaafl wrote:
On 2010-10-06 1:34 PM, JOE Conner wrote:
1. Click on the cell below and to the right of the rows and columns you
want to freeze.
2. Click WINDOW - FREEZE (or CTRL F)
Interesting, didn't know
I have a OOoo Calc file that looks fine on the screen but when I preview it,
the
page is blank. When I try to print it, I only get one blank page.
Den 2010-09-21 21:06:11 skrev Sam Warren sambookwar...@yahoo.com:
I have a OOoo Calc file that looks fine on the screen but when I preview
it, the
page is blank. When I try to print it, I only get one blank page.
Did you define a print range?
--
Kind regards
Johnny Rosenberg
Sam Warren wrote:
I have a OOoo Calc file that looks fine on the screen but when I preview it, the
page is blank. When I try to print it, I only get one blank page.
Check to see if you have a print range set, on any of the sheets in the
file. If you've set a print range on any sheet in the
I have a csv file (3 rows x 25 columns) which when I read it in,
displays across the page, as expected. But I would like to
change the display so the columns become rows, ie: so that it
displays down the page.
I am sure there is an easy way to do this, but I don't know what
it is.
bill
1 - 100 of 1849 matches
Mail list logo
