Re: Incorrect XY binning for matrix chart (Gnumeric 1.12.52)
You are right, the maximum is exclusive. Please file a bug report if it is an issue for you. Best regards, Jean Le jeudi 21 juillet 2022 à 22:37 +0200, Davide Baldini via gnumeric- list a écrit : > Looking more carefully, the matrix binning is correct. The problem is > with the > bounds definitions on the color axis, which in the chart I attached > are defined as: > > minimum: min(Sheet1!$C:$C) > maximum: max(Sheet1!$C:$C) > > For whatever reason, the minimum bound is treated as inclusive, while > the > maximum as exclusive, and therefore the datum with the highest Z > value is not > plotted. If I redefine the bounds as follows this datum is plotted: > > minimum: min(Sheet1!$C:$C) > maximum: max(Sheet1!$C:$C) + 1e-15 > > -- Davide > ___ > gnumeric-list mailing list > gnumeric-list@gnome.org > https://mail.gnome.org/mailman/listinfo/gnumeric-list ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Incorrect XY binning for matrix chart (Gnumeric 1.12.52)
Attached is a Gnumeric file containing a matrix chart with separate color axis showing incorrect binning on both the X and Y axes for the last datum in the data table (row #14). The datum is plotted astray by an offset of multiple bins from its correct bin. This defect occurs if I manually define min and max bounds on the matrix color axis, which I assume is the Z axis. Toggling the bounds definition from manual to automatic produces the correct XY binning. -- Davide heatmap_example.gnumeric Description: application/gnumeric ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Incorrect XY binning for matrix chart (Gnumeric 1.12.52)
Looking more carefully, the matrix binning is correct. The problem is with the bounds definitions on the color axis, which in the chart I attached are defined as: minimum: min(Sheet1!$C:$C) maximum: max(Sheet1!$C:$C) For whatever reason, the minimum bound is treated as inclusive, while the maximum as exclusive, and therefore the datum with the highest Z value is not plotted. If I redefine the bounds as follows this datum is plotted: minimum: min(Sheet1!$C:$C) maximum: max(Sheet1!$C:$C) + 1e-15 -- Davide ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list