Re: why>?

Oh Harlan.

my language is SOOOOOOOOOOOOOOOOOOO much more powerful than yours.
I just find it laughable.

For starters; i dont have arbitrary liimits on 7 levels of nesting.

I can write functions and share them with the rest of my company.

And I can utilize RegExp just like you can. I dont need to load
another library; I dont have go to against my IT departments rules-- by
downloading some silly little DLL.


My LIKE clause is quite powerful.
I have case when then; i have EVERY function that you have in Excel
except what.. 3?

and I've got performance.

I can create pivots like you wouldn't believe.. instead of making
another copy of every cell-- pivotTables BLOAT excel like you wouldn't
believe

I've got lean, mean pivotTables and they run circles around you.

I've got spreadsheets without a 65535 limit.

All I'm saying is that Excel doesn't have the bulk update functionality
that databases do.

Excel has one strength-- presentation.

Databases are

a) better at presentation
b) better at storage
c) better at updating
d) better at performance


your silly little spreadsheets just need to go away.

I am just glad that you kids have to run around and spend all day
patching Excel.

there hasn't been a single security vuln in SQL Server in what.. 3
years?

How many zero-day vulns are in the wild for Excel right now??

THANK GOD

I just wish that companies would realize what a time-waster Excel is..
format each box; STOP BUYING OFFICE if you must.

there is a sunny life without spreadsheets.
instead of emailing it around and then you need to call george and ask
him to re-sync his copy; yeah 'george and you please copy and paste
your numbers in now'

what a joke.

-Aaron





Harlan Grove wrote:
dbahooker@xxxxxxxxxxx wrote...
UPDATE XLS_FORMULAS
SET FormulaText = replace(formulatext, 'TRIM', 'LTRIM')
WHERE Worksheet = ''sheet1' and row = 'A' AND formulatext like NOT LIKE
'LTRIM'

you see harlan?

my formulas are infinitely customizable.
...

Incremental refinement is good. Pity you failed to fix the row equals
letter bug. Using LIKE is nice, but how would you change references
like A1001 to A2001 while leaving numeric constants 1001 and cell
references A10010 unchanged? That is, replace references into
A1001:A1999 with references into A2001:A2999 where A1001 becomes A2001,
A1002 becomes A2002, etc.? Using regular expressions it's just

re.Pattern = "(\W)(\$?[A-Z]{1,2}\$?)1([1-9]\d{2}|\d{2}[1-9])\b"
.Formula = re.Replace(.Formula, "$1$22$3")

This is just a purely textual replacement. I could have used re.Execute
and used the Submatches collection to extract the row number, applied a
numeric transformation, then rebuilt the formula.

Try doing this with SQL's toy LIKE operator.

Learn some REAL text processing tools, you query-spewing,
SQL-thumb-sucking baby!

.

Loading