Can't toggle editing as simple text or as pop-up sheet

[danpoynor]

Hi,

I've just installed and started using Sequel Pro 0.9.9.1 (build 3408)
on Mac OS X 10.6.8.

There's an icon in the bottom of the application window which when
hovered over says "Toggle between editing simple text cells as a
spreadsheet or in pop-up sheets". When I click on the icon a blue
outline appears around one of the tiny icon boxes, but the behavior
doesn't change how a cell is edited. I would expect the pop-up to stop
appearing and I should be able to edit the contents of the cell as
though I was editing a spreadsheet cell.

Is there somewhere I can file a bug report?

Or - how do I stop the pop-up window from appearing every time I want
to make a simple text edit to the contents of a cell?

Thanks,
DAN

[illustrata]

I have the same problem...the drop-down appears no matter how the icon is toggled (blue or gray). Is there another setting?

[Roland Barker]

Same problem here...can't seem to stop that pop-up sheet from opening! I've tried toggling the preference in either/both locations to no avail.

SequelPro 1.0.2

OS X 10.8.4

[Rowan Beentje]

Hi Dan/Roland,

There's three things that trigger editing in a pop-up sheet:

1) If the preferences value/toolbar setting is toggled, *all* cells trigger editing. This is typically what's tripping up people but it sounds like it's not the case for you.
2) If a cell contains linebreak or carriage return characters, the sheet is opened for simpler editing.
3) If a column is set to a BLOB type, indicating probably non-text data, the sheet is opened for easier non-text editing.

Is one of the later options a possibility?

Rowan

> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sequel-pro+...@googlegroups.com.
> To post to this group, send email to seque...@googlegroups.com.
> Visit this group at http://groups.google.com/group/sequel-pro.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

[Roland Barker]

That's interesting to know, but these are in my case TINYTEXT fields with a single line in them, no line breaks. I need to be able to make a lot of manual edits quickly. For instance, you can use the arrow keys to advance to the next field...it is selected and editable. but when you start typing, that window slides open, slowing things down and adding unnecessary keystrokes.

[Rowan Beentje]

Ah... you're absolutely right, we also always show the sheet for TEXT fields. Sigh.

That decision probably dates back to when the code didn't support linebreak detection. I think the logic could probably be rethought; how does the following sound:

1) Always show sheets for BLOB types
2) Always show sheets if the cell contains linebreak or carriage return characters
3) If a text-like field (char, varchar, text, and variations) has a column type length longer than... 256?... display the sheet to edit it.

I've created a new ticket at http://code.google.com/p/sequel-pro/issues/detail?id=1781 to discuss this further before implementation, replies off-list to there now please :)

Cheers,
Rowan