Le mardi 14 juillet 2009 à 11:44 +0800, Jason Heeris a écrit : > Hi, > > Using Gnumeric 1.9.9 under Debian Squeeze (GNOME 2.26.1). > > I've been trying to find any information on displaying quantities > using SI/engineering prefixes, especially in plots. Basically, I want > to display my x-axis markers as Hz, 10 Hz, 100 Hz, 1 kHz, 10 kHz, etc. > Is there an way to do this?
Not at the moment. It would need an implementation at the format level. Please consider filing a bug/enhancement report at bugzilla.gnome.org > I can figure out how to do it for the column of data itself using > lookups, logs and rounding: > > =concatenate(text(A2/10^(3*floor(log(A2)/3)),$E$9),lookup(floor(log(A2)),E$3:F$6)) > > ...where $E$9 is a formatting string for the number itself (eg. "0") > and E$3:F$6 is a lookup table for SI prefixes by power of 10. Ugly but > works. > > But I can't figure out how (or if it's possible) to do a similar thing > for plots. > > I found a discussion from January 04, but no further mention: > > http://mail.gnome.org/archives/gnumeric-list/2004-January/msg00032.html > > Cheers, > Jason Heeris > _______________________________________________ > gnumeric-list mailing list > gnumeric-list@gnome.org > http://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
