On 1/04/2010 6:57 PM, Harold Fuchs wrote:
OOo 3.1.1 on Win XP Pro
I have a Calc spread sheet. I want each cell to be over- or under-lined (the
same for all cells but I don't mind which) to make the thing easier to read
on the printed page. I do the following:
- Select all the cells
-
Unsubscribe me!!
Stacy Fry wrote:
Unsubscribe me!!
Send an empty email (Just click the link below to open a new email
message and then click the Send button.) When you get the email
confirming that you want to unsubscribe from this list, click the Reply
button to open a new email message and click the
I'm using Open Office 3.1 and trying to set borders around various cells. I
found the border presets, but I don't find any way to set single borders,
e.g., top, right, left, or bottom. Is there any other place I should be
looking at to do this? If I open a compatible Excel file where
On 05/07/09 11:33, Dotan Cohen wrote:
I'm using Open Office 3.1 and trying to set borders around various cells. I
found the border presets, but I don't find any way to set single borders,
e.g., top, right, left, or bottom. Is there any other place I should be
looking at to do this? If I open
Harold,
Thanks for the info. I did pull up the dialog box (see attached file).
The default group of settings for the borders are what I call the
presets, as it places the borders around the cells as shown in the
picture. I played with it some more after I sent in the question and
found
Chris Taylor wrote:
Hi I have a Calc file that I need help with please
I have a cell O13 that has the formula =K13*M13 output fine but what I
would like is when K13 or M13 is blank then O13 is blank
Eg
2Hrs(K13)19.26(M13)38.52(O13)
(K13) (M13) (O13)
Thanks
Chris
In cell O13
Hi Chris
is there a BLANK or EMPTY normally I use this (in German)
=wenn(oder(glätten(k13)=;glätten(M13)=); ;K13*M13). With this
formula you get a BLANK in the cell, else you the result of the product.
wenn - if
glätten - trim
oder - or
I hope the translation of the terms is right
Franz
You could do some thing like:
=CONCATENAR(Option ;M33)
(my version of OO is in Spanish, but I think you could find that function
easily)
Hope it helps.
Ely
2008/8/21 Mark Knecht [EMAIL PROTECTED]
Hi,
I'm looking at a prebuilt spreadsheet in Excel and trying to
duplicate some of its
Hi Mark,
The author of the original spreadsheet probably used conditional formatting. The
cell is hidden if M33 is zero.
tc
Mark Knecht wrote:
Hi,
I'm looking at a prebuilt spreadsheet in Excel and trying to
duplicate some of its functionality in OOCalc. I'm having trouble with
one
Anthony,
Thanks. That does seem to be what he did. In his spreadsheet the
cell evaluates to 'Option 0'. In another cell elsewhere ($B$99) he
wrote out 'Option 0' and on this cell he has conditional formatting
such that if this cell has the same text as $B$99 then the font is
written in the
:41 AM
To: users@openoffice.org; [EMAIL PROTECTED]
Subject: Re: [users] Cell formatting question
Anthony,
Thanks. That does seem to be what he did. In his spreadsheet the
cell evaluates to 'Option 0'. In another cell elsewhere ($B$99) he
wrote out 'Option 0' and on this cell he has
or select from a drop down list (which is held in
a hidden column).
Haven't done this in OOo.
-Original Message-
From: Mark Knecht [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2008 11:41 AM
To: users@openoffice.org; [EMAIL PROTECTED]
Subject: Re: [users] Cell formatting question
Mark Knecht wrote:
Hi,
I'm looking at a prebuilt spreadsheet in Excel and trying to
duplicate some of its functionality in OOCalc. I'm having trouble with
one formatting issue. In Excel there is a cell that has the following
contents:
=Option M33
M33 is a cell that contains a number from
Dave Craven wrote (21-8-2008 22:05)
Another option (in M$ Excel) is Data Validation which forces the user
to leave a cell blank or select from a drop down list (which is held in
a hidden column).
Haven't done this in OOo.
Data|Validity ... Allow ... make your choice
Tab Error alert Check
At 09:17 10/04/2008 +0100, João Pinto wrote:
I would like to know if anyone can help me with
a capacity problem that i have found in openoffice calc.
So, i want to convert in my work some
Hexadecimal serials numbers, but calc only
supports 15 digits as processed numbers, is ti
possible to
Brian Barker wrote:
At 09:17 10/04/2008 +0100, João Pinto wrote:
I would like to know if anyone can help me with a capacity problem
that i have found in openoffice calc.
So, i want to convert in my work some Hexadecimal serials numbers,
but calc only supports 15 digits as processed numbers, is
On Tue, 27 Nov 2007 12:32:57 -0800 (PST)
pre [EMAIL PROTECTED] wrote:
do u have a version for pda/smart phones
No.
--
MELVILLE THEATRE ~ Melville Sask ~ http://www.melvilletheatre.com
-
To unsubscribe, e-mail: [EMAIL
- Original Message -
From: pre [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Tuesday, November 27, 2007 9:32 PM
Subject: [users] cell
do u have a version for pda/smart phones
thanks
-Drew Ellis
- Original Message -
From: Frank Cox [EMAIL PROTECTED]
To: users@openoffice.org
Cc: pre [EMAIL PROTECTED]
Sent: Wednesday, November 28, 2007 5:50 PM
Subject: Re: [users] cell
On Tue, 27 Nov 2007 12:32:57 -0800 (PST)
pre [EMAIL PROTECTED] wrote:
do u have a version for pda
Thankyou for sharing how you solved the problem, this may help
somebody in the future.
Tom
On 20 Mar 2007, at 20:07, David Higginbotham Sr. wrote:
Hi again,
while inserting the new columns I didn't notice that the color
box format were also keeping up with want I had in the header
Dries Pruimboom wrote:
Hello List,
I would like to set the cell color via the cell value, i know about the
conditional formatting feature, but i would like to do it in a smooth way.
What
i would like to do is something like this :
CellBGColor=rgb(CellValue,0,255-CellValue)
On Thu, 2007-01-11 at 12:40 +, Dries Pruimboom wrote:
Hello List,
I would like to set the cell color via the cell value, i know about the
conditional formatting feature, but i would like to do it in a smooth way.
What
i would like to do is something like this :
On Thu, 2006-02-09 at 16:37 -0500, CarlP wrote:
Is there a way to format a cell border at page breaks so that those
cells get a given border regardless of what specific cell formatting
might be there? In part I'm hoping to force cell borders at the bottom
and top of pages so that I don't
On Thu, 2006-02-09 at 16:37 -0500, CarlP wrote:
Is there a way to format a cell border at page breaks so that those
cells get a given border regardless of what specific cell formatting
might be there? In part I'm hoping to force cell borders at the bottom
and top of pages so that I don't
On Fri, 2005-11-04 at 09:30 -0500, [EMAIL PROTECTED] wrote:
Are you on OOo 2.0? If so, check to see if you have the Help tool
tips enabled. (Tools Options OpenOffice.org General. Then see if
Tips is checked. If it is not checked, check it.)
There's either a very odd feature or else a
Are you on OOo 2.0? If so, check to see if you have the Help tool
tips enabled. (Tools Options OpenOffice.org General. Then see if
Tips is checked. If it is not checked, check it.)
There's either a very odd feature or else a bug that makes it so that
if you do not have Tips checked, you
On Fri, 2005-11-04 at 09:30 -0500, [EMAIL PROTECTED] wrote:
Are you on OOo 2.0? If so, check to see if you have the Help tool
tips enabled. (Tools Options OpenOffice.org General. Then see if
Tips is checked. If it is not checked, check it.)
There's either a very odd feature or else a
Hi Ron,
[EMAIL PROTECTED] wrote:
My operating system is Windows XP pro-- using OO 1.1.1
I cannot get background color to display in cells of a spreadsheet. I
think I am following the general rule: select the cells, FORMAT, chose CELLS,
click
BACKGROUND tab, select a color, click
Its works fine for me even on OpenOffice 1.1.0 , 1.1.4, 1.9.74 on Win
Xp
Thanks and Regards,
Nagashree
[EMAIL PROTECTED] 02/11/05 3:05 PM
Hi Ron,
[EMAIL PROTECTED] wrote:
My operating system is Windows XP pro-- using OO 1.1.1
I cannot get background color to display in cells of a
Nick Cooper wrote:
Thanks for the reply, I have gone from OOo 1.1.3 to 1.1.4, and used the
same method as Brian suggested, but still the same problem!
Do what you already said you have done.
After you have set up the links and saved. Go to the sheet that needs to
be updated and choose *Edit
Nick Cooper wrote:
Thanks, but is there an answer to the fact that my imported Excel
Spreadsheet docs have many links that worked between documents, but
weren't DDE, so now don't link unless I change all the formulae? In
other words can I mass update my links??
What about find Replace?
--
Thanks, but is there an answer to the fact that my imported Excel
Spreadsheet docs have many links that worked between documents, but
weren't DDE, so now don't link unless I change all the formulae? In
other words can I mass update my links??
Brian wrote:
Nick Cooper wrote:
When you have used
Nick Cooper wrote:
Thanks for the reply, I have gone from OOo 1.1.3 to 1.1.4, and used
the same method as Brian suggested, but still the same problem!
Can you open a new spreadsheet and duplicate the problem - ie, is it
reproducible?
Sounds like another case of we need the actual file. If you
Nick Cooper wrote:
Thanks for the reply, I have gone from OOo 1.1.3 to 1.1.4, and used
the same method as Brian suggested, but still the same problem!
Can you open a new spreadsheet and duplicate the problem - ie, is it
reproducible?
Sounds like another case of we need the actual file. If you
Nick Cooper wrote:
Thanks for the reply, I have gone from OOo 1.1.3 to 1.1.4, and used the
same method as Brian suggested, but still the same problem!
Any ideas anyone?
Original Message
Subject: Re: [users] Cell linked to another in another sheet does
not update
Date
When you have used the Excel technique (same as me) how does the formula
in the formula bar of your result cell look? Does it start:
{=DDE(soffice,
or does it start:
='file:///...
Reason for asking is that I get the link to work automatically when I
make the link by doing:
Source cell:
Nick Cooper wrote:
This problem seems so basic that I must be missing something!...
I'm an experienced Excel user (to a basic level), but new user of Open
Office, forgive me!
In Open Office, if I open Sheet 1 and Sheet 2, and make a cell in Sheet
1 refer to a cell in Sheet 2, it works OK. But
Nick Cooper wrote:
When you have used the Excel technique (same as me) how does the
formula in the formula bar of your result cell look? Does it start:
{=DDE(soffice,
or does it start:
='file:///...
Reason for asking is that I get the link to work automatically when I
make the link by
39 matches
Mail list logo