Am Montag, 30. April 2007 schrieb Victor Blakey:
I am running a small business dealing with local councils.
all our invoices are created in open office and converted to word .doc
documents for emailing to our customers.
However last year (at around aboput the time we upgraded to open office
Victor,
Mark has obviously seen this type of problem before, as have I.
If the .dat file is named winmail.dat then it I would take a bet that
your email client is M$ Outlook. If so, then that is the problem and
would explain why there was no problem when emailing to your own
machines. You need
2007/4/30, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Hi Guy,
Thanks for your help. I got it to work. As an ordinary user (not very
technical) I find the how-to information a little hard to understand.
For example:
1.1 Installing X11
What is X11 ? : a graphic server that displays clients. Given
2007/5/1, [EMAIL PROTECTED] [EMAIL PROTECTED]:
Dear Sir's,
I have been recommended to use your Open Office .org. program
which I was informed ,was Free to use, instead of Excel and that
yours was better and easier to use.
However, I just can't seem to get to the area or place, where I
Sirs:
When using triple hyphens to add a line under a paragraph the results are
unpredictable. Sometimes there is one line, sometimes three. Sometimes one or
two can be removed, sometimes not. The lines put in by the Word feature are not
retained correctly and there appears to be no such
Hi, I've to buy a new computer with Windows Vista as operating system:
Does openoffice works with windows Vista?
Thanks...
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
no, as far as I can tell they are arriving with the original file name
(invoicexxx.dat instead of invoicexxx.doc)
Dan Lewis wrote:
On Tuesday May 01 2007 6:27 pm, Mark Pope wrote:
Hello Victor,
Are these .dat file attachments actually named winmail.dat?
-Original Message-
Hi,
I am just wondering if I can install open office in one main server and
use openOffice in several client machine without installing each one..
My basic idea is that, using java code to implement OpenOffice in online
and use share this component with other who comes to my web and try to
Sirs:
Accessing the forums is very confusing. I can't even tell where this email
is going.
Nevertheless, I cannot turn off the Autocorrect in OO 2.2. Two other users
reported this but there were no answers offered. My technical document is
almost unreadable because of all the
I have installed open office 2 to try and wish to uninstall. Where are the
uninstall files. There is nothing inWindows xp uninstall
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.6.2/782 - Release Date: 5/1/2007 2:10
AM
Hello
I've just found you and note that there's references to associating with MS
Office files etc. I don't have MS programmes. Do I need MS (or other, such as
Ability Write) before I can use Open Office?
I await
D.B.Chapman
__
This email
No, you do not need any Microsoft software to use OpenOffice.
What you can do is set OpenOffice to open .doc, .xls and .ppt by default
(and you do not need anything extra for that too).
-Original Message-
From: David B. Chapman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007
2007/4/30, Akash Dhama [EMAIL PROTECTED]:
Is the new version of X11 2006 which is available from MAC S/w update
compatible with Openoffice 2.2 I remember last time I downloaded a
new verson of X11 I could not use openoffice
Hello
Since you're using OpenOffice.org 2.2, I suppose your
Hello.
I have two password-protected spreadsheets. One spreadsheet references
cells in the other spreadsheet and if source is closed then Calc would
not ask for a password.
Is there any workaround (while we wait for issue 24535 to be fixed)?
Thanks.
WBR,
K. Palagin.
Paul Palmer wrote:
Nevertheless, I cannot turn off the Autocorrect in OO 2.2. Two other users
reported this but there were no answers offered. My technical document is
almost unreadable because of all the corrections.
I tried Word 2000 and found it hardly better. It would be wonderful if
On 5/2/07, Paul Palmer [EMAIL PROTECTED] wrote:
Sirs:
When using triple hyphens to add a line under a paragraph the results are
unpredictable. Sometimes there is one line, sometimes three. Sometimes one or
two can be removed, sometimes not. The lines put in by the Word feature are not
2007/5/2, Ben Newman [EMAIL PROTECTED]:
make sure you have x11 version at least 1.1 installed. it's on your Mac Os X
installation CD under the optional installation package part.
--b
On 4/30/07, Douglas Williamson [EMAIL PROTECTED] wrote:
I have an icon, but nothing happens when I click it.
Try adjusting the settings in
Tools-Options-Language Settings-Writing Aids
HTH,
Donald.
Paul Palmer wrote:
Sirs:
Accessing the forums is very confusing. I can't even tell where this email
is going.
Nevertheless, I cannot turn off the Autocorrect in OO 2.2. Two other users
reported
David B. Chapman wrote:
Hello
I've just found you and note that there's references to associating with MS
Office files etc. I don't have MS programmes. Do I need MS (or other, such
as Ability Write) before I can use Open Office?
I await
D.B.Chapman
No, when you install OpenOffice,
On Tuesday May 01 2007 9:09 pm, Ken Paulusma wrote:
I have installed open office 2 to try and wish to uninstall. Where
are the uninstall files. There is nothing inWindows xp uninstall
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database:
[EMAIL PROTECTED] wrote:
Hi, I've to buy a new computer with Windows Vista as operating system:
Does openoffice works with windows Vista?
Thanks...
Yes.
--
Use OpenOffice.org http://www.openoffice.org
-
To unsubscribe,
On Wednesday May 02 2007 3:21 am, klick Computerkurse1 wrote:
OpenOffice.org (OOo) has a version for Apple. Go to
http://porting.openoffice.org/mac/ for more information and
installation instructions. The latest version of OOo only works with
OS X 10.4 or later.
Dan
On Wednesday May 02 2007 4:22 am, [EMAIL PROTECTED] wrote:
Hi, I've to buy a new computer with Windows Vista as operating
system: Does openoffice works with windows Vista?
Thanks...
Yes, OpenOffice.org works with Vista. In fact, the latest version
has some enhancements so that it will
Ferry Wijaya wrote:
Dear Sir/Madam,
How to get manual book of Open Office 2.2? My Customer want to buy it. How
much does it cost?
One good book is the OpenOffice 2 Guidebook.
http://openoffice.blogs.com/bookresources/
--
Use OpenOffice.org http://www.openoffice.org
Dan Lewis wrote:
On Saturday April 28 2007 4:30 pm, Sonny George wrote:
Hi,
I am a new user of OpenOffice. THe deatils of version etc are given
below
OpenOffice.org 2.1
OS - Windows XP sp2
A document created using Writer wherin I have cut and pasted text
from different e mails
Thank you for office one,But, how do I get spell checker to operate.
Alistair Fyfe
On Wednesday May 02 2007 5:02 am, Alistair Fyfe wrote:
Thank you for office one,But, how do I get spell checker to
operate. Alistair Fyfe
Use the F7 key or click the icon with the abc and a wavy red line
under these three letters.
What language are you using? The English version of
Paul Palmer escribió:
I can't see how to put a box
around a paragraph or a simple line under it or over it or on the
side of it.
Have you tried to right click on a paragraph, on the menu select
paragraph, in the window that should appear choose the border tab and
play a little with it.
You
Hi there.
I'd like to make a Makro that delete some rows wich are not used.
I made it as far as shown below.
Unfortunatly I have no proper Syntaxdokumentation so I tried
SetCellByPosition (similar to GetCellByPosition) but it does not work.
Can anybody tell me, how to manipulate the row marked
Hi,
Suppressing the blank line in an address when the Address2 field is
empty comes up a lot. I've written up how to do it using conditionally
hidden sections and posted it on my blog.
http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html
I assume it's been explained on this
Victor,
Is there any chance you could create a fake invoice, put it through
the conversions and send it through to my email address using the
same process you do with the others? I'd be interested to see what
come through.
On 02/05/2007, at 5:24 PM, Victor Blakey wrote:
no, as far as I
Alistair Fyfe wrote:
Thank you for office one,But, how do I get spell checker to operate.
Alistair Fyfe
Hi Alistair,
Try File - Wizards - Install new dictionaries.
If you want, you can also install the dictionary manually. Instructions
on how to do this are at
On Wednesday May 02 2007 6:40 am, Solveig L Haugland wrote:
Hi,
Suppressing the blank line in an address when the Address2 field is
empty comes up a lot. I've written up how to do it using
conditionally hidden sections and posted it on my blog.
yes it is - I've used it several times successfully after installing
the X11 update
Chris Powell
On Apr 29, 2007, at 11:38 PM, Akash Dhama wrote:
Is the new version of X11 2006 which is available from MAC S/w
update compatible with Openoffice 2.2 I remember last time I
downloaded a new
klick Computerkurse1 wrote:
There was no message.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Thank you very much. The one set of instructions I had found was not
working for me, but the topic,
http://www.oooforum.org/forum/viewtopic.phtml?p=179672#179672 does -
kinda
So, at least I am headed in the right direction. I really want to
install without using a GUI... a scriptable
Am trying to open MS Access database in Office Base and is asking me to
install Java Runtime Environment. Even it is refusing to create a new
database. How can I proceed? Thanks
_
FREE pop-up blocking with the new MSN Toolbar -
lan huong wrote:
Dear Sir/Madam,
I am using Open Office 2.0 and my problem is:
1. When I open an Microsoft Office document with Open
Office 2.0, all comments in the document show as
notes, and I cannot delete the notes. Please tell me
how to delete notes? Your support page tells me how to
Peter Hillier-Brook wrote:
lan huong wrote:
Dear Sir/Madam,
I am using Open Office 2.0 and my problem is:
1. When I open an Microsoft Office document with Open
Office 2.0, all comments in the document show as
notes, and I cannot delete the notes. Please tell me
how to delete notes? Your
On Wednesday May 02 2007 10:21 am, Joe Grech wrote:
Am trying to open MS Access database in Office Base and is asking
me to install Java Runtime Environment. Even it is refusing to
create a new database. How can I proceed? Thanks
One place to get JRE is www.java.com. Download and
On Wednesday May 02 2007 10:53 am, Michele Zarri wrote:
Peter Hillier-Brook wrote:
lan huong wrote:
Dear Sir/Madam,
I am using Open Office 2.0 and my problem is:
1. When I open an Microsoft Office document with Open
Office 2.0, all comments in the document show as
notes, and I
Victor Blakey wrote:
I am running a small business dealing with local councils.
all our invoices are created in open office and converted to word .doc
documents for emailing to our customers.
However last year (at around aboput the time we upgraded to open office
v2.0) our customers started
Hi,
I have a problem opening a Calc document in Excel. In Calc, I've put a
page break so my sheet is printed in two pages. But when I open my
document in Excel, the page break is gone and it prints the whole sheet
on one page.
Is this a compatibility problem between Calc and Excel or is
Is Open Office compatible with Windows Vista Home Proffesional Edition?
Please reply as soon as possible seeing as I am hoping to install it as soon as
I can.
Thanks
Harry Jeffery
_
Try Live.com - your fast, personalized homepage
In a Cashbook workbook I and friends have created, in Excel the line
=HOOKUP($L$4,Summary!$R$4:SAC$35,21,False) acts as follows in the
Reconciliation Sheet.
$L$4 is the location of the Month to which you wish to tally to
Summary is the sheet from which that data is coming
$AC$35,21 guides to the
Hi,
I am using Mac OS X (Tiger) and have x11 installed.
Downloaded the latest Open Office 2.2 and followed the instruction,
dragging to the Application folder.
Once I double-clicked the OO, it does not fire up. Nothing happen. I
can't quit OO although I can quit x11. I need to force-quit
I use Open Office. Sometimes upon opening attached files I send/receive, they
are encrypted.
Please help.
Leslie Dailey
I am using version 2.2 of OpenOffice.org. I have learned through the
help system how to turn off the automatic changing of the date on
formatted documents in Writer. Do I really have to do this on EACH
document, or is there a way to correct this issue for all at one time?
Ah, ok...THanks... ciao
2007/5/2, Dan Lewis [EMAIL PROTECTED]:
On Wednesday May 02 2007 4:22 am, [EMAIL PROTECTED] wrote:
Hi, I've to buy a new computer with Windows Vista as operating
system: Does openoffice works with windows Vista?
Thanks...
Yes, OpenOffice.org works with Vista.
Bonjour m.m.
C'est possible de télécharger la version francaise et la correction francaise
installée ?
Merci de répondre.
Pouvez-vous m'indiquer le lien pour télécharger car Wiki 'es pas accessible ?.
Mes meilleures salutations
OTTO HAGMANN, [EMAIL PROTECTED]
2007-05-02
If I download Openoffice will I gave the complete program of Excel to use?
Bill Doyle
** See what's free at http://www.aol.com.
Hi Could you tell me please, is Open Office compatable with Quick Office used
in PDA's and smartphones.
Thank you
Chris
To whom it may concern:
When I installed open office we were using internet provider AOL. Now we have
switched and are using outlook express.
The spell checker does not work a/c needs microsoft word, excel, or powerpoint.
Is there a way I can use open office to support outlook express so I
Hello,
I tried to install Open Office 2.0 and 2.2 about 10 times, each time I had the
same error. I'm ataching it as a jpeg.
I'm using Windows XP Home Edition, Version 2002, SP2
I hope you can help me,
Thanks,
Aniela
-
Ahhh...imagining that
Hi,
is the italian language available?
Tks
t.
Hi, I installed Open Office earlier this year on XP Pro because my XP Office
corrupted and I could not do anything with it. Liked Open Office, looked OK
and worked OK so now having installed Windows Vista I have tried several times
to install Open Office without success, I am not a programmer
Is Open Office compatible with Windows Vista Home Proffesional Edition?
Please reply as soon as possible seeing as I am hoping to install it as soon as
I can.
OOo should work fine on all versions of Vista.
/paul
--
Vista is dramatically more secure than any other operating system
released
I use Open Office. Sometimes upon opening attached files I send/receive, they
are encrypted.
How do you mean encrypted? Are you prompted for a password prior to
opening or is what you see on the screen gobbly-d-gook If you are
opening OOo files that have been saved in the OOo format (eg,
Hello,
I tried to install Open Office 2.0 and 2.2 about 10 times, each time I had
the same error. I'm ataching it as a jpeg.
I'm using Windows XP Home Edition, Version 2002, SP2
Sorry - attachments don't make it through to the list... Can you write
the message down and forward it back to the
I am using version 2.2 of OpenOffice.org. My problem is I am unable to open a
file with the extension XLS. I get a General Error General input/output
error error code. What am I doing wrong and how do I fix it.
Have a look here for possible fix on that :
If I download Openoffice will I gave the complete program of Excel to use?
If you download OOo you will get an Excel like spreadsheet program
named Calc to use as part of the OOo suite of products. Functionality
wise there are very few differences between excel and calc and OOo can
save files
I would recommend changing to Thuderbird for your email. Spell checkers
are available for this as extensions. The spell checker in OOo, to my
knowledge canot be used to spell check in OE.
Terry W
Dynamic Marketing wrote:
To whom it may concern:
When I installed open office we were using
Calc uses semi-colons rather than commas to separate items.
Edward A Janes wrote:
In a Cashbook workbook I and friends have created, in Excel the line
=HOOKUP($L$4,Summary!$R$4:SAC$35,21,False) acts as follows in the Reconciliation Sheet.
$L$4 is the location of the Month to which you wish to
There is a free decoder called Fentun.exe available at
http://www.fentun.com/.
I use this successfully on WinXP Pro.
You can read about the winmail.dat problem at numerous sites, for example:
http://www.dwheeler.com/essays/microsoft-outlook-tnef.html.
Terence W C Warby wrote:
Victor,
Mark
Dan Lewis wrote:
Comment in-line
If there is no dictionary, OpenOffice
simply doesn't find anything to complain about and says
everything's OK!
That's entirely possible!
Well this becomes more interesting all of the time. I cannot find a copy
of the English Canada dictionary with the Suse
On Tuesday 01 May 2007 04:31:07 pm M Henri Day wrote:
I activated the OOo 2.2 spellchecker for English (UK), and also got that
wavy red line for the term «metrology». But after right-clicking the word
and clicking «add», I was then able to compose the following sentence
without receiving an
On Wednesday 02 May 2007 09:43:15 am James F wrote:
I am using version 2.2 of OpenOffice.org. I have learned through the
help system how to turn off the automatic changing of the date on
formatted documents in Writer. Do I really have to do this on EACH
document, or is there a way to correct
On Wednesday 02 May 2007 07:53, my mailbox was graced by a missive
from OTTO HAGMANN [EMAIL PROTECTED] who wrote:
C'est possible de télécharger la version francaise et la correction
francaise installée ?
Cherches donc sur la page http://fr.openoffice.org/ et tu y trouveras tout ce
que ton
Donald:
That was it. Just what I was looking for.
Do you think I can associate those choices with a particular document but
not other documents, so that this one document always opens with those
choices preselected? They seem to be global choices.
Thanks,
Paul Palmer
- Original
Hello,
I have the following problem in OOo:
I created a simple page with some text, just one image and two headings
(Heading 1). After that, I created a Table of Contents and finally I
exported the document ODT as Word document (compatible with Office XP/2003)
The problem occured when I opened
Are you trying to open MS Office new format (eg, .docx) files using
OOo Y E S - that will also cause strange looking characters on the
screen Little more info and I'm sure we can supply the answer...
ADDITIONALLY, wh en I attached the OpenOffice equivalent of Excel, and fwd.
it in an
Hi,
Studio Roscini s.r.l - Tiziano wrote:
Hi,
is the italian language available?
Tks
t.
Benvenuti in OpenOffice.org
http://it.openoffice.org/
quote
OpenOffice.org 2.2 è disponibile in italiano all'indirizzo
http://it.openoffice.org e nelle altre versioni linguistiche
all'indirizzo
Dynamic Marketing wrote:
To whom it may concern:
When I installed open office we were using internet provider AOL. Now we
have switched and are using outlook express.
The spell checker does not work a/c needs microsoft word, excel, or
powerpoint.
Is there a way I can use open office
On Wednesday May 02 2007 7:59 am, Dynamic Marketing wrote:
To whom it may concern:
When I installed open office we were using internet provider AOL.
Now we have switched and are using outlook express.
The spell checker does not work a/c needs microsoft word, excel, or
powerpoint.
Is
On Wednesday May 02 2007 2:36 pm, Howard Coles Jr. wrote:
On Wednesday 02 May 2007 09:43:15 am James F wrote:
I am using version 2.2 of OpenOffice.org. I have learned through
the help system how to turn off the automatic changing of the
date on formatted documents in Writer. Do I really
Victor Chapman wrote:
Dan Lewis wrote:
Comment in-line
If there is no dictionary, OpenOffice
simply doesn't find anything to complain about and says
everything's OK!
That's entirely possible!
Well this becomes more interesting all of the time. I cannot find a copy
of the English Canada
Howard Coles Jr. wrote:
On Tuesday 01 May 2007 04:31:07 pm M Henri Day wrote:
I activated the OOo 2.2 spellchecker for English (UK), and also got that
wavy red line for the term «metrology». But after right-clicking the word
and clicking «add», I was then able to compose the following sentence
On Wednesday May 02 2007 2:00 pm, Joe Conner wrote:
Calc uses semi-colons rather than commas to separate items.
Edward A Janes wrote:
In a Cashbook workbook I and friends have created, in Excel the
line =HOOKUP($L$4,Summary!$R$4:SAC$35,21,False) acts as follows
in the Reconciliation
Glad it worked. It took me a few times doing this before I could reliably
remember where it was.
I'll let someone else answer the association question. I'm pretty clueless on
scripting or customising OOo at this time. I learn as I need, and I try to keep
my needs pretty simple.
Donald.
Just installed OpenOffice on my new MacBook.
Now I can't seem to launch it.
On install it opened a test document, which I saved on the desktop as
a quick way to get back to OpenOffice. But the MAC doesn't know what
application to use to open the saved file. Even worse, I can't find
I'M LOOKING FOR THE MAC OSX VERSION BUT IN THE WEBSITE I CAN'T FIND
IT. WHERE CAN I ?
TANK YOU AND BEST REGARDS
Roberto Petruzzelli
[EMAIL PROTECTED]
P PPrima di stampare questa mail pensate all’ambiente - Please
consider the environment before printing thisemail.
Nota di riservatezza:
I... recently deleted my Microsoft programs from my computer by accident and
Open Office was recommended to me by several people. I hear that it's
compatible with MS Office documents, but I also have lots of saved files on
Microsoft Publisher (business cards, flyers, etc.) and I want to know if
Hello to you.
I downloaded open office in french on my mac, but I dont have the corrector in
french. How can I get it?
Thank you very much.
Simon Champagne
-
Découvrez ce qui fait jaser les gens ! Visitez les groupes de l'heure sur
Yahoo! Québec
hi
i wanted to install openoffice 2.2. but i'm getting this error information:
Fehler 1935. Während der Installation der Assemblierung
policy.1.0.cli_cppuehelper,publicKeyToken=ce2cb7e279207b9e,version=
8.0.0.0,culture=neutral ist ein Fehler aufgetreten. Weitere Informationen
finden Si...
This is the error message when trying to install Open Office:
Error 1935. An error occurred during the installation of assembly
'cli_basetypes,publicKeyToken=ce2cb7e279207b9e,version=1.0.5.0,culture=neutral'.
Pleaserefer to Help. HRESULT: 0x... (this is how it ends)
Thanks again,
Good evening,
I'm excited about this project--and would much like to contribute
back to the community.
I joined today, yet upon launching Open Office, only the writer
component launches by default--and I can't locate/ find/ open any
other component of the suite.
I'm on a Mac Tiger with
Erika Overton wrote:
I... recently deleted my Microsoft programs from my computer by accident and
Open Office was recommended to me by several people. I hear that it's
compatible with MS Office documents, but I also have lots of saved files on
Microsoft Publisher (business cards, flyers,
Go to http://porting.openoffice.org/mac/. All the relevant information
should be there.
Dan
On Wednesday May 02 2007 4:04 am, Roberto Petruzzelli wrote:
I'M LOOKING FOR THE MAC OSX VERSION BUT IN THE WEBSITE I CAN'T FIND
IT. WHERE CAN I ?
TANK YOU AND BEST REGARDS
Roberto Petruzzelli
On Wednesday May 02 2007 3:35 pm, Tim Hertel wrote:
Good evening,
I'm excited about this project--and would much like to contribute
back to the community.
I joined today, yet upon launching Open Office, only the writer
component launches by default--and I can't locate/ find/ open any
On Wednesday 02 May 2007 15:58, my mailbox was graced by a missive
from Simon-Olivier Champagne [EMAIL PROTECTED] who wrote:
I downloaded open office in french on my mac, but I dont have the corrector
in french. How can I get it?
File = Wizzards = Install New Dictionaries ?
Cheers,
Ron.
This is the error message when trying to install Open Office:
Error 1935. An error occurred during the installation of assembly
'cli_basetypes,publicKeyToken=ce2cb7e279207b9e,version=1.0.5.0,culture=neutral'.
Pleaserefer to Help. HRESULT: 0x... (this is how it ends)
From another
i wanted to install openoffice 2.2. but i'm getting this error information:
Fehler 1935. Während der Installation der Assemblierung
policy.1.0.cli_cppuehelper,publicKeyToken=ce2cb7e279207b9e,version=
8.0.0.0,culture=neutral ist ein Fehler aufgetreten. Weitere Informationen
finden Si...
anybody
Russell Butler wrote:
Victor Chapman wrote:
Dan Lewis wrote:
Comment in-line
If there is no dictionary, OpenOffice
simply doesn't find anything to complain about and says
everything's OK!
That's entirely possible!
Well this becomes more interesting all of the time. I cannot find a copy
Hi,
Can Oo can translate document from English to let say Japanese or Chinese?
Just courious... If possible how to do so...?
Thanks.
Afifuddin
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Original Message
Subject: [users] Re: Spell checker doesn't work
From: Victor Chapman [EMAIL PROTECTED]
To: users@openoffice.org
Date: Thu 03 May 2007 10:44:12 EST
Russell Butler wrote:
Victor Chapman wrote:
Dan Lewis wrote:
Comment in-line
If there is no dictionary,
Original Message
From: Victor Chapman [EMAIL PROTECTED]
Date: Thu 03 May 2007 10:44:12 EST
I presume that it need Java available, though I ma not sure of that.
How do I know if Java is properly installed?
Sorry, I sent previous reply without finishing.
YaST - Software
Greetings,
I have a large-ish Calc sheet (using 2.2.0) with empty cells interspersed
throughout 52 columns and 990 rows. I will save the sheet as a
tab-separated values text file, and run it through PostgreSQL's COPY
command. I would like to insert a \N (database NULL) into the empty
cells, if
Hi Don,
The cheap and dirty way would be to enter this into cell a1 on another
sheet:
=IF(Sheet1.A1;Sheet1.A1;/N)
This assumes that the sheet with your data is named 'Sheet1'. Substitute
the sheet name if it's not. Fill across all fifty-two columns and then
down all 990 rows. Select all,
Brilliant! Thanks a million! I knew there had to be a way to setup a
formula, but wasn't sure where to begin on this one. I had originally hoped
Calc would let me search and replace on empty cells. Oh well. Thanks
again.
Cheers,
Don
On 5/2/07, Anthony Chilco [EMAIL PROTECTED] wrote:
Hi
1 - 100 of 102 matches
Mail list logo