> > bg:
> >
> > Doesn't work. Whether I enter it as =DATEVALUE($CELL)
> > or as =DATEVALUE($THEDATECELL) it still echoes " #NAME? "
> > all the way through to the final paste. What am I doing wrong?
> >
> > Brewster
Gene Young wrote:
> Try substituting the actual cell reference in place of "THED
> > Adam Tauno Williams wrote:
> >
> >
> >> Insert a column
> >> enter =DATEVALUE($THEDATECELL)
> >> copy-and-paste that one cell to the rest of the column
> >> copy the date value column
> >> paste as values over the old column
> >> delete the column you created
> >>
> >
> > bg:
> >
> > D
Dear Gordon:
I have here about 172 Mb. of templates, partly from MS office and many
other applications.
A Subset of these are templates from most of the Oo applications,
especially Writer and Calc.
That subsection is about 144 Mb. would you like a split .7z archive?
(this requires 7-zip, wh
On 09/22/2010 02:00 PM, Cor Nouws wrote:
> NoOp wrote (21-09-10 21:40)
>> On 09/21/2010 10:28 AM, NoOp wrote:
>>> On 09/21/2010 02:11 AM, Cor Nouws wrote:
>
May I add another performance question?
Mail merge. Also 'pretty' slow for me.
See http://www.openoffice.org/issues/show_bug.c
Can anyone tell me what I need to correct this error I get it when opening any
document:
Error loading BASIC of document
file:///C:/users/owner/AppData/roaming/OpenOffice.org/3/user/basic/dialog.xlc/:General
Error.
General input/output error
Using Win 7 32 bit
Jim
Brewster Gillett wrote:
Adam Tauno Williams wrote:
=DATEVALUE($CELL) will convert a text representation of a date to a date
value.
bg:
Sounds workable, but where and under what screen am I going to enter it
in order to apply it to all 678 rows in that column? I tried enteri
On 9/22/2010 7:17 PM, Brewster Gillett wrote:
Adam Tauno Williams wrote:
=DATEVALUE($CELL) will convert a text representation of a date to a date
value.
bg:
Sounds workable, but where and under what screen am I going to enter it
in order to apply it to all 678 rows in that column? I tried e
> > Adam Tauno Williams wrote:
> > > =DATEVALUE($CELL) will convert a text representation of a date to a date
> > > value.
> > bg:
> > Sounds workable, but where and under what screen am I going to enter it
> > in order to apply it to all 678 rows in that column? I tried entering it
> > in the ed
John, as I mentioned in my earlier response, you set margins by selecting Format from the main menu,
then Page, then the Page tab.
Dear Mr James Knott
Thank your reply and the information re Openoffice,
can you let me know where in the index I can find how to incert margins to my
specificati
NoOp wrote (21-09-10 21:40)
On 09/21/2010 10:28 AM, NoOp wrote:
On 09/21/2010 02:11 AM, Cor Nouws wrote:
May I add another performance question?
Mail merge. Also 'pretty' slow for me.
See http://www.openoffice.org/issues/show_bug.cgi?id=114608
Really would appreciate the experience of others
On Wed, 2010-09-22 at 12:34 -0700, Brewster Gillett wrote:
> Brewster Gillett wrote:
>
> > > Here's what I have. 678-row Calc file, names & addresses and some
> > > additional information. One of those is a column for "date on list".
> > > Unfortunately the way I get the file, as a CSV, those entr
Brewster Gillett wrote:
> > Here's what I have. 678-row Calc file, names & addresses and some
> > additional information. One of those is a column for "date on list".
> > Unfortunately the way I get the file, as a CSV, those entries are
> > not formatted specifically as dates, even though they all
Dear Mr James Knott
Thank your reply and the information re Openoffice,
can you let me know where in the index I can find how to incert margins to my
specifications?
again many thanks
John
> Date: Tue, 21 Sep 2010 16:20:20 -0400
> From: james.kn...@rogers.com
> To: users@openoffice.org; john
On Wed, 2010-09-22 at 10:04 -0700, Brewster Gillett wrote:
> OOo 3.2 under Ubuntu 10.04
Hi, saw your post over on evolution@ :)
> Here's what I have. 678-row Calc file, names & addresses and some
> additional information. One of those is a column for "date on list".
> Unfortunately the way I get
OOo 3.2 under Ubuntu 10.04
Here's that dadblasted now-you-see-it-now-you-don't "text indicator"
(I seem to recall that's what someone once called it) that I have got
to eradicate. Since there are 678 rows in this file, I am not eager
to perform the operation individually on each row.
Here's what
Dear List,
I used to open a spreadsheet having the Multipart/Related Content-type and
an .xls file extension.
I'm not shure how it was generated, but probably something like Cognos
with MS Excel 2002 export option.
It's broken since I upgraded to OO 3.2
Can anyone help ?
Regards
--
Julien Ch
On 9/21/2010 at 5:30 PM Brian Barker wrote:
|At 12:04 21/09/2010 -0400, Mike Noname wrote:
|>I like to have spell check enabled in word-processing documents, and
|>disabled in spreadsheets. Is there a way to configure Open Office
|>such that spell check is
|>enabled when I open a new Writer doc
17 matches
Mail list logo