def __panes_rec(self): if self.__vert_split_pos is None and self.__horz_split_pos is None: return "" if self.__vert_split_pos is None: self.__vert_split_pos = 0 if self.__horz_split_pos is None: self.__horz_split_pos = 0 if self.__panes_frozen: if self.__vert_split_first_visible is None: self.__vert_split_first_visible = self.__vert_split_pos if self.__horz_split_first_visible is None: self.__horz_split_first_visible = self.__horz_split_pos else: if self.__vert_split_first_visible is None: self.__vert_split_first_visible = 0 if self.__horz_split_first_visible is None: self.__horz_split_first_visible = 0 if not self.split_position_units_are_twips: # inspired by pyXLWriter if self.__horz_split_pos > 0: self.__horz_split_pos = 20 * self.__horz_split_pos + 255 if self.__vert_split_pos > 0: self.__vert_split_pos = 113.879 * self.__vert_split_pos + 390 result = BIFFRecords.PanesRecord( *map(int, (self.__vert_split_pos, self.__horz_split_pos, self.__horz_split_first_visible, self.__vert_split_first_visible, self.active_pane))).get() return result
def __panes_rec(self): if self.__vert_split_pos is None and self.__horz_split_pos is None: return "" if self.__vert_split_pos is None: self.__vert_split_pos = 0 if self.__horz_split_pos is None: self.__horz_split_pos = 0 if self.__panes_frozen: if self.__vert_split_first_visible is None: self.__vert_split_first_visible = self.__vert_split_pos if self.__horz_split_first_visible is None: self.__horz_split_first_visible = self.__horz_split_pos # when frozen, the active pane has to be specifically set: if self.__vert_split_pos > 0 and self.__horz_split_pos > 0: active_pane = 0 elif self.__vert_split_pos > 0 and self.__horz_split_pos == 0: active_pane = 1 elif self.__vert_split_pos == 0 and self.__horz_split_pos > 0: active_pane = 2 else: active_pane = 3 else: if self.__vert_split_first_visible is None: self.__vert_split_first_visible = 0 if self.__horz_split_first_visible is None: self.__horz_split_first_visible = 0 if not self.split_position_units_are_twips: # inspired by pyXLWriter if self.__horz_split_pos > 0: self.__horz_split_pos = 20 * self.__horz_split_pos + 255 if self.__vert_split_pos > 0: self.__vert_split_pos = 113.879 * self.__vert_split_pos + 390 # when split, the active pain can be set as required: active_pane = self.active_pane result = BIFFRecords.PanesRecord(*map(int, ( self.__vert_split_pos, self.__horz_split_pos, self.__horz_split_first_visible, self.__vert_split_first_visible, active_pane ))).get() return result
def __panes_rec(self): if self.__vert_split_pos is None and self.__horz_split_pos is None: return "" if self.__vert_split_pos is None: self.__vert_split_pos = 0 if self.__horz_split_pos is None: self.__horz_split_pos = 0 if self.__panes_frozen: if self.__vert_split_first_visible is None: self.__vert_split_first_visible = self.__vert_split_pos if self.__horz_split_first_visible is None: self.__horz_split_first_visible = self.__horz_split_pos else: if self.__vert_split_first_visible is None: self.__vert_split_first_visible = 0 if self.__horz_split_first_visible is None: self.__horz_split_first_visible = 0 # inspired by pyXLWriter self.__horz_split_pos = 20 * self.__horz_split_pos + 255 self.__vert_split_pos = 113.879 * self.__vert_split_pos + 390 if self.__vert_split_pos > 0 and self.__horz_split_pos > 0: self.__split_active_pane = 0 elif self.__vert_split_pos > 0 and self.__horz_split_pos == 0: self.__split_active_pane = 1 elif self.__vert_split_pos == 0 and self.__horz_split_pos > 0: self.__split_active_pane = 2 else: self.__split_active_pane = 3 result = BIFFRecords.PanesRecord(self.__vert_split_pos, self.__horz_split_pos, self.__horz_split_first_visible, self.__vert_split_first_visible, self.__split_active_pane).get() return result