In Calc (ver 3.x) I have clicked on something to display a list of functions
n the right hand side of my screen. This dialogue box has docked itself to
my Calc screen and has no exit button "x". How can I get rid of it please?
Many thanks, James
--
I have a few Quattro-Pro files, containing charts. I am wondering if
there is any way to transfer them to OOo Calc, maybe be a combination of
Quattro-Pro and Calc filters...
Also, how can I create a chart with bars that represent the lower and
higher values from 2 columns (B and C), while A co
I have Open Office and I enjoy using Calc. How do I turn off always asking
me what kind of data I want to clear out of a cell when I clear out a cell?
Thanks
Steve
Would someone please address this former user's questions?
"I tried OO2 for the past month or so, and found the spreadsheet a little
annoying. I like to hit the + key, and then point at cells to add them
to formulae. OO Calc doesn't work the same way as Excel, and I was
having to enter formu
I have a bunch of spreadsheets that I wish to combine. They are income and expenses for a non-profit organization. A new
sheet is issued each month and it shows income and expense for that month and for YTD.
I would like to extract the figures in the "monthly" column and build a
spreadsheet tha
In Excel, under Data, there is a "Text to columns" wizard to convert
delimited text to proper Excel format. Question: Does Calc perform this
function? I looked and tried a few selections and even queried Help to
no avail.
The computer being used has MS Office 2000 and Openoffice 1.1.
Jeff Long
P
How do I stop calc from automatically turning numbers like 1-11, 2-20 & 10-1
into dates.
Thank You
-
Yahoo! Photos
Got holiday prints? See all the ways to get quality prints in your hands ASAP.
How do I stop calc from automatically turning numbers like 1-11, 2-20 & 10-1
into dates.
Thank You
-
Bring words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
I am doing a spreadsheet and am trying to do what Microsoft calls
"masking" in a cell. I will give 2 examples
First example
I have a date cell and it is using the standard of 02/07/06 .
I want to make it so that when I start the cell I see the slashes and I
don't need to put them in and it goe
I am using OOo 2.0.3 running under Windows XP
In a Calc work book (is that what you call the three sheets tat appear by
default: sheet#1, sheet#2, sheet#3?) I have renamed sheet#1 as "Jobs" and
sheet#2 as "Invoices"
On the Jobs sheet I have:
---job numbers from 1-1000 in column A
---customer
hello everyone. i just joined this list. i've been using OpenOffice for
quite some time now (on Linux). i'm not a power user by any stretch of the
imagination. that being said, i have a question.
i'm trying to set up some spreadsheets for the salon i work for that will
keep track of inventory. i'm
hello everyone. i just joined this list. i've been using OpenOffice for
quite some time now (on Linux). i'm not a power user by any stretch of the
imagination. that being said, i have a question.
i'm trying to set up some spreadsheets for the salon i work for that will
keep track of inventory. i'm
Question:
I have a Excel file that I tried to open in OOoCalc/Math (spreadsheet).
It has two conditional formulas in it.
First time I tried to open it in Ooo, it crashed: hmmm...it also crashed the
2nd time.
I commented those two formulas out, and tried to open it.
After forever, it opened it up.
Hi gang,
I'm doing a study of spam and I need to break the date & time
field I'm getting from log files into separate date fields and
time fields. Currently it is all one: "05/13/08 12:32 PM" I need
it to be: "05/13/08" and "12:32 PM"
Am running OO 2.4 on Windoze and Linux.
Thanks,
Allen
Most of the time, I can figure things out myself. But every once in a while,
HELP! I vaguely remember being able to do this with Lotus vs 2.2 (Yeah, I
know, I'm dating myself.), in the days of DOS.
I created some elaborate spreadsheets, that are longer than one page to print.
On the first
I am a long time list member but have recently installed a satellite dish,
so this address might come up as not belonging to the list.
I have a cash book which is a Calc spreadsheet (latest version), so it has
the usual columns:
DATE TRANSACTION-DETAIL AMOUNT BALANCE
Sometimes you will h
O.K., I give up!
I've been resaving spreadsheets from Excel and Quatrro Pro (saved as
Excel). Some of the spreadsheets have the horizontal and verticle
gridlines that mark each cell removed, giving the spreadsheet a clean
appearance of a plain sheet of paper with only the data on it. I can
I was wondering if someone knew if Calc was able to have add-ins, the same
way excel does. To be specific, we have a system called Pi, which
interfaces into excel to allow data extraction and manipulation. I am
looking into upgrading from Office 97 to Open Office, however I need this
functionalit
2009/12/6 James Elliott :
> In Calc (ver 3.x) I have clicked on something to display a list of functions
> n the right hand side of my screen. This dialogue box has docked itself to
> my Calc screen and has no exit button "x". How can I get rid of it please?
What kind of functions is that? Is it
James Elliott wrote:
In Calc (ver 3.x) I have clicked on something to display a list of
functions n the right hand side of my screen. This dialogue box has
docked itself to my Calc screen and has no exit button "x". How can I
get rid of it please?
Many thanks, James
--
James Elliott wrote:
In Calc (ver 3.x) I have clicked on something to display a list of
functions n the right hand side of my screen. This dialogue box has
docked itself to my Calc screen and has no exit button "x". How can I
get rid of it please?
Many thanks, James
--
Hi Eustace,
OOo v2.4.0 has an input filter for Quattro v6 (*.wb2) files.
tc
emf wrote:
I have a few Quattro-Pro files, containing charts. I am wondering if
there is any way to transfer them to OOo Calc, maybe be a combination of
Quattro-Pro and Calc filters...
Also, how can I create a chart w
I have named ranges of cells in a bookkeeping spreadsheet: Date;
Transaction; Debit; Credit; Balance ... etc
Trouble is ... that I have selected the whole column, in each case, eg from
cell A1 in the Date column to cell A65536. I have a 'Report' page where I
can insert a start date (eg 1/7/07
At 22:36 14/01/2009 -0600, Cardnut Sports Memorabilia wrote:
I have Open Office and I enjoy using Calc. How do I turn off always
asking me what kind of data I want to clear out of a cell when I
clear out a cell?
Once you have selected the material you want to delete, just press
Backspace inst
Hello Pete,
Pete Holsberg schreef:
Would someone please address this former user's questions?
"I tried OO2 for the past month or so, and found the spreadsheet a
little annoying. I like to hit the + key, and then point at cells to
add them to formulae. OO Calc doesn't work the same way as E
Leo Moons typed the following on 5/26/2006 5:14 PM:
Hello Pete,
Pete Holsberg schreef:
Would someone please address this former user's questions?
"I tried OO2 for the past month or so, and found the spreadsheet a
little annoying. I like to hit the + key, and then point at cells to
add them
You can (depending on what you want to do with the spreadsheet at the
end of the day) simply referencing each of the separate spreadsheets
from a single spreadsheet if you want.
Alternatively you could copy and paste the details into a single
spreadsheet as well.
/paul
On 11/10/05, Pete Holsberg
- Original Message - From: "Pete Holsberg" <[EMAIL PROTECTED]>
Subject: [users] Calc Question
I have a bunch of spreadsheets that I wish to combine. They are income and
expenses for a non-profit organization. A new sheet is issued each month
and it shows income and
John Viestenz wrote:
- Original Message - From: "Pete Holsberg" <[EMAIL PROTECTED]>
I have a bunch of spreadsheets that I wish to combine. They are income and
expenses for a non-profit organization. A new sheet is issued each month
and it shows income and expense for that month and fo
On Wed December 21 2005 16:28, + wrote:
> [ MODERATED ]
> In Excel, under Data, there is a "Text to columns" wizard to convert
> delimited text to proper Excel format. Question: Does Calc perform this
> function? I looked and tried a few selections and even queried Help to
> n
On Saturday 07 January 2006 11:58 pm, tim wozniak wrote:
> I'll try to keep this as simple as possible.
>
> On sheet 1 cell A1 I have a number, on cell B1 there is a number. Cell C1
> adds A1 & B1. When I change the numbers of A1 and B1, is it possible to
> automatically have these numbers show u
I am not sure you can do that, BUT you can always enter a ' for text
format, like:
'1-11
The cell will look like:
1-11
so the entered ' will not be visible.
Johnny
Den 2006-01-20 03:33:02 skrev tim wozniak <[EMAIL PROTECTED]>:
How do I stop calc from automatically turning numbers like
On Fri January 20 2006 02:33, + tim wozniak wrote:
> How do I stop calc from automatically turning numbers like 1-11, 2-20 &
> 10-1 into dates.
As you are not subscribed you may not have seen that:
On Fri January 20 2006 21:20, Dennis Marks wrote:
> Change the format of the range of cells from "Al
tim wozniak wrote:
How do I stop calc from automatically turning numbers like 1-11, 2-20 & 10-1
into dates.
Thank You
If you don't need them to be specifically numbers, you can type them
with an apostrophe in front:
'1-11
'2-20
etc.
This forces them to be text and to stay exactly as you
Tim, as you don't seem to be subscribed to this list, you might have
missed this reply
Kira wrote:
tim wozniak wrote:
How do I stop calc from automatically turning numbers like 1-11, 2-20
& 10-1 into dates.
Thank You
If you don't need them to be specifically numbers, you can type them
wi
There is kind of a way to do it by dividing the value you enter using
FLOOR as follows...
For Dates...
Column A - Enter Date e.g. 020878
Column B - Enter the formula =FLOOR(A/[ROW_NO]//1;1)
Column C - Enter the formula =FLOOR(A/[ROW_NO]//100;1)-B/[ROW_NO]/*100
Column D - Enter the formula
=
I've just tried, unsuccessfully, to replicate the issue.
I have inserted a text hyperlink http://www.google.com.au with text
"google" in H8 and in I8 the formula =VLOOKUP(H8;A1:B28;2;0). The word
google is in a cell in column A and the formula correctly returns the
value in the corresponding
I forgot to mention that it might be a lot easier just to use the
HYPERLINK function: =HYPERLINK("#Jobs.A23";Jobs.A23)
Terry wrote:
I've just tried, unsuccessfully, to replicate the issue.
I have inserted a text hyperlink http://www.google.com.au with text
"google" in H8 and in I8 the formula
al Message -
From: "Terry" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 07, 2006 4:36 PM
Subject: Re: [users] Calc question.?
> I've just tried, unsuccessfully, to replicate the issue.
>
> I have inserted a text hyperlink http://www.google.com.au with tex
Does your hyperlink include a text label? A8 should contain the
equivalent of =HYPERLINK("some jpeg";1216) or, if 1216 is a label, "1216".
I think there's something wrong with your formula as posted (probably
double pasting):
=IF(ISNA(VLOOKUP(A8; Jobs.$J$4:$P$1010; 7; 0)); IF(ISNA(VLOOKUP(A8;
Terry wrote:
Does your hyperlink include a text label? A8 should contain the
equivalent of =HYPERLINK("some jpeg";1216) or, if 1216 is a label, "1216".
If you are using the hyperlink dialog, make sure that only 1216 is in
for Text. watch out for spaces or apostrophes (').
I'm surprised that
I have inserted comments
Walter A. March wrote:
Terry wrote:
Does your hyperlink include a text label? A8 should contain the
equivalent of =HYPERLINK("some jpeg";1216) or, if 1216 is a label,
"1216".
If you are using the hyperlink dialog, make sure that only 1216 is in
for Text. watch out
I am just so weak; I could not let this go. I used =NA() to get #NA and
replicated the formula as follows (spaces inserted):
=IF(ISNA(VLOOKUP("calendar";MyLookup;2;0));
IF(ISNA(VLOOKUP("google";MyLookup;2;0));"";
VLOOKUP("calendar";MyLookup;2;0);VLOOKUP("google";MyLookup;2;0))
The result I ge
of you.
Many thanks, James
- Original Message -
From: "Walter A. March" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 08, 2006 10:14 AM
Subject: Re: [users] Calc question.?
Terry wrote:
Does your hyperlink include a text label? A8 should contain the
equivalent of =HYPE
:
Sent: Friday, September 08, 2006 10:14 AM
Subject: Re: [users] Calc question.?
Terry wrote:
Does your hyperlink include a text label? A8 should contain the
equivalent of =HYPERLINK("some jpeg";1216) or, if 1216 is a label,
"1216".
If you are using the hyperlink di
James Elliott wrote:
Hi Walter
You are correct when you asy "The first formula says if it is not on the
Jobs tab, look on the Ravy tab. If it is not there either, return ""
otherwise give the match from
Ravy. If it is on the Jobs tab, give the match from there". I didn't
mention the Ravy tab
Terry wrote:
I am just so weak; I could not let this go. I used =NA() to get #NA and
replicated the formula as follows (spaces inserted):
=IF(ISNA(VLOOKUP("calendar";MyLookup;2;0));
IF(ISNA(VLOOKUP("google";MyLookup;2;0));"";
VLOOKUP("calendar";MyLookup;2;0);VLOOKUP("google";MyLookup;2;0))
T
Walter A. March wrote:
Terry wrote:
The result I get is ERR:504.
Try
=IF(ISNA(VLOOKUP("calendar";MyLookup;2;0));
IF(ISNA(VLOOKUP("google";MyLookup;2;0));"";
VLOOKUP("google";MyLookup;2;0));VLOOKUP("calendar";MyLookup;2;0))
without the spaces.
If you don't find calendar, look for google. I
Terry wrote:
Walter A. March wrote:
Terry wrote:
The result I get is ERR:504.
Try
=IF(ISNA(VLOOKUP("calendar";MyLookup;2;0));
IF(ISNA(VLOOKUP("google";MyLookup;2;0));"";
VLOOKUP("google";MyLookup;2;0));VLOOKUP("calendar";MyLookup;2;0))
without the spaces.
If you don't find calendar, look
It is probably possible with a macro, but I am not 100% sure what you have
done. Can you send the file to me or upload it somewhere and give us a link?
Or could you do a fake using the same technique as the original?
Johnny Rosenberg
2007/8/15, jack wallen <[EMAIL PROTECTED]>:
>
> hello everyone.
Johnny Rosenberg wrote:
It is probably possible with a macro, but I am not 100% sure what you have
done. Can you send the file to me or upload it somewhere and give us a link?
Or could you do a fake using the same technique as the original?
Johnny Rosenberg
2007/8/15, jack wallen <[EMAIL PROTEC
On Wed, August 15, 2007 1:59 pm, Harold Fuchs wrote:
> You can refer to different sheets by preceding the usual cell reference
> with a sheet name so, for example, "Sheet1.A1" refers to cell A1 in the
> sheet named "Sheet1". When you start a new spread sheet the sheets are
> named "Sheet1", "Sheet
jack wallen wrote:
On Wed, August 15, 2007 1:59 pm, Harold Fuchs wrote:
You can refer to different sheets by preceding the usual cell reference
with a sheet name so, for example, "Sheet1.A1" refers to cell A1 in the
sheet named "Sheet1". When you start a new spread sheet the sheets are
named
On 25/08/07, Steve Domina <[EMAIL PROTECTED]> wrote:
>
> Question:
>
> I have a Excel file that I tried to open in OOoCalc/Math (spreadsheet).
> It has two conditional formulas in it.
> First time I tried to open it in Ooo, it crashed: hmmm...it also crashed
> the
> 2nd time.
> I commented those tw
COUNTIF also works fine in OpenOffice.org; it's probably one of the most
commonly used cell formulas, so if it didn't work, many people would be very
loud about it and the bug would be corrected rather quickly.
I guess it's very hard to tell what's wrong in your case without having a
look at the f
At 21:57 24/05/2008 -0700, Allen Noname wrote:
I'm doing a study of spam and I need to break the date & time field
I'm getting from log files into separate date fields and time
fields. Currently it is all one: "05/13/08 12:32 PM" I need it to
be: "05/13/08" and "12:32 PM".
If your values are
Allen wrote:
Hi gang,
I'm doing a study of spam and I need to break the date & time field
I'm getting from log files into separate date fields and time fields.
Currently it is all one: "05/13/08 12:32 PM" I need it to be:
"05/13/08" and "12:32 PM"
Am running OO 2.4 on Windoze and Linux.
S
Allen:
On Sat, May 24, 2008 at 09:57:14PM -0700, Allen wrote:
> Hi gang,
>
> I'm doing a study of spam and I need to break the date & time
> field I'm getting from log files into separate date fields and
> time fields. Currently it is all one: "05/13/08 12:32 PM" I need
> it to be: "05/13/08"
2008/5/25, Dean Allen Provins, P. Geoph. <[EMAIL PROTECTED]>:
>
> Allen:
>
>
> On Sat, May 24, 2008 at 09:57:14PM -0700, Allen wrote:
> > Hi gang,
> >
> > I'm doing a study of spam and I need to break the date & time
> > field I'm getting from log files into separate date fields and
> > time fields
/OP
On Menu select 'Format' and then 'Page'. That will give you the opportunity to
set Headers and Footers.
Kirk
--- On Fri, 7/18/08, Gregory Forster <[EMAIL PROTECTED]> wrote:
> From: Gregory Forster <[EMAIL PROTECTED]>
> Subject: [users] Calc que
also,
from the format menu, choose print area and edit. it will allow you to
choose what row/column to print on each page.
Gregory Forster wrote:
Most of the time, I can figure things out myself. But every once in a while, HELP! I vaguely remember being able to do this with Lotus vs 2.2 (Y
Thank you. That did the trick! Thank you!
- Original Message
From: The Morses <[EMAIL PROTECTED]>
To: users@openoffice.org
Sent: Friday, July 18, 2008 5:30:43 PM
Subject: Re: [users] Calc question
also,
from the format menu, choose print area and edit. it will allow you to
ROTECTED]>
To: users@openoffice.org
Sent: Friday, July 18, 2008 5:23:22 PM
Subject: Re: [users] Calc question
/OP
On Menu select 'Format' and then 'Page'. That will give you the opportunity to
set Headers and Footers.
Kirk
--- On Fri, 7/18/08, Gregory Forster <[EM
Comments in-line.
On Thursday April 12 2007 11:57 pm, James Elliott wrote:
> I am a long time list member but have recently installed a
> satellite dish, so this address might come up as not belonging to
> the list.
You state you are not sending using your user email account, but are
you receiv
Copied to James as I cannot tell if he is subscribed.
While a database would be a much better solution, if you insist upon
using CALC you
can use multiple worksheets to accomplish what you have asked for.
I am attaching a Calc spreadsheet with the illustration you provided
below. It is
calle
AM
Subject: Re: [users] Calc question.?
Copied to James as I cannot tell if he is subscribed.
While a database would be a much better solution, if you insist upon using
CALC you
can use multiple worksheets to accomplish what you have asked for.
I am attaching a Calc spreadsheet with
stions with
an explanation.
Thanks for the reply and info.
James
- Original Message -
From: "Dan Lewis" <[EMAIL PROTECTED]>
To:
Cc: "James Elliott" <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2007 8:50 AM
Subject: Re: [users] Calc question.?
Comm
On Tuesday April 17 2007 12:52 am, James Elliott wrote:
> Thanks Dan
>
> It seems that my e-mails are getting through OK.
>
> Yes, I am still receiving mail from the list. If you specify the
> incoming and outgoing mail server addresses correctly you can use
> one ISP connection to access mail on
Gregory L. Forster wrote:
O.K.,
I give up!
I've been resaving spreadsheets from Excel and Quatrro Pro (saved as
Excel). Some of the spreadsheets have the horizontal and verticle
gridlines that mark each cell removed, giving the spreadsheet a clean
appearance of a plain sheet of paper w
Gregory L. Forster <[EMAIL PROTECTED]> skrev den Mon, 28 Mar 2005
18:07:36 -0600:
O.K., I give up!
I've been resaving spreadsheets from Excel and Quatrro Pro (saved as
Excel). Some of the spreadsheets have the horizontal and verticle
gridlines that mark each cell removed, giving the spre
On Thursday 14 July 2005 16:35, + Pick, Travis - Marathon wrote:
> [ MODERATED ] ***
> I was wondering if someone knew if Calc was able to have add-ins, the same
> way excel does. To be specific, we have a system called Pi, which
> interfaces into excel to allow data extractio
On Thu, 2005-07-14 at 23:29 +0100, CPHennessy wrote:
> On Thursday 14 July 2005 16:35, + Pick, Travis - Marathon wrote:
> > [ MODERATED ] ***
> > I was wondering if someone knew if Calc was able to have add-ins, the same
> > way excel does. To be specific, we have a system cal
Thanks for the assistance.
Travis
-Original Message-
From: CPHennessy [mailto:[EMAIL PROTECTED]
Sent: Thu 2005-07-14 6:29 PM
To: users@openoffice.org; Pick, Travis - Marathon
Cc:
Subject: Re: [users] Calc Question
On Thursday 14 July 2005 16:35, + Pick, Travis - Marathon wrote
2008/8/26 James Elliott - WA Rural Computers <[EMAIL PROTECTED]>
> I have named ranges of cells in a bookkeeping spreadsheet: Date;
> Transaction; Debit; Credit; Balance ... etc
>
> Trouble is ... that I have selected the whole column, in each case, eg from
> cell A1 in the Date column to cell A65
At 21:33 26/08/2008 +0800, James Elliott - WA Rural Computers wrote:
I know how to Insert a Name, but I don't know how to go back and
edit the ranges I have previously specified.
o Go to Insert | Names > | Define... .
o Click on the name in the list to highlight it.
o Drag the mouse over the
2008/8/26 Brian Barker <[EMAIL PROTECTED]>
> At 21:33 26/08/2008 +0800, James Elliott - WA Rural Computers wrote:
>
>> I know how to Insert a Name, but I don't know how to go back and edit the
>> ranges I have previously specified.
>>
>
> o Go to Insert | Names > | Define... .
> o Click on the n
Thanks to both Johnny Rosenberg and Brian Barker for your help
James
- Original Message -
From: "James Elliott - WA Rural Computers" <[EMAIL PROTECTED]>
To: "OOo Users"
Sent: Tuesday, August 26, 2008 9:33 PM
Subject: [users] Calc question - Names.?
I have
I WISH SOMEONE WOULD TELL ME HOW TO UNSUBSCRIBE FROM ALL THIS SHIT!
--- On Thu, 8/28/08, James Elliott - WA Rural Computers <[EMAIL PROTECTED]>
wrote:
From: James Elliott - WA Rural Computers <[EMAIL PROTECTED]>
Subject: Re: [users] Calc question - Names.?
To: users@openoffice.org
Da
In article <[EMAIL PROTECTED]>, m.a. martin
<[EMAIL PROTECTED]> shouted:
> I WISH SOMEONE WOULD TELL ME HOW TO UNSUBSCRIBE
> FROM ALL THIS SHIT!
[snip]
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands,
2008/8/29 Richard Travers <[EMAIL PROTECTED]>
> In article <[EMAIL PROTECTED]>, m.a. martin
> <[EMAIL PROTECTED]> shouted:
>
> > I WISH SOMEONE WOULD TELL ME HOW TO UNSUBSCRIBE
> > FROM ALL THIS SHIT!
> [snip]
> > -
> > To unsubs
On 29 Aug 2008 at 10:12, Johnny Rosenberg wrote:
...
> That was a really nice answer. I would have said something like "maybe stop
> being an idiot would help", but fortunately I'm not that rude, so I didn't.
> :)
Some people are so polite in the face of rudeness!
It is interesting that Mr Martin
I import my transactions from my Internet Banking account as a *.csv file
and then open it with OOo Calc (currently ver 2.4 running under Windows XP
SP2)
The problem is that I keep my bookkeeping spreadsheets with the earliest
date at the top of the worksheet and the newest entry at the botto
At 16:41 15/04/2008 +0800, James Elliott wrote:
If I download 100 transactions it is tedious to type into a spare column:
1
2
3
4
5
6
7
...
...
99
100
You are making heavy weather of this. Spreadsheets are designed to
make your life easy!
To enter these numbers, either:
o Enter the number
to "Paste Special" - thanks for
that!
Kind regards, James
- Original Message -
From: "Brian Barker" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 15, 2008 6:35 PM
Subject: Re: [users] Calc question - sorting data.?
At 16:41 15/04/2008 +0800, James Elliott
I have a Calc 2.4 spreadsheet set of accounts which needs to print out in
landscape mode to fit on one page.
Below the set of accounts I have a "key" which is a 2-column list of what
the codes and abbreviations stand for, which will also fit on one page
(page2) if printed in portrait format.
Brian Barker skrev:
> At 14:43 15/09/2008 +0800, James Elliott wrote:
>> I have a Calc 2.4 spreadsheet set of accounts which needs to print out
>> in landscape mode to fit on one page. Below the set of accounts I
>> have a "key" which is a 2-column list of what the codes and
>> abbreviations sta
Hi all -
I'd like to know how (or if it's indeed possible) to use a set of
non-contiguous cells in a function like LARGE().
For example, in Excel I can use
LARGE((A1,A2,A3), 1)
but the equivalent in OpenOffice (1.9.125)
LARGE((A1; A2; A3); 1)
gives a 508 (mis-matched pair) error.
--
Steph
On Sat, 2005-09-10 at 09:57 +0800, Stephen R. Darragh wrote:
> Hi all -
>
> I'd like to know how (or if it's indeed possible) to use a set of
> non-contiguous cells in a function like LARGE().
>
> For example, in Excel I can use
>
> LARGE((A1,A2,A3), 1)
>
> but the equivalent in OpenOffice (1.
Sorry, bad example from me.
I meant something like (A1; T2; X4)
Non-contiguous. Excel allows this in a notation like above. So not a
range of cells.
G. Roderick Singleton wrote:
On Sat, 2005-09-10 at 09:57 +0800, Stephen R. Darragh wrote:
Hi all -
I'd like to know how (or if it's indeed
The simple answer is no. Calc's LARGE function works with a single range
of cells rather than a non-continuous group of cells.
Dan
On Friday 09 September 2005 09:29 pm, Stephen R. Darragh wrote:
> Sorry, bad example from me.
>
> I meant something like (A1; T2; X4)
>
> Non-contiguous. Excel allo
Where's the appropriate place to ask for that functionality to be added?
I guess it's really a request to change the behaviour of a whole class
of functions which accept ranges as a parameter.
Dan Lewis wrote:
The simple answer is no. Calc's LARGE function works with a single range
of cells r
Stephen R. Darragh wrote:
Where's the appropriate place to ask for that functionality to be added?
I guess it's really a request to change the behaviour of a whole class
of functions which accept ranges as a parameter.
This is covered by enhancement issue 32341 (OpCode 'ocUnion').
Niklas
--
Hi, if I have a column such as A2:A40 and it is incompletely populated with
items is there a function to select the last item which could be anywhere
between A2:A40?
I have a spreadsheet whose depth depends on an actuarial table. So, for
an example I have a sheet that extends for 10 years, with each row
representing a month:
Row Dateperiod time
11 5/23/2008 1 0
12 6/23/2008 1 2
122 5/23/2008 1
On 17/01/2006, at 6:50 PM, Jeffrey Allen wrote:
Hi, if I have a column such as A2:A40 and it is incompletely
populated with
items is there a function to select the last item which could be
anywhere
between A2:A40?
Hi Jeffrey,
This question with answers is located in the knowledgebase at
95 matches
Mail list logo