Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] Partial Range References (e.g., Fx:F) Throw Errors Instead of Handling Dynamic Ranges Properly #4432

Open
2 tasks done
barralf opened this issue Jan 6, 2025 · 1 comment
Assignees
Labels
feature request New feature or request scope:formula

Comments

@barralf
Copy link

barralf commented Jan 6, 2025

Before you submit this issue, have you checked the following

  • Is this really a problem?
  • I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

sheets 0.5.1

Reproduction link

CleanShot 2025-01-05 at 21 23 09@2x

in GSheets:
CleanShot 2025-01-05 at 21 23 56@2x

Expected behavior

When specifying a partial range reference (e.g., Fx:F where x is any row number), the formula should correctly calculate using only the specified range, starting from the given row (Fx) and continuing to the end of the column. The header row (or any rows above x) should not be included.

Actual behavior

When specifying a partial range reference like Fx:F (e.g., F2:F or F5:F), the formula does not work as expected and throws an error (e.g., #NAME?). To make the formula work, the entire column (e.g., F:F) must be selected, which includes rows that are not part of the intended range (e.g., header rows), leading to incorrect or unintended results.

System information

System:
OS: macOS 14.6.1
CPU: (8) arm64 Apple M1
Memory: 79.08 MB / 16.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 20.17.0 - /usr/local/bin/node
npm: 10.8.2 - /usr/local/bin/npm
Browsers:
Brave Browser: 131.1.73.104
Chrome: 131.0.6778.205
Safari: 17.6

@barralf barralf added the bug Something isn't working label Jan 6, 2025
@jikkai jikkai added feature request New feature or request and removed bug Something isn't working labels Jan 6, 2025
@jikkai
Copy link
Member

jikkai commented Jan 6, 2025

We currently do not support the Fx:F selection area like Excel. However, we will consider providing support.

@Dushusir Dushusir assigned DR-Univer and unassigned Dushusir Jan 13, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New feature or request scope:formula
Projects
None yet
Development

No branches or pull requests

4 participants