After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 777338 - Formating the values of "Data Labels"
Formating the values of "Data Labels"
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Charting
git master
Other All
: Normal enhancement
: ---
Assigned To: Jean Bréfort
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2017-01-16 15:38 UTC by Ali Akcaagac
Modified: 2017-01-22 19:01 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
gnumeric uncompressed workbook (121.91 KB, text/xml)
2017-01-16 18:04 UTC, Ali Akcaagac
  Details
gnumeric chart screenshot (65.17 KB, image/png)
2017-01-16 18:04 UTC, Ali Akcaagac
  Details
chart expected result (example) (19.72 KB, image/png)
2017-01-16 18:17 UTC, Ali Akcaagac
  Details
Proposed patch (6.54 KB, patch)
2017-01-21 13:29 UTC, Jean Bréfort
none Details | Review

Description Ali Akcaagac 2017-01-16 15:38:35 UTC
I would like to report an issue that I've been having with gnumeric 1.12.32 (Fedora 25).

In combination to my previous bugreport!

https://bugzilla.gnome.org/show_bug.cgi?id=777336

I would like to add the following.

When printing "data labels1", the values it prints can not be formatted.

For example:

The series is formatted as follows "112.12312312546546"

Formatted to using 2 digits "112.12"

But when using data labels1, the same series it has to print on the data labels can not be formatted. The data labels will show the unformatted series like:

"112.12312312546546"

It would be nice, being able to format the data labels as well. e.g. I would like to be able to format it to using 2 digits "112.12" for example.
Comment 1 Morten Welinder 2017-01-16 16:46:00 UTC
Please attach a sample file that shows the problem
Comment 2 Ali Akcaagac 2017-01-16 18:04:35 UTC
Created attachment 343579 [details]
gnumeric uncompressed workbook
Comment 3 Ali Akcaagac 2017-01-16 18:04:57 UTC
Created attachment 343580 [details]
gnumeric chart screenshot
Comment 4 Ali Akcaagac 2017-01-16 18:17:03 UTC
Created attachment 343583 [details]
chart expected result (example)

... and here is what I would like to see. Values that I can adjust to e.g. 2 digits (or 3 digits or 4 digits) float. It's easier to read this, than having values like 0.214235435253432 printed on the labels :)
Comment 5 Morten Welinder 2017-01-18 15:42:35 UTC
I see the problem.  Either we should allow a format, or else we should use
the format in the sheet.

The work-around for now is to round the values and then plot the rounded
values.  That really isn't very satisfying, but it might get you going
for now.
Comment 6 Jean Bréfort 2017-01-20 08:57:32 UTC
The code should use the cells format, but somehow it does not. Weird.
Comment 7 Jean Bréfort 2017-01-21 13:29:30 UTC
Created attachment 343954 [details] [review]
Proposed patch

When the format changes, the graph is not updated automatically, see #671348.
Comment 8 Morten Welinder 2017-01-22 18:19:12 UTC
Jean: I don't understand the item-cursor and wbc-gtk changes.  Are they
supposed to be part of this?
Comment 9 Jean Bréfort 2017-01-22 18:29:01 UTC
Oops, no, not related. I don't even remember what these changes are for.
Comment 10 Morten Welinder 2017-01-22 18:47:45 UTC
Other than that, go for it
Comment 11 Jean Bréfort 2017-01-22 19:01:25 UTC
This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.