bugPSPP - Bugs: bug #52035, sheet: Only the cell in the first...


bug #52035: sheet: Only the cell in the first column of the first empty row is editable and can create a new Case

Submitter:  Friedrich Beckmann <beckmanf>
Submitted:  Fri 15 Sep 2017 10:13:20 AM UTC
Category:  Sheet Severity:  3 - Ordinary
Status:  Need Info Assigned to:  None
Open/Closed:  Open Release:  None
Effort:  0.00
* Mandatory Fields

Add a New Comment Rich Markup

Sat 23 Sep 2017 10:06:42 AM UTC, comment #2: 

I agree, that an arbitrary place in the sheet is not o.k. but the pre-sheet-widget version behaves different:

old: A new value in any column of the first row after the last case creates a new case.
There were no further rows visible after the last case, except for this one empty row.

new: Only a new value in the FIRST column of the first row after the last case creates a new case. Endless number of empty rows are visible.

I think that the previous behavior is preferable because you can by gui design not even see cells which you cannot click but an edit in the last empty row creates a new case.

The same is true for columns. Here it is maybe even more obvious that adding a new value for any case in the next empty column should create a new variable. To see more empty columns than the one which is editable is misleading.

So as you say it would be bad design to have an edit possible at an arbitrary place in the empty sheet to create new cases / variables but from my perspective the previous gui design was already ideal. -> No cells visible that you cannot edit. An edit in the visible empty cells creates a new case or a new variable.

Friedrich Beckmann <beckmanf>
Group Member
Sat 23 Sep 2017 06:24:39 AM UTC, comment #1: 

This was intentional.    The rationale was that it is probably a mistake if the user adds a case with many missing values, and inadvertently hitting a button when the cursor is at an arbitrary place on the sheet could cause lots of "junk" to be entered which would be hard to undo.

John Darrington <jmd>
Group administrator
Fri 15 Sep 2017 10:13:20 AM UTC, original submission:  

I tested this on MacOS with the new sheet widget 0.1 and gtk3 3.22.19

Only the cell in the first column of the first empty row is editable. Typing data there will create a new case. However it is not possible to edit any other cell in that row.

To reproduce this

 - Create 4 variables a,b,c,d
 - Add Data for one case 1,2,3,4
 - Click in Row 1 Column 4 to have a defined focus
 - Click in Row 2 Column 4 -> You cannot edit/add data and create a new case
 - Click in Row 2 Column 1 -> You can edit data and create a new case

Friedrich Beckmann <beckmanf>
Group Member


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by jmd (Posted a comment)
  • -email is unavailable- added by beckmanf (Submitted the item)

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.


    Follow 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2017-09-23 jmd Severity5 - Average 3 - Ordinary
        StatusNone Need Info

    Back to the top

    Powered by Savane 3.13-b921.
    Corresponding source code