Beta

Poor man's spreadsheet API

6user6793616
Description
Loading description...
Performance
Parsing
Fundamentals
View
AllIssues3QuestionsSuggestionsShow Resolved
  • Please sign in or sign up to leave a comment.
  • Voile Avatar

    Random tests exist but they mostly serve only as a performance check: notably the #REF checks is only done in the most rudimentary form in the fixed tests, so it can be very easily hard-coded.

    Also this rule is in the description:

    When a cell's formula is cyclic, its formula property should return "#REF", and its value property NaN.

    But the tests only check the latter. The #REF test for formula was only done for off-grid references.

  • Voile Avatar

    Fixed tests for copyFrom is lacking: there is only one .range("E1").copyFrom("D1").

    • user6793616 Avatar

      After 5 years of silence, I cannot be bothered. Sorry, but this platform is disfunctional. Keep up the good work.

    • Voile Avatar

      Well, you need to get some people to solve difficult katas. Most power users are too satisfied solving easy katas ;-)

    • dfhwze Avatar

      The beta community is too small and inactive, many don't even vote or rank kata's, let alone approve a kata. I understand the causes behind the cynical comment of this former user.

  • ZED.CWT Avatar
     
    T = new Spreadsheet()
T.range('O17:V21').value = 10
T.range('N12:P20').copyFrom('P16:R21')
console.log(T.range('N18').value)

    Aligned N12:P17 with P16:R21

    proceed as if sourceRange was tiled to itself in order to produce as many rows and columns as needed

    So aligned N18:P23 with P16:R21

    Thus N18 is copied from P16, which is 0 But reference solution output 10