Hello community, here is the log from the commit of package python3-openpyxl for openSUSE:Factory checked in at 2015-05-27 12:51:35 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Comparing /work/SRC/openSUSE:Factory/python3-openpyxl (Old) and /work/SRC/openSUSE:Factory/.python3-openpyxl.new (New) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Package is "python3-openpyxl" Changes: -------- --- /work/SRC/openSUSE:Factory/python3-openpyxl/python3-openpyxl.changes 2015-05-02 21:42:34.000000000 +0200 +++ /work/SRC/openSUSE:Factory/.python3-openpyxl.new/python3-openpyxl.changes 2015-05-27 12:51:36.000000000 +0200 @@ -1,0 +2,17 @@ +Tue May 26 16:18:53 UTC 2015 - arun@gmx.de + +- update to version 2.2.3: + * Enable 64bit extensions for all versions of Python. + * Update docs. + * Do not preserve relation to printer part without preserving the + printer part. + * Don't force namespace on worksheet child as we set the default + namespace for all worksheets. + * Use print() instead of print statement + * Pass locale settings into envs (needed for somethings for tox 2 >= + 2). + * Fix failing doctest. + * Correct the schema for saving strings. + * fixed typo in sample code + +------------------------------------------------------------------- Old: ---- openpyxl-2.2.2.tar.gz New: ---- openpyxl-2.2.3.tar.gz ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Other differences: ------------------ ++++++ python3-openpyxl.spec ++++++ --- /var/tmp/diff_new_pack.RWtpq3/_old 2015-05-27 12:51:37.000000000 +0200 +++ /var/tmp/diff_new_pack.RWtpq3/_new 2015-05-27 12:51:37.000000000 +0200 @@ -17,7 +17,7 @@ Name: python3-openpyxl -Version: 2.2.2 +Version: 2.2.3 Release: 0 Summary: A Python library to read/write Excel 2007 xlsx/xlsm files License: MIT and Python-2.0 ++++++ openpyxl-2.2.2.tar.gz -> openpyxl-2.2.3.tar.gz ++++++ diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/PKG-INFO new/openpyxl-2.2.3/PKG-INFO --- old/openpyxl-2.2.2/PKG-INFO 2015-04-28 19:11:08.000000000 +0200 +++ new/openpyxl-2.2.3/PKG-INFO 2015-05-26 14:29:15.000000000 +0200 @@ -1,6 +1,6 @@ Metadata-Version: 1.1 Name: openpyxl -Version: 2.2.2 +Version: 2.2.3 Summary: A Python library to read/write Excel 2007 xlsx/xlsm files Home-page: http://openpyxl.readthedocs.org Author: See AUTHORS @@ -33,7 +33,7 @@ # grab the active worksheet ws = wb.active - # Data can be directly to cells + # Data can be assigned directly to cells ws['A1'] = 42 # Rows can also be appended diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/README.rst new/openpyxl-2.2.3/README.rst --- old/openpyxl-2.2.2/README.rst 2015-03-20 16:18:11.000000000 +0100 +++ new/openpyxl-2.2.3/README.rst 2015-05-26 14:27:40.000000000 +0200 @@ -25,7 +25,7 @@ # grab the active worksheet ws = wb.active - # Data can be directly to cells + # Data can be assigned directly to cells ws['A1'] = 42 # Rows can also be appended diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/__init__.py new/openpyxl-2.2.3/openpyxl/__init__.py --- old/openpyxl-2.2.2/openpyxl/__init__.py 2015-04-28 19:10:02.000000000 +0200 +++ new/openpyxl-2.2.3/openpyxl/__init__.py 2015-05-26 14:27:40.000000000 +0200 @@ -11,7 +11,7 @@ # constants -__version__ = '2.2.2' +__version__ = '2.2.3' __author__ = 'Eric Gazoni' __license__ = 'MIT/Expat' diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/reader/worksheet.py new/openpyxl-2.2.3/openpyxl/reader/worksheet.py --- old/openpyxl-2.2.2/openpyxl/reader/worksheet.py 2015-03-31 11:12:52.000000000 +0200 +++ new/openpyxl-2.2.3/openpyxl/reader/worksheet.py 2015-05-26 14:27:40.000000000 +0200 @@ -197,7 +197,7 @@ def parse_page_setup(self, element): id_key = '{%s}id' % REL_NS if id_key in element.attrib.keys(): - element.attrib['id'] = element.attrib.pop(id_key) + element.attrib.pop(id_key) self.ws.page_setup = PageSetup(**element.attrib) diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/worksheet/page.py new/openpyxl-2.2.3/openpyxl/worksheet/page.py --- old/openpyxl-2.2.2/openpyxl/worksheet/page.py 2015-03-20 16:18:11.000000000 +0100 +++ new/openpyxl-2.2.3/openpyxl/worksheet/page.py 2015-05-26 14:27:40.000000000 +0200 @@ -20,7 +20,7 @@ class PageSetup(Strict): """ Worksheet page setup """ - tag = "{%s}pageSetup" % SHEET_MAIN_NS + tag = "pageSetup" orientation = NoneSet(values=("default", "portrait", "landscape")) paperSize = Integer(allow_none=True) @@ -42,7 +42,9 @@ copies = Integer(allow_none=True) id = String(allow_none=True) - def __init__(self, orientation=None, + def __init__(self, + worksheet=None, + orientation=None, paperSize=None, scale=None, fitToHeight=None, @@ -61,6 +63,7 @@ verticalDpi=None, copies=None, id=None): + self._parent = worksheet self.orientation = orientation self.paperSize = paperSize self.scale = scale @@ -97,9 +100,33 @@ def verticalCentered(self): pass - @deprecated("this property has to be called via sheet_properties") + @property + def sheet_properties(self): + """ + Proxy property + """ + return self._parent.sheet_properties.pageSetUpPr + + + @property def fitToPage(self): - pass + return self.sheet_properties.fitToPage + + + @fitToPage.setter + def fitToPage(self, value): + self.sheet_properties.fitToPage = value + + + @property + def autoPageBreaks(self): + return self.sheet_properties.autoPageBreaks + + + @autoPageBreaks.setter + def autoPageBreaks(self, value): + self.sheet_properties.autoPageBreaks = value + def __iter__(self): for attr in ("orientation", "paperSize", "scale", "fitToHeight", diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/worksheet/properties.py new/openpyxl-2.2.3/openpyxl/worksheet/properties.py --- old/openpyxl-2.2.2/openpyxl/worksheet/properties.py 2015-03-20 16:18:11.000000000 +0100 +++ new/openpyxl-2.2.3/openpyxl/worksheet/properties.py 2015-05-26 14:27:40.000000000 +0200 @@ -39,7 +39,7 @@ yield attr, safe_string(value) -class PageSetupPr(Strict): +class PageSetupProperties(Strict): tag = "{%s}pageSetUpPr" % SHEET_MAIN_NS @@ -72,7 +72,7 @@ transitionEntry = Bool(allow_none=True) tabColor = ColorDescriptor(allow_none=True) outlinePr = Typed(expected_type=Outline, allow_none=True) - pageSetUpPr = Typed(expected_type=PageSetupPr, allow_none=True) + pageSetUpPr = Typed(expected_type=PageSetupProperties, allow_none=True) def __init__(self, @@ -101,10 +101,15 @@ self.transitionEntry = transitionEntry """ Elements """ self.tabColor = tabColor + if outlinePr is None: + outline = Outline(summaryBelow=True, summaryRight=True) self.outlinePr = outlinePr + if pageSetUpPr is None: + pageSetUpPr = PageSetupProperties() self.pageSetUpPr = pageSetUpPr + def __iter__(self): for attr in ("codeName", "enableFormatConditionsCalculation", "filterMode", "published", "syncHorizontal", "syncRef", @@ -121,9 +126,9 @@ if outline is not None: props.outlinePr = Outline(**outline.attrib) - page_setup = node.find(PageSetupPr.tag) + page_setup = node.find(PageSetupProperties.tag) if page_setup is not None: - props.pageSetUpPr = PageSetupPr(**page_setup.attrib) + props.pageSetUpPr = PageSetupProperties(**page_setup.attrib) tab_color = node.find('{%s}tabColor' % SHEET_MAIN_NS) if tab_color is not None: diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/worksheet/worksheet.py new/openpyxl-2.2.3/openpyxl/worksheet/worksheet.py --- old/openpyxl-2.2.2/openpyxl/worksheet/worksheet.py 2015-03-20 16:18:11.000000000 +0100 +++ new/openpyxl-2.2.3/openpyxl/worksheet/worksheet.py 2015-05-26 14:27:40.000000000 +0200 @@ -52,7 +52,7 @@ from .protection import SheetProtection from .filters import AutoFilter from .views import SheetView, Pane, Selection -from .properties import WorksheetProperties, Outline, PageSetupPr +from .properties import WorksheetProperties, Outline, PageSetupProperties def flatten(results): @@ -117,7 +117,7 @@ self.relationships = [] self._data_validations = [] self.sheet_state = self.SHEETSTATE_VISIBLE - self.page_setup = PageSetup() + self.page_setup = PageSetup(self) self.print_options = PrintOptions() self.page_margins = PageMargins() self.header_footer = HeaderFooter() @@ -306,9 +306,9 @@ """ Print Titles are rows or columns that are repeated on each printed sheet. This adds n rows or columns at the top or left of the sheet """ - + scope = self.parent.get_index(self) - + if rows_or_cols == 'cols': r = '$A:$%s' % get_column_letter(n) else: diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/writer/excel.py new/openpyxl-2.2.3/openpyxl/writer/excel.py --- old/openpyxl-2.2.2/openpyxl/writer/excel.py 2015-03-31 11:12:52.000000000 +0200 +++ new/openpyxl-2.2.3/openpyxl/writer/excel.py 2015-05-26 14:27:40.000000000 +0200 @@ -175,7 +175,7 @@ def save(self, filename, as_template=False): """Write data into the archive.""" - archive = ZipFile(filename, 'w', ZIP_DEFLATED) + archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True) self.write_data(archive, as_template=as_template) archive.close() @@ -202,7 +202,7 @@ writer = ExcelWriter(workbook) temp_buffer = BytesIO() try: - archive = ZipFile(temp_buffer, 'w', ZIP_DEFLATED) + archive = ZipFile(temp_buffer, 'w', ZIP_DEFLATED, allowZip64=True) writer.write_data(archive, as_template=as_template) finally: archive.close() diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl/writer/strings.py new/openpyxl-2.2.3/openpyxl/writer/strings.py --- old/openpyxl-2.2.2/openpyxl/writer/strings.py 2015-03-20 16:18:11.000000000 +0100 +++ new/openpyxl-2.2.3/openpyxl/writer/strings.py 2015-05-26 14:27:40.000000000 +0200 @@ -19,10 +19,10 @@ for key in string_table: el = Element('si') - if key.strip() != key: - el.set(PRESERVE_SPACE, 'preserve') text = SubElement(el, 't') text.text = key + if key.strip() != key: + text.set(PRESERVE_SPACE, 'preserve') xf.write(el) return out.getvalue() diff -urN '--exclude=CVS' '--exclude=.cvsignore' '--exclude=.svn' '--exclude=.svnignore' old/openpyxl-2.2.2/openpyxl.egg-info/PKG-INFO new/openpyxl-2.2.3/openpyxl.egg-info/PKG-INFO --- old/openpyxl-2.2.2/openpyxl.egg-info/PKG-INFO 2015-04-28 19:11:07.000000000 +0200 +++ new/openpyxl-2.2.3/openpyxl.egg-info/PKG-INFO 2015-05-26 14:29:15.000000000 +0200 @@ -1,6 +1,6 @@ Metadata-Version: 1.1 Name: openpyxl -Version: 2.2.2 +Version: 2.2.3 Summary: A Python library to read/write Excel 2007 xlsx/xlsm files Home-page: http://openpyxl.readthedocs.org Author: See AUTHORS @@ -33,7 +33,7 @@ # grab the active worksheet ws = wb.active - # Data can be directly to cells + # Data can be assigned directly to cells ws['A1'] = 42 # Rows can also be appended