Skip to content

[area:live-data] Sorting a range that includes a live block: the next refresh puts the live columns back, and the columns typed beside them end up on the wrong rows #235

Closed

Description

@SuruchBoss

Found by the PO while reviewing #234 (#232), on a production build of 7fa77b2. Not touched by #234: sortSelection has no live-data guard on main either.

Repro (1280, Thai)

  1. Live data → "ลองต่อ: ยอดขายสด" → Test → Save and add → Insert. The block lands at A1:G6 (sku, name, category, price, qty, total, updated_at), refreshing every 5 s.
  2. In H2:H6, beside the block, type a note per row: n-CF-01, n-CF-02, n-BK-01, n-BK-02, n-TE-01.
  3. Select D2 (price) and press "เรียงจากมากไปน้อย". The sort range grows over A1:H6.
  4. Wait for the next refresh.
Row Right after the sort (A | H) After the refresh (A | H)
2 CF-01 | n-CF-01 CF-01 | n-CF-01
3 CF-02 | n-CF-02 CF-02 | n-CF-02
4 BK-02 | n-BK-02 BK-01 | n-BK-02
5 BK-01 | n-BK-01 BK-02 | n-BK-01
6 TE-01 | n-TE-01 TE-01 | n-TE-01

The sort moved the whole rows, the refresh rewrote A:G in the source's order, and H stayed sorted. Two notes now sit on the wrong product, with no message. The sort itself was announced as done.

Done when

Part of the hold set (silent wrong values). Queue: after #51, before #219.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions