template.
For the rest, please read the help.
-
TomW
*_.
Who knows why they don't just add it to the toolbar list!
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
:
Try this function: =Exact(A2 B2;C2)
'Exact' determines if two strings are identical. I padded a space
between the two cell values to get the correct format.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
save passwords for web connections make a
difference.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
ask about a
different set that included List 1 Start and that is what I am trying
to find. I am working on something for the defaults as well.
Andy
John/Andy:
The styles in question are under 'Paragraph Styles', not 'List Styles'.
TomW
is hidden. If you unhide this row, then you can insert rows
columns.
TomW
OO3.2.0 on Vista
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Preview, but it isn't getting
me what I want. I seem to get the cells behind the graph.
Robert::
Do you have the chart area property set to Transparency. That would
let background cells show through the chart, which you do not want.
TomW
of entries.
TomW
' that MSO97 had
as feature. It allowed one to group files of different types into some
form of container. My old laptop that contains MSO97 is unavailable at
the moment.
TomW
', that the image will
behave.
TomW
obliged.
Many thanks, James
James:
By removing the 'T function, changing to a +', and defining a
currency style, the following would seem to do what you want.
+(IF(A300; STYLE(fmtWhite); STYLE(fmtCurrency)))
TomW
* And you can do the same for the 'object' of the frame.
You can now open the embedded document, by double-clicking the Icon.
This method does have some less than desirable quirks when dealing with
the frame and its object.
TomW
OOo3.1.1 on Vista Home Premium.
the character in question.
http://www.fileformat.info/info/unicode/char/2699/index.htm
TomW
the unique Items
(hiding the 0's)
TomW
you want to count.)
=sum(1/countif(ColRange;ColRange)) , then use ctrl-shift enter instead
of just enter.
This enters it as an array formula
TomW
.Opening it
OO invokes the import dialog for a tab delimited text file, and once
opened, appears to be empty. I opened it in an editor (SciTe) and found
that it contains 868,864 nulls in one line. There is no data?
TomW
,
Cor
Cor:
There has been some recent comments on the Framework list about this bug
causing random saves on large documents.
http://www.openoffice.org/issues/show_bug.cgi?id=95335
TomW
.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.
Johnny:
I found I had to exit the software, close the quickstarter. then reopen
OOO before the extension would become functional.
TomW
you want.
http://extensions.services.openoffice.org/project/AltSearch
(You need to quit the quickstarter when installing the extension.)
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e
'Count' from the
list.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
-
James:
View | Formula Bar. Uncheck it.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
-
Correction Wrong menu item.
Should be: Insert | Function List
Sorry,
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h
, or columns you want to delete.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
is treated as
text.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
information
on user-defined number formats.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
drew einhorn wrote:
Something like RCS, CVS, ...
Drew:
How about this Sun extension for document management with Alfresco:
http://extensions.services.openoffice.org/project/alfrescoconnector
TomW
-
To unsubscribe, e
David B Teague wrote:
TomW wrote:
David B Teague wrote:
I have a numbered list of items in an ODF file. How do I search for
the item numbered 10? If I use control F, type 10 for the search
key, it reports search key not found.
If you need more information to answer this, please ask
to find 1, ^11 to find 11, etc. Make
sure Regular Expression is checked in more options of the search dialog.
Of note: If you click on find All it will find all numbers that begin
with number you are searching for. e.g. ^1 will find 1, 11, 12, etc.
TomW
of Calc. I get
the same behavior as Brian with the windows version, but see your
problem on a Linux virtual machine (both 3.0.1 3.1.0)
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e
the date, but as text (left justified).
=IF(OR(CELL(Format;B4)={D1;D2;D3;D4;D5;D6;D7;D8;D9});B4;)
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
whether the devs could modify the 'Text Overflow' setting
in Options | Calc | View to not only toggle the overflow arrow when
there is data in the adjacent cell, but when there is no data in the
adjacent cells. Maybe a sub-setting of the 'Text Overflow'.
TomW
list scroll down to 'Fill Down'. Then in the Shortcut Keys
list select the key combination you want to use and press the 'Modify'
button.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e
to it by 'Customize | Function Section | Category List |
Styles. Once here find your named style and assign a shortcut key
combination. You can undo it by using the 'default formating' shortcut
Ctrl M'
TomW
-
To unsubscribe, e-mail: users
MS released earlier. They both startup okay, but I have not
experimented at all with them. Did not want to waste too much time on
the beta that will auto-self destruct when its time limit is reached.
TomW
-
To unsubscribe, e
some information as to the different types of
builds and how to parallel install versions of the same series.
http://wiki.services.openoffice.org/wiki/Product_Release/Builds_FAQ
TomW
-
To unsubscribe, e-mail: users-unsubscr
responds:
Only three possible areas to click. Right click on the bottom portion
produces nothing. No context menu. Right-clicking in the function list
window or in the little selection window above it does not produce a
context menu, either
TomW wrote:
Brewster:
Go to Insert, then un
it into a Calc cell. The latter
seems to have no effect except to open the
selection-of-function-category options.
But no context menu to be found, with any right click, anywhere in that
panel. Now what?
Brewster
Brewster:
Go to Insert, then un-check Function List
TomW
.
You can assign a keyboard shortcut to this Function.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
it to a
toolbar, if you like.
Joe
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
I hate it when RTFM sneaks up on me!
TomW
.
For issues like this, I like the 'value highlighting' option in Tools |
Options | OpenOffice.org Calc | View. Anything that is a number is a
blue font. Text is displayed in a black font. The two data types stand
out nicely.
TomW
need)
In the cell enter: =PARA/2 (This will open up the formula tool bar)
Click the green check mark on the toolbar
This will give a paragraph count without having to Preview the document.
To get an updated count: Tools | Update (or F9) as Brian suggested
TomW
un-check the
troublesome auto-correction parameters.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
complaint on the Calc issues
mailing list. there are seveal Issues filed about it.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
in Open ClipArt.
The only way I found I could keep the sub-categories is to create a new
theme for each sub-category and only load the appropriate sub-folder.
This would be a lot of work. Maybe someone else has a way to achieve this.
TomW
system is still dead, so I can't try it there.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Rogier van Vlissingen wrote:
I tried it out like this, but it does not work it gives me a #VALUE!
error.
On Mon, 12 Jan 2009 21:31:09 -0500, TomW tomw...@ctel.net wrote:
=AVERAGE(IF(ConsBillPeriods=FromPeriod;(IF(ConsBillPeriods=ToPeriod;M16:T16
it does. One could also use:
{=AVERAGE(IF(ConsBillPeriods=FromPeriod;(IF(ConsBillPeriods=ToPeriod;ETax}
Where ETax is a name range for M16:T16.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional
are the source.
TomW
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
available from Portable Apps at the following
link. It is a Portable Apps pre-release based on the 3.0 final. If you
search the Portable Apps forum there is more dialog about it.
http://portableapps.com/node/16395
TomW
, but array formulas
intrigue and baffle me I haved used them but do not fully understand
them. I usually leave work cross-eyed and brain-dead from collecting
and analyzing print attributes, etc. Sorry for the misinformation.
Back to lurking in the shadows.
TomW
this into the cell D2, the array formula will give a result of 0.2857
(rounded to 4 decimal places).
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
to repaet for each cell you want to link.
But, If you have a range you want to copy, then follow his instructions,
except use Ctrl Shift Enter, instead of just Enter. This will link the
selected range into the new sheet.
TomW
that is not subscribed. If you need to unsubscribe a
specific address, say [EMAIL PROTECTED], send a blank email to
[EMAIL PROTECTED]
If none of this helps, and you still have questions, please contact us.
end Quote
TomW
, it will take
you to where you can select the 'Extended' directory.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
the default size by:
Setting a bullet on the page.
Select the bullet.
Right click and select the 'Size' option.
Choose the size I want.
Then right click again and select 'Default Formatting'.
TomW
-
To unsubscribe, e-mail: [EMAIL
by using fields. Insert|Fields|Other (Ctrl
F2) has some of these options. Maybe some of this could be adapted.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
/documents/literature/en/L10-001_Understand_Color_en.pdf
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.6.16/1651 - Release Date: 9/4/2008 6:57 AM
This link explains the extra folder in OOo 3.0
http://blogs.sun.com/GullFOSS/entry/handling_the_dynamic_links_in
TomW
Dotan Cohen wrote:
2008/9/5 TomW [EMAIL PROTECTED]:
There appear to be two choices in doing bulk changes to your charts:
Surrender or Death?
One: Use Star Basic to manipulate the settings.
I think that OOo macros can be in Python as well, I will have to look
into that. This seems
.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
the chart xml file within the ods file. Oasis has some
literature on creating odf files from code, so I would assume one could
also modify the the file data with code.
OASIS OpenDocument Essentials - Using OASIS OpenDocument XML
http://books.evc-cit.info/odbook/book.html
TomW
to logarithmic. In
the line graph, it is grayed out.
TomW
OO2.4.1 OO3.0 on Vista
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
://www.avg.com
Version: 8.0.169 / Virus Database: 270.6.14/1647 - Release Date: 9/2/2008 6:02 AM
I have been trying out the 3.0 builds. The desktop icon will open a
dialog similar to what MS Works did (or does). It gives you a choice of
which application you want to work with.
TomW
in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.169 / Virus Database: 270.6.14/1647 - Release Date: 9/2/2008 6:02 AM
Pedro:
You have the 'Symbol' font selected for the bullet numbering. If you
change the font it will display Roman numerals.
tomW
, plus a
Google search. Some use 'v', others use the italic 'v'. It can be bold
to denote the vector. It can be capitalized to denote the vector.
Italics seems to be more common in my college texts.
TomW
-
To unsubscribe, e
06/23/2008 04:00:10
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
) If the document is unsaved, it will use the default file extension in
Options|Load/Save|Always Save as dilaog.
So if one was to set this option to a MS Office file extension, then the
e-mail button will send the file as MS Office file.
TomW
Keith:
This mirror in australia will download the 'deb' version of 2.4.0
http://mirror.pacific.net.au/OpenOffice/stable/2.4.0/
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
is considered a text file, so one would
expect it to be opened by an editor.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
commands, e-mail: [EMAIL PROTECTED]
This is the dba mailing list page.
http://dba.openoffice.org/servlets/ProjectMailingListList
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
-mail: [EMAIL PROTECTED]
There was a similar thread about this on 3/21/07.
http://www.openoffice.org/servlets/ReadMsg?list=usersmsgNo=145434
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail
TomW wrote:
Mike Field wrote:
Harold Fuchs wrote:
On 13/03/2008 14:54, Anthony Chilco wrote:
Anthony Chilco wrote:
Mike Field wrote:
Harold Fuchs wrote:
Hi Harold,
I'm using OpenOffice 2.3.1 under Windows Vista Business.
I tried to use the Paste-Special-with-shift-cells idea
Dave Barton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- Original Message
From: TomW [EMAIL PROTECTED]
Date: Wed 05 Mar 2008 13:19:22 EST
| Dave Barton wrote:
| Original Message
| From: TomW [EMAIL PROTECTED]
| Date: Wed 05 Mar 2008 10:18:17 EST
to assign keyboard
shortcuts in the Tools|Customize menu.
TomW
Using OOo2.4.0rc2 on WinXP Pro SP2
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
| Links. I copy/pasted some images into Impress and it shows links
in this dialog. You can edit the link here or break them.
TomW
Using OO02.4.0rc2 on WinXP Pro SP2
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Dave Barton wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- Original Message
From: TomW [EMAIL PROTECTED]
Date: Wed 05 Mar 2008 10:18:17 EST
| Dave Barton wrote:
| Original Message
| From: Lisi Reisz [EMAIL PROTECTED]
| Date: Wed 05 Mar 2008 04:34:52
Kurt Salentin wrote:
TomW,
could you just give me an idea about how exactly you deleted the
objects? I am at my wits' end after having tried the obvious ways.
Copying the whole chart into an empty Impress file does not change
anything.
Is there any chance of getting the issue fixed so
]
WordPerfect 12 trashs it even more than Writer. WordPad almost gets it
right.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
mis-behaved, also.
It would appear that the only way to copy titles from one chart to
another is to open the Title Dialog and copy the information from the
Title field of the first chart and paste it into the Title field of the
second chart.
TomW
!!!
http://www.ioffer.com/i/38596071;
http://cgi.ebay.com/Open-Office-Pro-2007-Instant-Download;
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
MonthName = December
end select
end function
I have used this in Excel at work. For me it was quick and simple at
the time. I am still amazed at the tricks and shortcuts I find on
websites that would never of occurred to me.
TomW
.
A manager for the OOo Recent Documents list that allows you to change
its size or clear it.
http://extensions.services.openoffice.org/project/histmngr
I have not tried it out.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED
in a cell in column T. Works of course. Then change Q16640 back to its
original form. I could then copy/paste the cell with the working
function into another cell and it would still work. But if you try to
type the function in, it will fail as usual.
A Bug?
TomW
TomW wrote:
Johnny Rosenberg wrote:
2008/2/6, Jonathan Kaye [EMAIL PROTECTED]:
Johnny Rosenberg wrote:
snip
I tried your macro and I didn't get the problems you described. It
seemed
to work perfectly. Maybe I need your whole document to evaluate what's
going on.
Sorry for the delay. I
?
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://development.openoffice.org/releases/2.4.m2_snapshot.html
is the link. I have been using this release since last week.
TomW
WinXP Sp2 OOo2.4dev
Dotan Cohen wrote:
On 18/01/2008, TomW [EMAIL PROTECTED] wrote:
Dotan:
I found that I could get your desired format (-mm-dd) in both the
cell and the input line by changing the language in the cell formatting
dialog to Swedish(Sweden). This is with my language set to US English
to format in a unique way.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
, as you can select the type of trendline(regression).
(Right clicking on the data series, while in edit mode, will also bring
up the same Statistics options, when you select the objects properties.)
TomW
WinXp2 OO2.3.0
do not use Writer very much, so this is untested.
TomW
WinXp OO2.3
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-mail on their desktops, but it bounces to
their Blackberrys, which can not handle the spreadsheet attachment.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
either.
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
it to
navigate the worksheet. And, If you type in a range (e.g. A1:A5) it
will select that range. It is a combobox control that allows you to
have a dropdown list of items to select.
TomW
-
To unsubscribe, e-mail: [EMAIL
from Lisbet Hogland
[EMAIL PROTECTED]. Her english was very broken. Maybe they need
the instructions translated??
TomW
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
.
TomW
the others. The default
for 'List 3' is the check mark on my WinXP 002.3. Just select the line
to change and double click on that style. It will change the open
bullet to a check mark. Of course these styles are configurable.
TomW
, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
This url lists all MS viewers.
http://office.microsoft.com/en-us/downloads/HA010449811033.asp
TomW
, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
PS. forgot to mention that it does not show a Pub viewer.
TomW
access to your favorites. Make Yahoo! your homepage.
Walter:
*Paste Special Link *should do it.
TomW
is: #\.#,,
The B for billion (or Billion) would have to be added to the axis
title. This can be set within the chart if you break the link to the
data for the Y-axis by un-checking the source format.
TomW
Aha, well done for finding the dodge! I'd missed that. But this
doesn't quite work for me
to a new column.
The format code is: #\.#,,
The B for billion (or Billion) would have to be added to the axis
title. This can be set within the chart if you break the link to the
data for the Y-axis by un-checking the source format.
TomW
1 - 100 of 127 matches
Mail list logo