HDTenEightyP/NetNews huggingface dataset:
From: gk1@acpub.duke.edu (Gavin  Kistner)
Newsgroups: comp.apps.spreadsheets
Subject: 3 Problems/Bugs in Excel 4.0
Date: 18 Nov 92 02:30:40 GMT
Followup-To: comp.apps.spreadsheets

Does anoyone know why the following occur, and if I can fix them?

1) On starting Excel, either on a stand-alone launch or a document open, it
automatically switches to the background and the last program used is
brought forward.  If I'm starting it, I'd rather like to use it.

2) If I choose show baloons, and switch out of Excel, the new menu item is,
as it should be, hide baloons.  But back in Excel, even after switching
out, checking it, and coming back, it still says show baloons.  Minor, but
annoying.  (Not that I would dream of using baloon help...   :)

3) Dialogs with the "STOP" icon which appear have the icon in black and
white.  All other programs notice the cicn I have designed...what's up,
Excel?  With 24-bit color, I'd like to be able to use it...

System:
Mac IIfx running 7.0.1 with Tuneup 1.1.1
20MB RAM (32-bit addressing is ON)

Why does Microsoft insist on being non-standard and doing things its way.
I tried to Command-B (bold) some text and almost wiped it out.  Grumble.

Thanks for any help!

_______________________________________________________________________________
"If this is reality, where are the aardvarks?"          
Gavin Kistner          ( gk1@acpub.duke.edu )
_______________________________________________________________________________
Organization: Masters student, Urban and Public Affairs, Carnegie Mellon, Pittsburgh, PA
Newsgroups: comp.apps.spreadsheets
Date: Thu, 19 Nov 1992 21:10:45 -0500 
From: Stephen Sorensen <ss9o+@andrew.cmu.edu>
Subject: Quattro Macros--Help!

Hi folks,
Can ANYONE answer my question about using macros in Quattropro (I'm
using qp 4.0 for windows) ? All I want to do is have a macro go through
and color all the cells with numbers; I want it to leave the blank cells
alone. So far, I've got something like this:
                    {IF #NOT#@Active_Cell}{RIGHT}
                    {Setproperty....}
                    {Right}

I keep getting an error message about an invalid statement. Does anyone
know how to properly use such an "IF" clause ? The Quattro manuals seem
basically useless.

Any help would be GREATLY appreciated.

Thanks,
Steve

############################################################################
       Steve Sorensen                     The H.John Heinz School  
                                        Carnegie-Mellon University      
             ss9o@andrew.cmu.edu                  Pittsburgh, PA 


  The stupid economy !
#############################################################################
From: fatican@iccgcc.decnet.ab.com (Nick Fatica)
Newsgroups: comp.apps.spreadsheets
Subject: decoding macro
Date: 18 Nov 92 14:22:02 EST

I'm looking for a spreadsheet macro (I'm using Quattro Pro - Special Edition)
that will read a four digit hex number (entered as a label) from a cell, parse
it, and enter numbers in the appropriate columns in that row according to the
state of each bit in the hex number.  For example:

     A B C D E F G H I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z AA BB
     1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

0362   2   4   6   8 9    11       14 15    17       20    22    24 25       28

One way to look at this "encoding" is to start from the right and let each odd
number represent a "1" and each even number represent a "0" and then divide the
even/odd pairs into groups of four (21/22, 23/24, 25/26, 27,28).  So for the
above example, 22,24,25,28 would correspond to 0010, which can be represented
as a hex 2.
-- 
Nick Fatica   fatican@astro.pc.ab.com
The Allen-Bradley Company
"Practice random kindness and senseless acts of beauty."
From: siva@anu.edu.au (Siva Misra)
Newsgroups: comp.apps.spreadsheets
Subject: Help on WINGZ
Date: 19 Nov 1992 04:30:46 GMT
Organization: Interdisciplinary Engineering Program, ANU, Australia
Distribution: world
Reply-To: siva@anu.edu.au
NNTP-Posting-Host: 150.203.45.22
Keywords: WINGZ SUNOS/MAC SPREADSHEET

Hello all,
	Can somebody answer answer my question on using the WINGZ hyperscript
please. The question is :
	Does WINGZ HyperScript allows me to check if a work sheet is currently open.
	Because everytime I try to do open operation on already opened worksheet,
	WINGZ displays a message "File already open". Well you might say that why
	should you open again and again. But in my script some times I close, as I have
	many work sheets to operate on. 
	Thanks for any leads.
			
				Cheers!
				Misra
				siva@faceng.anu.edu.au




Newsgroups: comp.apps.spreadsheets
From: r-mcdonald@nwu.edu (Robert McDonald)
Subject: Re: Quattro Macros--Help!
Organization: Northwestern University
Date: Fri, 20 Nov 1992 17:53:52 GMT

In article <0f34YZW00WBN88i1sO@andrew.cmu.edu> Stephen Sorensen <ss9o+@andrew.cmu.edu> writes:
>Date: Thu, 19 Nov 1992 21:10:45 -0500 
>From: Stephen Sorensen <ss9o+@andrew.cmu.edu>
>Subject: Quattro Macros--Help!
>Hi folks,
>Can ANYONE answer my question about using macros in Quattropro (I'm
>using qp 4.0 for windows) ? All I want to do is have a macro go through
>and color all the cells with numbers; I want it to leave the blank cells
>alone. So far, I've got something like this:
>                    {IF #NOT#@Active_Cell}{RIGHT}
>                    {Setproperty....}
>                    {Right}
>
>I keep getting an error message about an invalid statement. Does anyone
>know how to properly use such an "IF" clause ? The Quattro manuals seem
>basically useless.
>
>Any help would be GREATLY appreciated.
>
>Thanks,
>Steve
>

First, sorry to all about my previous incomplete posting; I 
accidentally sent it in the middle of typing and couldn't stop it.  

There are two solutions to what you want to do.  The non-macro solution 
(which *sounds* as if it would suffice, based on your description) is to 
select /Options,colors,conditional and you can then set numeric values to 
display in whatever color you want.

A macro solution would be to use the fact that @cell can check whether a 
cell has a value in it: 

   {if @cell("type",a1)="v"}etc...

and you could cycle through the spreadsheet, perhaps using @cellindex in 
place of "a1".  The first solution is definitely the easiest if it does what 
you want.

-- Bob


***********************************************
Robert McDonald  / Internet: r-mcdonald@nwu.edu 
Fin. Dept., Kellogg School, Northwestern Univ.  
2001 Sheridan Rd., Evanston, IL 60208-2006   
voice: 708-491-8344 / Fax 708-491-5719    
***********************************************
Newsgroups: comp.apps.spreadsheets
From: joelsp@microsoft.com (Joel Spolsky)
Subject: Re: Excel Font Question
Date: 17 Nov 92 01:21:42 GMT
Organization: Microsoft Corporation

In article <BxoC2K.8v3@da_vinci.it.uswc.uswest.com> rmcinty@venezia.it.uswc.uswest.com (Robert P. McIntyre) writes:
>I need some help with an Excel question.  Is it possible to interactively
>test a cell or range of cells and adjust the font (e.g. bold, italic,
>etc.) based on the result of the test? 

There are several approaches to accomplish what you want.

The easiest way is to change the color of the cell by using a
conditional format. For example, if you set the number format of a cell
to 

	[>1000] [BLUE]0; [<-1000] [RED]0; [GREEN]0

the cell will be blue if it is greater than 1000, red if it is less
than -1000, and green otherwise. For more information on conditional
formats, see p.224 in User's Guide 1. Unfortunately, conditional formats
can only include colors, not other font attributes like bold or italic.

A more general solution would be to write a macro which scans the
appropriate cells and changes their formats, based on their values. As
a simple example, the following macro scans the cells from A1 to A10
and makes all the negative cells bold:

	A			
1	NegBold			
2	=FOR.CELL("cel","r1c1:r10c1")
3	= SELECT(REFTEXT(cel))
4	= ACTIVE.CELL()
5	= IF(A4<0)
6	=  FORMAT.FONT(,,TRUE)
7	= END.IF()
8	= NEXT()
9	=RETURN()

You can attach this to a menu, a keyboard accelerator, or a button on
the worksheet, or you can use the ON.ENTRY function to have this macro
run automatically every time you change the worksheet.

--
Joel Spolsky			
Program Manager			
Microsoft Excel			
joelsp@microsoft.com
From: banshee@cats.ucsc.edu (Wailer at the Gates of Dawn)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Memory Problems w qpro for windows
Date: 18 Nov 1992 21:29:05 GMT
Organization: University of California, Santa Cruz
NNTP-Posting-Host: am.ucsc.edu


rjl@spectre.apana.org.au (Richard Lindner) writes:
>has anyone found problems with out of memory diagnostics when trying
>to load qpro for windows - this is with 615k base memory free, on a
>386DX with 4MB & ~8MB windows swapspace?

Nope, never seen that.  You _are_ running enhanced mode windows, right?
What the actual error message?  

-- 
The Wailer at the Gates of Dawn              | banshee@cats.UCSC.EDU       |
Just who ARE you calling a FROOFROO Head?    |                             |
DoD#0667  "Just a friend of the beast."      | banshee@ucscb.UCSC.EDU      |
2,3,5,7,13,17,19,31,61,89,107,127,521,607....| banshee@ucscb.BITNET        |
Newsgroups: comp.apps.spreadsheets
From: r-mcdonald@nwu.edu (Robert McDonald)
Subject: Re: Quattro Macros--Help!
Organization: Northwestern University
Date: Fri, 20 Nov 1992 16:51:45 GMT

In article <0f34YZW00WBN88i1sO@andrew.cmu.edu> Stephen Sorensen <ss9o+@andrew.cmu.edu> writes:
>Date: Thu, 19 Nov 1992 21:10:45 -0500 
>From: Stephen Sorensen <ss9o+@andrew.cmu.edu>
>Subject: Quattro Macros--Help!
>Hi folks,
>Can ANYONE answer my question about using macros in Quattropro (I'm
>using qp 4.0 for windows) ? All I want to do is have a macro go through
>and color all the cells with numbers; I want it to leave the blank cells
>alone. So far, I've got something like this:
>                    {IF #NOT#@Active_Cell}{RIGHT}
>                    {Setproperty....}
>                    {Right}
>
>I keep getting an error message about an invalid statement. Does anyone
>know how to properly use such an "IF" clause ? The Quattro manuals seem
>basically useless.
>
>Any help would be GREATLY appreciated.
>
>Thanks,
>Steve
>

There is one easy solution without a macro, and I can at least give you a 
start on a macro that will do what you want.

The non-macro solution is to go to /options,colro


***********************************************
Robert McDonald  / Internet: r-mcdonald@nwu.edu 
Fin. Dept., Kellogg School, Northwestern Univ.  
2001 Sheridan Rd., Evanston, IL 60208-2006   
voice: 708-491-8344 / Fax 708-491-5719    
***********************************************
Newsgroups: comp.apps.spreadsheets
From: Keith Thorne <thornek@mis.tridom.com>
Subject: Re: Help on WINGZ hyperscript and charts
X-Xxdate: Thu, 19 Nov 92 12:59:18 GMT
Organization: Tridom
X-Useragent: Nuntius v1.1.1d9
Date: Thu, 19 Nov 1992 16:50:07 GMT

I'm trying to create a chart give it a name and each time the user
request a new chart, erase the old chart.  I know how to erase the old
chart,  just select it by name and clear.

But, the first time the users attemts this with new data, there is no
chart, and the nasty message "Selection was unsuccessfull" comes up. I
could use On Error, but I don't want other errors traped. Is there some
way to check to see if an object is there before you attempt to select
it? Or some other way to prevent this error message from appearing.  
Thanks.


- Keith
From: WHITESR@CONRAD.APPSTATE.EDU (*Steve White         )
Newsgroups: comp.apps.spreadsheets
Subject: Displaying quarters in Excel?
Date: 16 Nov 1992 02:29:12 GMT
Organization: APPALACHIAN STATE UNIVERSITY
Distribution: world
NNTP-Posting-Host: conrad.appstate.edu
X-News-Reader: VMS NEWS 1.24


I have a series of dates in cells within an Excel 3.0 sheet.

What's the easiest way to display those dates as quarters?

For example, I would want dates 1/1 through 3/30 displayed
something like "Q1", 4/1 through 6/30 displayed something
like "Q2", etc.

Can this be done through the Format-Number command? Or do
I need to convert the dates through cumbersome formulae
with "IF" statement(s)?

Thx much,
Steve
--------------------------------------------------------------------------
stephen r. white -- whitesr@appstate.bitnet -- whitesr@conrad.appstate.edu
--------------------------------------------------------------------------
Newsgroups: comp.apps.spreadsheets
From: rodc@fc.hp.com (Rod Cerkoney)
Subject: n! function/operator...
Date: Mon, 16 Nov 1992 20:50:45 GMT
Organization: Hewlett Packard, Fort Collins, CO
X-Newsreader: TIN [version 1.1.3 PL6]

	Does Lotus-123 have an operator or function to evaluate N!. If
not, where can I find information about writing Lotus-123 add-in functions?

--
Regards,
Rod Cerkoney
                                                        /\
______________________________________________         /~~\
                                                      /    \
  Rod Cerkoney MS 37     email:                      /      \ 
  Hewlett Packard         rodc@fc.hp.com        /\  /        \  
  3404 East Harmony Rd.  Hpdesk:               /  \/          \    /\
  Fort Collins, CO 80525  HP4000/UX           /    \           \  /  \
_____________________________________________/      \           \/    \__
From: ulrich@econ.uni-paderborn.de (Ralf Ulrich)
Newsgroups: comp.apps.spreadsheets
Subject: Excel file manager
Date: 21 Nov 1992 18:19:10 GMT
Organization: Universitaet Paderborn
NNTP-Posting-Host: 131.234.162.5
Summary: File manager for Excel 4.0 needed
Keywords: Excel

I am looking for a macro or add-in which does some file managment for 
Excel 4.0. There is a macro which saves information on the spreadsheet as a 
hidden note with the XLS-file. But then I can't read these informations 
without loading the whole file.

SuperCalc 5 gave the opportunity to see the content of cell A1 for 
all the files in the subdirectory. I wonder if someone wrote a macro for 
Excel doing something similar. 

Ralf Ulrich
Newsgroups: comp.apps.spreadsheets
From: dsouza@fraser.sfu.ca (Keith D'Souza)
Subject: Boeing Calc anyone ?
Organization: Simon Fraser University, Burnaby, B.C., Canada
Distribution: WORLD
Date: Sun, 22 Nov 1992 00:45:33 GMT

 Hi!

Would appreciate an e-mail reply from anyone using/having used the 3D
spreadsheet Boeing Calc.  I seem to be having a problem using it on a Novell network.  Also, what are the other PC based 3D s/sheets available ? If I cannot 
solve the problem with Boeing Calc then I'd have to port the app. to another
s/sheet.

Appreciate your suggestions/comments via e-mail

THanx

Keith
dsouza@sfu.ca
Newsgroups: comp.apps.spreadsheets
From: Keith Thorne <thornek@mis.tridom.com>
Subject: Re: Help on WINGZ
X-Xxdate: Thu, 19 Nov 92 12:54:50 GMT
Organization: Tridom
X-Useragent: Nuntius v1.1.1d9
Date: Thu, 19 Nov 1992 16:45:40 GMT


Hi,

  I write lots of code in hyper script so if you need other info, keep my
name around.

  Below is a funciton which checks to see if a sheet is open, if not then
open it, if it is open, then bring it to the front.  Here it is...

{**************************************}
Function GET_APP_EDIT()

DEFINE master_sheet, support_path

UNSELECT

master_sheet = name()
support_path = sys_path

SELECT RANGE APP_SPEC
SELECT MORE RANGE TRAFFIC_DATA
COPY

{ opwn the application edit sheet }

GO TO WINDOW sys_path & ":APP_EDIT.WGZ"
IF (kt_utils:sheet_name() <> "APP_EDIT.WGZ")
	OPEN sys_path & ":APP_EDIT.WGZ"
END IF

INVALIDATE ON
PUT master_sheet INTO A50
PUT support_path INTO A51

{SELECT RANGE APP_SPEC}
SELECT RANGE C11
PASTE

UNSELECT

INVALIDATE OFF

REPAINT SELECTIONS ON

END FUNCTION
{**************************************}


sys_path: this is the is a cell in the parent sheet containing the path to
other support files. In my case, the sheet I am going to open is in the
directory contained in the cell named sys_path.

This function copies data from the parent sheet, which is locked, to a
work
sheet for editing. The new, temporary sheet is called APP_EDIT.WGZ and it
will be found in the directory indicated by sys_path.

The code you ask for occurs after the comment { opwn the application edit
sheet }. The funciton kt_utils:sheet_name is a utility function I wrote
allso, included below.

The GO TO WINDOW command will activate the indicated sheet if it is open.
The if statement checks to see if the active window matches the one you
wanted to activate, if the names do not match then the sheet must not have
been open and I make the open call.

If you have any questions, just drop a line.  Here is the other
function...


{**************************************}
function SHEET_NAME()				{ Name of current sheet without path }
define name,col
	name = name()
	col = match(name,":",2)
	while col > 0
		name = mid(name,col,length(name) - col)
		col = match(name,":",2)  {start searching at second char for colon}
	end while
	return (name)
end function
Newsgroups: comp.apps.spreadsheets
From: rjl@spectre.apana.org.au (Richard Lindner)
Subject: Memory Problems w qpro for windows
Organization: Australian Coherent Users Group
X-Newsreader: Tin 1.1 PL5
Date: 18 Nov 92 08:44:30 GMT


has anyone found problems with out of memory diagnostics when trying
to load qpro for windows - this is with 615k base memory free, on a
386DX with 4MB & ~8MB windows swapspace?

got me beat!! ;-)


-- 
richard lindner                   ,-_|\            rjl@spectre.apana.org.au
                                 /apana\           voice: 61 3 882 4690
ACUG Convenor and                \_,-._/           data:  61 3 882 1558
APANA Secretary                       v            fax:   61 3 827 4209
Newsgroups: comp.apps.spreadsheets
From: beaumont@sics.se (Anthony Beaumont)
Subject: ascii data file -> lotus WKS
Organization: Swedish Institute of Computer Science, Kista
Date: Wed, 18 Nov 1992 17:21:56 GMT


I have some ascii data files which I would like to convert into lotus WKS
format.  I would like to find a program to run on a UNIX system (sun4/sun3)
that would do the conversion for me.

Please reply by email to: beaumont@cs.bris.ac.uk

-Tony Beaumont
University of Bristol
Advanced Computing Research Center
beaumont@cs.bris.ac.uk
Newsgroups: comp.apps.spreadsheets
From: timtow@timtow.b1.ingr.com (Tim Tow)
Subject: Re: Displaying quarters in Excel?
Reply-To: timtow@timtow.b1.ingr.com
Organization: Intergraph Corp, Huntsville, Alabama
Date: Mon, 16 Nov 1992 15:06:50 GMT

In article <1e711oINNi8h@lester.appstate.edu>, WHITESR@CONRAD.APPSTATE.EDU (*Steve White         ) writes:
|> 
|> I have a series of dates in cells within an Excel 3.0 sheet.
|> 
|> What's the easiest way to display those dates as quarters?
|> 
|> For example, I would want dates 1/1 through 3/30 displayed
|> something like "Q1", 4/1 through 6/30 displayed something
|> like "Q2", etc.
|> 

Try something like this (off the top of my head... ==untested!)

  =choose(month(<datevalue reference>),"Q1","Q1","Q1","Q2","Q2","Q2",.. etc)

assuming the <datevalue reference> is a cell were the dates are entered as
a datevalue  (hmmm.. that sure sounds like doubletalk to me..)

Place this formula in a row and then set the row height on the row containing
the original datevalue info to 0.

Hope this works...

-- 
 ----------------------------------------------------------------------------
 Tim Tow                              |                                      
 Intergraph Corporation               | "Injustice anywhere is a             
 Huntsville, AL                       |      threat to justice everywhere"    
 Mailpath:..timtow@timtow.b1.ingr.com |                                      
 Voice:                  205-730-2117 |         - Dr Martin Luther King, Jr
 ----------------------------------------------------------------------------
From: jeff@kuhub.cc.ukans.edu (Jeff Bangert)
Newsgroups: comp.apps.spreadsheets
Subject: Excel--Macro to label scatter plot.
Date: 21 Nov 92 18:20:19 CST
Organization: University of Kansas Academic Computing Services

Is it possible to write a macro which will automatically label the
points in a scatter plot?

What I would like to do is define a range which includes a column of
labels, a column of x values, and a column of y values.  Then, when
the macro is run, it would produce a scatter plot with each point
labeled with a text box.  It would be ok with me if the labels
overlapped.  I could always adjust them by hand.

Thanks for the help,

-- 
Jeff Bangert			jeff@kuhub.cc.ukans.edu
Computer Center			jeff@ukanvax.bitnet
University of Kansas
Lawrence, KS 66045
(913)864-0466
From: danger@acs.bu.edu (jaewon kwak)
Newsgroups: comp.apps.spreadsheets
Subject: How do you find correlation coefficients in Excel?
Keywords: Excel
Date: 21 Nov 92 22:10:15 GMT
Organization: Boston University, Boston, MA, USA

Well, the question is in the subject.  How DO you find
the correlation coefficient of data points in excel or
is the spreadsheet's statistical capabilities limited
to just standard deviation and mean?  

Also, is there a way to find roe?  Roe is the covariance
divided by the product of the standard deviations (I think).

These statistical functions are needed to correlate
the returns for a serious of data points collected from
the Wall St. Journal.

Thank you in advance for any help you can give me.

Jae

Newsgroups: comp.ivideodisc
From: tennis@cs.mcgill.ca (Pascal PROULX)
Subject: Subscription
Organization: SOCS - Mcgill University, Montreal, Canada
Date: Thu, 19 Nov 1992 14:02:06 GMT

Please sign-me up for this listserv.
Thanks you !!!

-- 
###############  Pascal Proulx  #################
############  tennis@cs.mcgill.ca  ##############
#################################################
# McGILL University Computer Science Department #
From: al+@pitt.edu (Alan M Lesgold)
Newsgroups: comp.ivideodisc
Subject: Windows 3.1 Driver for Sony 1550 Videodisc Player?
Keywords: driver videodisc
Date: 23 Nov 92 17:47:56 GMT
Organization: Learning Research & Development Center, University of Pittsburgh
Originator: al@rift.lrdc.pitt.edu

Does anyone have a PD or not-too-expensive Sony videodisc player (Model 1550)
driver for MS Windows 3.1?  Please reply via email to AL+@pitt.edu
Thanks.
--Alan Lesgold
-- 
Office: LRDC, University of Pittsburgh, Pittsburgh, PA  15260, 412-624-7046
Office Fax: 412-624-9149
Home: 1255 Murdoch Road, Pittsburgh, PA  15217, 412-687-9826
Secretary:  Ms. Cassandra Stanley, 412-624-7046
Newsgroups: comp.ivideodisc
From: DORCHARD@ucs.indiana.edu
Subject: Subscription
Organization: Indiana University
Date: Sun, 15 Nov 1992 23:42:36 GMT

Please sign me up for this listserv.
Doug Orchard
Newsgroups: comp.patents