lotus



previous page: Records Management FAQ
  
page up: Business Subjects
  
next page: Free Business Books

Spreadsheets FAQ



Frequently Asked Questions about Spreadsheets

This FAQ about Spreadsheets was compiled and written by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

-3. Can you answer my spreadsheet question? (comp.apps.spreadsheets)
Probably not. Please don't mail it to me. There is no reason to ...
-4. How can I add a FAQ and its answer to the FAQ list? (comp.apps.spreadsheets)
Mail BOTH of them to me. Then I can add them to the FAQ and it ...
-5. Should I post a spreadsheet utility I just created/found? (comp.apps.spreadsheets)
Please, no. While it's nice that you want to share, posting ...
-6. Where can I learn about spreadsheets? Suggestions
More entries are always helpful!...
-6. Where can I learn about spreadsheets? Official product web pages
-6. Where can I learn about spreadsheets? Other
Mailing list: Excel ...
-7.1 Why does my spreadsheet say 0.1+0.1+0.1+0.1+0.1-0.5 isn't 0?
if any computer package uses binary floating point numbers (...
-7.2 How can I round to the nearest multiple of 3? or the nearest nickel? (spreadsheets)
if you have a ROUND() function, simply divide by your grouping,...
-7.4 How many columns or rows does my spreadsheet allow?
look in your manual! why do so many people post this ...
-7.5.1 Science and Engineering (spreadsheets)
book/CD:
-7.6 How do I deal with dates and times in my spreadsheet?
this depends on your spreadsheet....
-8.0 1-2-3 history (spreadsheets: Lotus 1-2-3)
-9.0 Quattro
Quattro
-10.0 Excel history
http://www.microsoft.com/msexcel/productinfo/macintosh/xlhistry....
-10.2 How can I do a Save-As or Exit without prompting the user? (spreadsheets: Excel)
VBA:
-10.4 Why do I get "File format no longer supported"? (spreadsheets: Excel)
If some other application overwrites the OLE DLLs, you will ...
-10.5 What's this about the 15 digit numbers that return 0.64 or 1.28? (spreadsheets: Excel)
according to Microsoft, the problem numbers are:...
-10.6 How can I read Excel files without Excel?
10.6.0 from a ...
-10.7 What's this about an Excel virus?
see http://support.microsoft.com/support/kb/articles/q154/1/31....
-10.8 When I start up Excel, it tries to open a lot of files; some of them are non-Excel files...
...(sometimes my AUTOEXEC.BAT and CONFIG.SYS,...
-10.9 Any number I type in gets divided by a power of 10. Why? (spreadsheets: Excel)
Excel has an option `Fixed Decimal Places', which divides ...
-10.11 I get odd (square?) characters where I expect commas (thousands) or slashes (dates). What happened? (spreadsheets: Excel)
check your International settings in Control Panel. when these ...
-10.13 Why is =-1^2 positive and =0-1^2 negative? (spreadsheets: Excel)
nonstandard operator precedence -- the `unary minus' has a ...
-10.14 How can I save a chart as a GIF file? (spreadsheets: Excel)
see http://support.microsoft.com/support/kb/articles/q168/5/61....
-10.15 Excel says I have links -- but I can't find them. Where are they?
see http://support.microsoft.com/support/kb/articles/q188/4/49....
-10.15.1 How can I get a list of names defined in a spreadsheet in a form I can search for, print, compare with others, etc.? (spreadsheets: Excel)
it's built-in => Insert|Name|Paste|Paste ...
-10.17 Why doesn't my spreadsheet recalculate? (spreadsheets: Excel)
Microsoft Excel has been notorious for not ...
-10.17.1 Why do my User-Defined Functions return #VALUE! occasionally? (spreadsheets: Excel)
there is a problem with Excel 95 user-defined functions, in which ...
-10.18.1 How do I sum up or count column A when corresponding cells in column B match some condition? (spreadsheets: Excel)
use an array formula; in MS-Windows, you enter an array ...
-10.18.2 How come my SUM(IF()) array formula doesn't work? (spreadsheets: Excel)
Excel (even v8, Excel 97) does not handle AND() or OR() in ...
-10.19 What is the correct, registered MIME Content-Type for Excel files?
application/vnd.ms-...
-10.20 How do I protect myself in Excel against "unary" minus type bugs in my formulas?
You can use the AutoCorrect feature to prevent yourself ...
-10.21 Why does Excel claim I have an invalid `SYLK' file?
Because the Excel programmers are sloppy. A valid SYLK file ...
-12.0 Discussion (Spreadsheet Optimizers / Solvers)
these products take as inputs:...
-13.0 Discussion (Spreadsheet Errors, Checkers, Auditors)
Raymond Panko's Spreadsheet ...
-14.0 General References (spreadsheets: Obscure File formats)
Wotsit: Database and ...
-14.1 Tab-delimited format (spreadsheets)
Stores: ...
-14.2 CSV (Comma-Separated Values) format (spreadsheets)
Stores: ...
-14.3 DIF (Data Interchange Format) (spreadsheets)
note that this is not Directory Interchange Format, ...
-14.4 Lotus 1-2-3 and Symphony formats (spreadsheets)
these are capable formats, but their complexity makes them ...
-14.5 Quattro and Quattro Pro formats (spreadsheets)
this is a capable format, but its complexity makes it ...
-14.6 SYLK format (spreadsheets)
this is a capable single-sheet format, and would be best for ...
-14.7 Excel formats
these are capable formats, but their extreme complexity ...
-15.1 sc (Free spreadsheets, and source code)
Spreadsheet ...
-16.0 Section criteria (Commercial spreadsheets for UNIX)
I will happily include a pointer to any Internet resource (...
-99. Credits (comp.apps.spreadsheets)
I expect most of the information in this FAQ to be supplied by ...









TOP
previous page: Records Management FAQ
  
page up: Business Subjects
  
next page: Free Business Books