What is overline that must be typed? What does it look like? Where on a US
keyboard is it?
Given that the OP asked how to achieve overlining, saying type overline is
sort of begging the question.
Harold Fuchs
London, England.
- Original Message -
From: Dan Lewis [EMAIL PROTECTED]
It's not the first time that I hera from this problem, so it might be, that
the program has bug. But that would have to be tested.
Meanwhile try various forms to write the condition:
mydb.gifts.address2 EQ
[mydb.gifts.address2] EQ
![mydb.gifts.address2]
NOT [mydb.gifts.address2]
and also
SEE INLINE RESPONSE
Uwe Fischer wrote:
Joe Conner wrote:
I use a high speed continuous cable
connection to the internet. WinXP Pro, OOo2.0.3.
I have a font package on my desktop that I would like to install. When
I activate the wizard "Install Fonts From The Web" nothing is
HERE IS A MAJOR ISSUE (or is it just me making an error?)
OO version 2.0 Calc (using = 'file://.) will now reference another Calc
file to bring in the results of a formula from there. (Version 1 would not do
this, it only worked from another sheet within the same file.)
However, if there
Hi Harold
What is overline that must be typed? What does it look like? Where on
a US keyboard is it?
This means type the word overline. It is not a special character.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
On Windows the following seems to work:
At the point where you want the overlined text do Insert/Object/Formula. A
box (the Formula Editing box) will appear below your document, which will
shrink to accommodate it.
Right click in this box and, from the menu that opens, choose Attributes and
Ah. Sorry. Thank you.
Regards, Harold
- Original Message -
From: Walter A. March [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Thursday, July 27, 2006 3:31 AM
Subject: Re: [users] Overline?
Dan Lewis wrote:
On Wednesday 26 July 2006 07:09 pm, Pete Holsberg wrote:
Sigrid
Using curly braces ({ and }) round the text allows multiple words to be
overlined (as per other respondents).
Typing the word overline into the formula editing box saves right clicking
and selecting Attributes/Overline.
Harold Fuchs
London, England
- Original Message -
From: Harold
Hi again Harold
Unfortunately only a single word can be overlined in this way. Nothing
after the first space in what you type gets overlined.
Try this.
In a word document, type the following sentence exactly as it appears.
overline {This sentence is overlined.}
Select the whole sentence.
Adrian,
On my system (Win XP Pro/SP2) the spaces between the words are *removed*
from the overlined text.
So, if I follow your example exactly, I get overlined
Thissentenceisoverlined.
I also sent a message saying that curly braces allow multiple words. Seems I
have to retract ... I was
Hi,
Harold Fuchs wrote:
Adrian,
On my system (Win XP Pro/SP2) the spaces between the words are *removed*
from the overlined text.
So, if I follow your example exactly, I get overlined
Thissentenceisoverlined.
normal text automatically gets italic font (where spaces are hard to
see) in a
Adrian,
Also I've discovered that the word and is replaced by a circumflex (^) and
the word or by an upside-down circumflex (not sure how to achieve that on my
keyboard). Possibly other mathematical or logical words are replaced too.
The following, for example: overline {these words are
Hi Royce,
On Thu, Jul 27, 2006 at 19:20:16 +1000, Royce Faye Green wrote:
OO version 2.0 Calc (using = 'file://.) will now reference another
Calc file to bring in the results of a formula from there. (Version
1 would not do this, it only worked from another sheet within the same
file.)
Hi again
Also I've discovered that the word and is replaced by a circumflex
(^) and the word or by an upside-down circumflex (not sure how to
achieve that on my keyboard). Possibly other mathematical or logical
words are replaced too.
(other good examples of the minus symbol, and over
Hi Mike,
On Sat, Jul 22, 2006 at 09:30:25 -0400, Mike Masse wrote:
I have a drop down list in one of my calc sheets. When used the list is
dropped down, I have 2 issues ... probably related. First the text is
too small. Is it formatted the same as any other text? or is it
formatted
Royce,
I've tried to reproduce the situation you described in your mail an found no
problems.
I created 2 calc-sheets. In the 1st I then put some numbers like this:
1 2 3 4 5
2 3 4 5 6
3 4 5 6 7
4 5 6 7 8
5 6 7 8 9
and totalled them in a row below them. After that I saved the sheet. In the
Hi Senectus,
On Sat, Jul 22, 2006 at 21:51:28 +0800, Senectus . wrote:
I've never used excel very much, but I have need of some calc trickery
I need calc to look through all the cells and when it finds a cell
with a variable I wish to set, it will then delete that entire row.
You may use the
On Thu, 2006-07-27 at 21:38 +1000, Adrian Try wrote:
Hi again
Also I've discovered that the word and is replaced by a circumflex
(^) and the word or by an upside-down circumflex (not sure how to
achieve that on my keyboard). Possibly other mathematical or logical
words are
The following showed up in my personal mailbox and it is a question
better suited to the list.
Forwarded Message
From: david patterson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Comment/suggestions for the User Guide
Date: Thu, 27 Jul 2006 13:27:30 +0100
How do I save
Leonard T Greenland wrote:
I teach one course in which the students write a VB6 interface to
connect to a database. I have not been able to figure out how to
connect VB6 to the OpenOffice database.
OOo does not have an ODBC driver, so your only option would be to
connect to OOo using the
I will assume, therefore, that Mr. Patterson is not subscribed to the
mailling list and CC him on my reply.
Mr. Patterson, please reply directly to the list, you are more likely to
receive a reply.
I assume that you are running using Write.
While editing the document, you must then save the
I have a cell (D28) in sheet1 that I have given the value of 15 and the name
of OLD. I can pick up this value in sheet2 by using $SHEET1.D28 but I can't
seem to be able to use the name OLD. I tried $SHEET1.OLD and $SHEET1.$OLD and
$SHEET1.'OLD' none of these are correct. Would someone be kind
Mac,
Just type
=old
in the cell that you want to display the value. In my case (OO0 2.0.3 on WinXP)
it returned the value of the cell I called old.
Arnold Huzen
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Please note that users@openoffice.org is a mailing list and the best
email address you can use when you have a users problem or question
about OpenOffice.org. However please note that it is a moderated email
list and most replies *only* go to the mailing list so you should really
consider
Hello.
Subject says it all - I have subtotalled some data and need to copy
subtotals sans original data.
Any way of doing that in Calc?
Thanks a lot.
WBR,
K. Palagin.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Kirill S. Palagin wrote:
Hello.
Subject says it all - I have subtotalled some data and need to copy
subtotals sans original data.
Any way of doing that in Calc?
Thanks a lot.
WBR,
K. Palagin.
Kirill:
Do you mean you need to only copy the number, and not the formula?
If so, try copying
How do I get my document to print page numbers, starting on the third
page, but starting with the number one instead of three and incrementing
from there?
Thanks
Mate
--
Careful. We don't want to learn from this. -- Calvin
To have no numbers on the first two pages, with numbers starting on the third
page, you need to use page styles. I'll assume you have some knowledge of page
styles; if not, there is good documentation describing how to use page styles
in the Users' Manual, and in OOoAuthors.
Create a style
On Thursday 27 July 2006 08:44 am, √Mate wrote:
How do I get my document to print page numbers, starting on the
third page, but starting with the number one instead of three and
incrementing from there?
Thanks
Mate
You do this with Page styles. It would be best to study the
chapter
Paste special is not doing what I want (or I am not using it
correctly). Let me give an example. Subtotalling the following table
ProdA 5
ProdA 7
ProdA 3
ProdB 1
ProdB 4
ProdB 2
will add following rows
Subtotal ProdA 15
Subtotal ProdB 7
Grand Total 22
When I select outline
Hi Claudia,
Thanks for the tips! Unfortunately, none of the mentioned workarounds
actually worked. I have submitted a bug and a test case for this at:
http://www.openoffice.org/issues/show_bug.cgi?id=67843
-Roberto.
On 7/27/06, Claudia Drechsle [EMAIL PROTECTED] wrote:
It's not the first
Roberto Aguilar wrote:
Hello,
I am printing out envelopes and am trying to hide address2 if the
entry does not have a sub-address.
First, my data is from postgres, which is linked to OO Base using jdbc.
In:
Tools - Options - Openoffice.org Base - Databases I give the db a
name mydb.
Manfred Moser wrote:
Hi!
I am having trouble getting links to bookmarks in odt files to work. I
would like to be able to have a url link in an external html document
that links directly to a section or bookmark within OO. So when a user
click on a link the document opens (potentially after
I have a document in which I want to merge two adjacent cells (within
once column). When I select the two cells, the Merge Cells option isn't
available (grayed out).
The document has Record set for tracking changes, and I've typed into
the first cell. Finally, it's an Excel 97 formatted
Kirill S. Palagin wrote:
Paste special is not doing what I want (or I am not using it
correctly). Let me give an example. Subtotalling the following table
ProdA 5
ProdA 7
ProdA 3
ProdB 1
ProdB 4
ProdB 2
will add following rows
Subtotal ProdA 15
Subtotal ProdB 7
Grand Total
CarlP wrote:
Roberto Aguilar wrote:
Hello,
I am printing out envelopes and am trying to hide address2 if the
entry does not have a sub-address.
First, my data is from postgres, which is linked to OO Base using
jdbc. In:
Tools - Options - Openoffice.org Base - Databases I give the db a
Hi Carl,
There are no special characters; the field names are plain ascii.
I have turned off hidden paragraphs in the view menu.
Also, I was able to reproduce the problem without the JDBC connection.
The testcase files are in the issue I mentioned earlier:
That's a good one, but I have eliminated that possibility as well. :
) Check out the test case; it would be nice if I can confirm I'm not
the only one having this problem.
-Roberto.
On 7/27/06, CarlP [EMAIL PROTECTED] wrote:
CarlP wrote:
Roberto Aguilar wrote:
Hello,
I am printing out
Another possibility I thought might work is as follows:
1. Type the text you want overlined.
2. Highlight it.
3. Do Format/Paragraph/Borders; choose a line style that suits and a border
that is only on top of the paragraph.
This fails because it overlines the *whole* line instead of merely
-Original Message-
From: Harold Fuchs [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 11:51 AM
To: users@openoffice.org
Subject: Re: [users] Overline?
Another possibility I thought might work is as follows:
1. Type the text you want overlined.
2. Highlight it.
3. Do
I'll try to mimic what you've done when I get a chance.
Roberto Aguilar wrote:
That's a good one, but I have eliminated that possibility as well. :
) Check out the test case; it would be nice if I can confirm I'm not
the only one having this problem.
-Roberto.
On 7/27/06, CarlP [EMAIL
I tried on my PC, opened up a Writer-doc and typed (c), and voila... ©
came up by it self...
I have OOo 2.0.3 (Swedish), Win XP Home-edition.
try, (c) in Writer, maybe it is in your auto-correct list already.
// Per
Johnny Andersson skrev:
Keep Alt hold and press 0169 (numeric keypad
Hi CarlP,
On Thu, Jul 27, 2006 at 12:19:52 -0400, CarlP wrote:
After trying a few tests, it seems like for either file type, the merge
cells option is unavailable if record changes is turned on. Can
someone confirm this problem for me, and is it a bug? Or is it by
design (or design
OK, I took a quick look, and on a PC (WinXP) I see a mix of line breaks
and paragraph ends for each line of the address window when I turn on
the non-printing characters. The Hidden paragraph line has a line break
character and not a paragraph end character at the END of it, so I
wonder (this
Eike Rathke wrote:
Hi CarlP,
On Thu, Jul 27, 2006 at 12:19:52 -0400, CarlP wrote:
After trying a few tests, it seems like for either file type, the merge
cells option is unavailable if record changes is turned on. Can
someone confirm this problem for me, and is it a bug? Or is it by
Hi Carl,
Excel 97 works in the same manner: if track changes is on, merge cells
is inactive.
tc
CarlP wrote:
Eike Rathke wrote:
Hi CarlP,
On Thu, Jul 27, 2006 at 12:19:52 -0400, CarlP wrote:
After trying a few tests, it seems like for either file type, the
merge cells option is
I have filed issue on this topic.
Please see
http://qa.openoffice.org/issues/show_bug.cgi?id=67851
Circled in blue on subtotals.GIF is outline level 2.
Thanks.
WBR,
K. Palagin.
-Original Message-
From: Immanuel CRC Office [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 8:21
I have just started to try and do a 'show' (for want of a better word) with
IMPRESS. My wife users M$ Powerpoint. When she does a presentation, it has
a very handy 'timebar' with the effects and this enables her to time the
presentation with an MP3 song or whatever. I have tried to find this
Is there a way to control how often an x axis label is displayed? I
have bar charts containing data every 15 minutes of the day and would
like only every 4th bar labeled. i.e., every hour.
-
To unsubscribe, e-mail: [EMAIL
The link at the bottom of this message doesn't work for me.
Leonard
- Original Message -
From: David Bird [EMAIL PROTECTED]
To: users@openoffice.org
Sent: Friday, July 28, 2006 7:56 AM
Subject: [users] Impress timebar anyone?
I have just started to try and do a 'show' (for want of a
I wasn't sure how hidden paragraphs worked and believed that the
condition itself would control the insertion of address2, so it is
missing altogether. But, that's not the problem, doh! Or, at least,
I'm still running into the problem.
I've outlined some more observations in the issue:
For those who are familiar with M$ Excel, I can, I think express what we
are trying to do.
We do our subtotal and then collapse the outline so that only the
subtotal and grand total lines are displayed.
Now we select the data. In Excel, our next step would be Edit Go To.
Click Special.
Manfred Moser wrote:
Manfred Moser wrote:
Hi!
I am having trouble getting links to bookmarks in odt files to work.
I would like to be able to have a url link in an external html
document that links directly to a section or bookmark within OO. So
when a user click on a link the document
Same results as Arnold (IE works as expected) on my OOo 2.0.3 on Windows
2000 Professional.
WalterAM
[EMAIL PROTECTED] wrote:
Royce,
I've tried to reproduce the situation you described in your mail an found no
problems.
I created 2 calc-sheets. In the 1st I then put some numbers like this:
THank you Arnold Walter; I am using Windows XP Home. I now see that my
previous error was in not first saving the target sheet 'A' before using it
as the source for the formulas in spreadsheet B. This morning, when I
re-opened my system and the Calc sheets, I answered 'Yes' to the Refresh
Hello Eike; Thank you for your concern suggestions seeking clarification.
The problem is now solved, but I shall respond here to your questions, just
in case they are still relevant:
The space between the file's URL and #$... is just a typo in your mail,
I guess. Did you copy the formula from
You nailed it! Pitty that Calc can't do that.
As a way of doing that OOo could have an option of copying results to
separate location.
-Original Message-
From: Walter A. March [mailto:[EMAIL PROTECTED]
Sent: Friday, July 28, 2006 5:39 AM
To: users@openoffice.org
Subject: Re:
57 matches
Mail list logo