Skip to content

LEFT and RIGHT functions are returning incorrect results #958

Closed
Closed
LEFT and RIGHT functions are returning incorrect results#958
Labels
BugSomething isn't working

Description

@dksingla
dksingla
opened on Apr 11, 2022

Description

Below is an example of the LEFT formula

[["0003", "=LEFT(A1,2)"]];

It returns 3, instead, it should return 00 as LEFT takes the first argument of the typed string.

Activity

  1. dksingla
    added
    BugSomething isn't working
    on Apr 11, 2022
  2. handsontable
    locked and limited conversation to collaborators on Apr 11, 2022
  3. sequba
    converted this issue into a discussion #959 on Apr 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugSomething isn't working

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions