[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: RFC: Not using adjustable precision in KSpread
From:       James Richard Tyrer <tyrerj () acm ! org>
Date:       2007-05-06 0:15:42
Message-ID: 463D1E2E.6090500 () acm ! org
[Download RAW message or body]

Tomas Mecir wrote:
> Greetings, everyone.
> 
> It'e been quite some time since I've been last active here, but with
> the freeze of kdelibs and me getting a new computer, keeping kdelibs
> up-to-date is no longer a full-time activity, so I'm going to delve
> into KSpread once again.
> 
> I am considering changing one thing that has been troubling me about
> KSpread for some time now - the fact that the displaying of numbers is
> attempting to adjust the precision by the cell width. I'm
> intentionally saying attempting, because my experience with that is
> that these attempts are quite slow (possibly one of the reasons why
> the cells render slowly), and the displaying gets it wrong half the
> time anyway.
> 
> So. What I am proposing is changing the displaying code to use a fixed
> number of decimals when displaying numbers. Thus, if you put "3.45678"
> into cell A1, you will see "3.46" regardless on the width of the cell.
> If you want to see higher precision, you have to change the cell
> formatting to display a different number of digits. The "Variable"
> precision would cease to exist. All computations would still be done
> at max precision, of course.
> 
> The disadvantage is that it's slightly harder to use the app for
> high-precision computing, but that's not a problem as changing the
> formatting isn't hard.
> 
> The advantage would be that displaying would go faster and the display
> wouldn't get broken half the time due to the width calculation getting
> the number width wrong.
> 
> Note that OpenOffice.org is doing it exactly this way and nobody seems
> to have any problems with it being so, which inspired me to suggest
> doing the same.
> 
> Opinions ?

That is the way most spreadsheets do it, including Gnumeric.  The format 
setting determines the number of digits and if it doesn't fit the cell 
width, you get #s.

If you don't do it this way, how can you adjust the column width to fit 
the contents?

-- 
JRT
_______________________________________________
koffice-devel mailing list
koffice-devel@kde.org
https://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread]