Source code for fastpyxl.worksheet.formula

# Copyright (c) 2010-2024 fastpyxl

from fastpyxl.compat import safe_string



class DataTableFormula:


    t = "dataTable"

    def __init__(self,
                 ref,
                 ca=False,
                 dt2D=False,
                 dtr=False,
                 r1=None,
                 r2=None,
                 del1=False,
                 del2=False,
                 **kw):
        self.ref = ref
        self.ca = ca
        self.dt2D = dt2D
        self.dtr = dtr
        self.r1 = r1
        self.r2 = r2
        self.del1 = del1
        self.del2 = del2


    def __iter__(self):
        for k, v in (
            ("t", self.t), ("ref", self.ref), ("dt2D", self.dt2D),
            ("dtr", self.dtr), ("r1", self.r1), ("r2", self.r2),
            ("del1", self.del1), ("del2", self.del2), ("ca", self.ca),
        ):
            if v:
                yield k, safe_string(v)





class ArrayFormula:

    t = "array"


    def __init__(self, ref, text=None):
        self.ref = ref
        self.text = text


    def __iter__(self):
        for k, v in (("t", self.t), ("ref", self.ref)):
            if v:
                yield k, safe_string(v)