OldnGrey wrote:Ken_Burnside: wrote:Offered to look at Shipyard 16 if he'll email it to me.
Sorry, must have missed that, I do not have your email address.
I used the "email user" button here. It's design (at) adastragames [dot] com.
Ken_Burnside: wrote:Oh, improvements are being made. Used to be, Calc puked opening up my sheets. Now it takes 10 minutes, and 2 minutes for a screen refresh when you use a drop-down menu.
Slight overestimate? Or is that a large spreadsheet?
It uses that many drop down menus pulling from named ranges. It's about 6 MB all told, but allows you to define campaign parameters, build weapons, design multiple ships using the same weapon list and campaign parameters, and prints a full page "check box" SSD.
And until 3.0, OO Calc didn't handle about half of the things it did, most notably borking INDEX() and INDIRECT().
Glad to say the shipyard and Wardogs is just about instant refresh. My home built PC does not even have a dual core processor.
One way to fix the blank cell problem, From what I gather, is to insert:
IF(ISBLANK(cell ref);" ";cell ref)
My problem with OO Calc, from someone who plays with compilers for fun (scary person) is that OO Calc made some design decisions about how named ranges and data validation are done that would take extensive re-coding to boost performance. He estimates that it would be a 4-month long side project for him to fix the issue.
When inserting a drop down menu using a cell range as reference, the first cell has to be text or something other than an empty cell or 0.
Point is that I think that any problems can be worked around, they just should not have to be.
Completely agreed.
Paul
