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 559005 - lookup critical
lookup critical
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
git master
Other All
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2008-11-02 22:53 UTC by sum1
Modified: 2008-11-03 21:30 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description sum1 2008-11-02 22:53:48 UTC 
Version: r16943
OS: Ubuntu Intrepid

Steps to reproduce:
- In A1, enter "=lookup(159,Print_Area,U109)" (no quotes)

Console output:

CRITICAL **: value_area_get_x_y: assertion `a_row<=b_row' failed


Backtrace:

Breakpoint 1, 0xb6e3d926 in g_log () from /usr/lib/libglib-2.0.so.0
(gdb) bt

+ Trace 209127

  • #0 g_log
    from /usr/lib/libglib-2.0.so.0
  • #1 g_return_if_fail_warning
    from /usr/lib/libglib-2.0.so.0
  • #2 value_area_get_x_y
    at value-sheet.c line 218
  • #3 value_area_fetch_x_y
    at value-sheet.c line 149
  • #4 gnumeric_lookup
    at functions.c line 902
  • #5 function_call_with_exprs
    at func.c line 1247
  • #6 gnm_expr_eval
    at expr.c line 1339
  • #7 gnm_expr_top_eval
    at expr.c line 2858
  • #8 gnm_cell_eval_content
    at dependent.c line 1455
  • #9 gnm_rendered_value_new
    at rendered-value.c line 210
  • #10 gnm_cell_render_value
    at cell.c line 469
  • #11 row_calc_spans
    at cellspan.c line 411
  • #12 sheet_range_bounding_box
    at sheet.c line 2259
  • #13 scg_redraw_range
    at sheet-control-gui.c line 147
  • #14 sc_redraw_range
    at sheet-control.c line 89
  • #15 sheet_redraw_partial_row
    at sheet.c line 1019
  • #16 sheet_cell_calc_span
    at sheet.c line 1111
  • #17 sheet_cell_set_text
  • #18 cmd_set_text_redo
    at commands.c line 851
  • #19 command_push_undo
    at commands.c line 742
  • #20 cmd_set_text
  • #21 wbcg_edit_finish
    at wbc-gtk-edit.c line 222
  • #22 cb_gee_key_press_event
    at gnumeric-expr-entry.c line 522 






Comment 1


Morten Welinder





          2008-11-03 21:30:00 UTC
        



This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.

Excel's semantics is utterly insane if the third argument is smaller than
it ought to be: Excel extends the range.  I have commented out that part
(and it will not compile without changes elsewhere) since our dependency
system won't handle it anyway.