Worksheet Size

  • Thread starter Thread starter Roger Emerick
  • Start date Start date
R

Roger Emerick

I notice that Quatro Pro for years has had the ability to
adjust worksheet size. So instead of having 256col x 65k
rows, you could switch and have 65k col x 256 rows, or
anything in between. Does anyone know if Excel will one
day have that feature. I have endlessly made that
recomendation but have never received any kind of
response. Thanks - Roger
 
Hi Roger!

Highly unlikely that will ever happen until Microsoft produce a
non-backwards compatible spreadsheet.

I believe it correct to say that they view adding additional columns
as require too much re-writing of the code where so much is based upon
a 256 limitation.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman Harker said:
Highly unlikely that will ever happen until Microsoft produce a
non-backwards compatible spreadsheet.
Click to expand...
....

Why? Quattro Pro 9, 10 and 11 can open *and* save Lotus 123 files (from
Release 2 .WK1 through Release 9.6 & later .123 [64K rows], Excel 2 through
97 & later .XLS, and its own older .WQ? and .WB? file formats in addition to
the .QPW format that provides 18K columns and 1MM rows).

Granted older versions of the software might not be able to read files in
newer formats (which would do a fair bit of violence to Microsoft's claims
about the benefits of XML formats), but Excel 5 and prior can't read BIFF8.
IOW, Microsoft has managed this before. Then again, that was prior to the
era of Microsof Office hegemony.

Are you saying a relatively starving company like Corel can manage this
level of compatible programming while one of the richest companies in the
world can't? Or perhaps it'd be more accurate to say a company with a >90%
market share becomes as nimble and energetic as an overweight sumo wrestler
with tendonitis and the flu? Or maybe as customer-focussed as the average
government bureaucrat?
 
Hi Harlan!

I think I stated the current view but I'm inclined to your views on
validity of that view.

It does depend upon how the code was written and how much needs to be
changed but they did achieve an increase in rows so... And others have
done it.

I'm hoping though that there will eventually be a non (or very
limited) backwards compatible spreadsheet that can remove a lot of the
problems that continue from version to version in the name of
compatibility.

Just think of how you could improve things if you could start from
scratch. Same as with any project.

But they're unlikely to do it by new Version. More likely keep the
existing Excel and introduce a TurboExcel. You don't bet the house
when the existing product is so successful.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top