spreadsheet

commit

49d50451dc8c179616645febfc53380052d1816d

parent

ccd825d4e093e8db01ff9d4e18cbe8639cff6f2e

Author

Tobias Bengfort <tobias.bengfort@posteo.de>

Date

2024-07-23 04:01

make functions case-insensitive

Diffstat

1 files changed, 3 insertions, 3 deletions

diff --git a/sheet/sheet.py b/sheet/sheet.py

@@ -71,7 +71,7 @@ class Sheet:
   71    71     def call_function(
   72    72         self, name: str, args: list[tuple], _commas: list[str]
   73    73     ) -> float|int|str|Bar:
   74    -1         if name == 'sum':
   -1    74         if name.lower() == 'sum':
   75    75             if len(args) != 1 or args[0][0] != 'range':
   76    76                 raise ValueError(args)
   77    77             _, ref1, ref2 = args[0]
@@ -79,13 +79,13 @@ class Sheet:
   79    79                 to_number(self.get_value(ref))
   80    80                 for ref in iter_range(ref1[1], ref2[1])
   81    81             )
   82    -1         elif name == 'power':
   -1    82         elif name.lower() == 'power':
   83    83             if len(args) != 2:
   84    84                 raise ValueError(args)
   85    85             base = to_number(self.evaluate(args[0]))
   86    86             exp = to_number(self.evaluate(args[1]))
   87    87             return base ** exp
   88    -1         elif name == 'bar':
   -1    88         elif name.lower() == 'bar':
   89    89             if len(args) != 1:
   90    90                 raise ValueError(args)
   91    91             return Bar(to_number(self.evaluate(args[0])))