Skip to content

fix(sheets-ui): recover real value on Microsoft Excel paste with ####…#6539

Open
koushen001 wants to merge 2 commits into
dream-num:devfrom
koushen001:fix/excel-paste-hash-recovery
Open

fix(sheets-ui): recover real value on Microsoft Excel paste with ####…#6539
koushen001 wants to merge 2 commits into
dream-num:devfrom
koushen001:fix/excel-paste-hash-recovery

Conversation

@koushen001

@koushen001 koushen001 commented Jan 30, 2026

Copy link
Copy Markdown

When copying cells from Microsoft Excel with insufficient column width, Excel's HTML clipboard shows "#######", but the plain text clipboard contains the actual value.

This change uses the plain text data to restore the real number while preserving formats like thousand separators.

  • Add plainText parameter to HtmlToUSMService.convert()
  • Parse clipboard plain text (TSV format) into 2D grid for cell lookup
  • Restore actual value when HTML content displays #######
  • Differentiate between genuine "#######" strings and width-truncated display
  • Preserve number formatting (thousand separators, decimals, etc.)

close #xxx

Pull Request Checklist

  • Related tickets or issues have been linked in the PR description (or missing issue).
  • Naming convention is followed (do please check it especially when you created new plugins, commands and resources).
  • Unit tests have been added for the changes (if applicable).
  • Breaking changes have been documented (or no breaking changes introduced in this PR).

…### display

When copying cells from Microsoft Excel with insufficient column width,
Excel's HTML clipboard shows "#######", but the plain text clipboard
contains the actual value.

This change uses the plain text data to restore the real number while
preserving formats like thousand separators.

- Add plainText parameter to HtmlToUSMService.convert()
- Parse clipboard plain text (TSV format) into 2D grid for cell lookup
- Restore actual value when HTML content displays #######
- Differentiate between genuine "#######" strings and width-truncated display
- Preserve number formatting (thousand separators, decimals, etc.)

Co-Authored-By: Claude <noreply@anthropic.com>
@koushen001 koushen001 closed this Jan 30, 2026
@koushen001 koushen001 deleted the fix/excel-paste-hash-recovery branch January 30, 2026 02:10
@koushen001 koushen001 restored the fix/excel-paste-hash-recovery branch January 30, 2026 02:17
@koushen001

Copy link
Copy Markdown
Author
Test data After repair Before repair

@koushen001 koushen001 reopened this Jan 30, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant