Re: why>?

Tech-Archive recommends: Fix windows errors by optimizing your registry

aaron.kempf@xxxxxxxxx wrote...
....
i just find it funny.. i really dont get the point of Excel. it really
really disturbs me that so many people use it; it just leads to dirty
dirty data.
....

If it's data you want, Excel isn't ideal. We agree on that. However,
data isn't the only thing most people want. That's what you don't get.

i just wish that there was an easier way to extract

a) just the values
b) just the formulas from excel.

those should be easy to extract.
....

Values are very simple to extract. The best way depends on the
destination for the values.

Formulas are trickier, but all it takes is one tested macro in
Personal.xls to write formulas to text files.

I should be able to say 'select formulas from YourCrapWorkbook' in
order to get the formulas out.

I shoud be able to say 'select data from YourCrapWorkbook' and it will
give me the data.
....

Why should it be any easier than 'select pixel_x_coord, pixel_y_coord
from SomePNGfile where pixel_color = "Red"'? Spread*** files are
meant for use with SPREADSHEETS. If you want to pull data from
spread*** files into databases, you could write udfs to simplify the
task. Or you could write macros in Excel to spit out 3-field tables of
cell address, value and formula fields as CSV files. But there's no
good reason I can see why spreadsheets should be query-able as database
objects unless the DBMSs provide the tools to do so.

If you have real, double, single datatypes in a workbook; but you have
integer formatting

This is an issue in ALL software that uses floating point math, not
just spreadsheets, and database reports can also format noninteger data
to appear as whole numbers.

I should be able to get to the data-- in notepad; in another
spread***; or wherever the hell i want to-- in either the raw format
or the formatted datatypes.

You want it raw, there's the dreaded copy & paste. You want it
formatted, *print* it as a text file. It's not that difficult.

i should be able to pull out the formuls without excel automation... so
that i can export all the formulas from 100 different workbooks and
compare and contrast.
....

Dream on. It's not that difficult to do with macros as long as you're
used to writing text file I/O in VBA.

Excel 2007 isn't going to solve the problem.
....

Agreed. It's going to make it worse. The new UI is going to make it
easier for users to find features they don't understand how to use, and
it's going to entice them into wasting as much time formatting their
files as they waste picking out desktop wallpaper and tweaking themes.

Excel Developers have no place in the workplace in the year 2006.

your dip*** jobs are outsourced to india effective 5 years ago.

Wrong again. Your job may soon be shipped over there, but mine's safe
because I'm not a software developer. Excel is just one of many tools I
use.

those dip*** executives back in 2000-2002 fired the wrong people.
....

If they fired you, they at least got that right.

.

Quantcast