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 ...