openpyxl merge requestshttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests2020-06-26T12:04:56Zhttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/275New changes2020-06-26T12:04:56ZBitbucket ImporterNew changes*Created originally on Bitbucket by [WheeleD (David Wheeler)](https://bitbucket.org/%7Bbe584a2d-b07c-4137-a6a4-0396c0c8e86d%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbuc...*Created originally on Bitbucket by [WheeleD (David Wheeler)](https://bitbucket.org/%7Bbe584a2d-b07c-4137-a6a4-0396c0c8e86d%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
Replaces PR #274 - updated with latest changes from openpyxl/2.6
* Revised method of constructing borders for merged cells to eliminate the creation of spurious border styles \(apart from the top left cell style which stores the border style for the entire range\). Necessitated a change to \_side\_for\_edge method and so the corresponding test\_side\_for\_edge has been modified to suit.
* Further improvement in reformatting of cells in merged cell range. Addresses discrepancies in setting up diagonal borders, fonts, fills etc for the merged cell range. Added additional elements in tests to \(a\) validate the changes and \(b\) demonstrate the existence of the spurious styles in the 2.6 base code.
* Simplification based on suggestions from @CharlieChttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/276Raise InvalidFileException when file invalid excel file2020-06-26T12:04:57ZBitbucket ImporterRaise InvalidFileException when file invalid excel file*Created originally on Bitbucket by [hadalin (Primoz Hadalin)](https://bitbucket.org/%7Bb93304e3-262b-47de-bedf-2a55ac5a25aa%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbu...*Created originally on Bitbucket by [hadalin (Primoz Hadalin)](https://bitbucket.org/%7Bb93304e3-262b-47de-bedf-2a55ac5a25aa%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
Raise InvalidFileException when file invalid excel file
This change causes backward incompatibility for 'load\_workbook' method. Before this change three different exceptions could be raised \(InvalidFileException, BadZipfile and IOError\), but now only InvalidFileException is raised.https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/278changes.rst : Corrected release year2020-06-26T12:05:00ZBitbucket Importerchanges.rst : Corrected release year*Created originally on Bitbucket by Former user*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
*Created originally on Bitbucket by Former user*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/279changes.rst: Fixed release year2018-08-30T09:05:41ZBitbucket Importerchanges.rst: Fixed release year*Created originally on Bitbucket by Former user*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
*Created originally on Bitbucket by Former user*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/280Modified to support a formula with a line feeds.2020-06-26T12:05:02ZBitbucket ImporterModified to support a formula with a line feeds.*Created originally on Bitbucket by [ysdfix (Masato Yoshida)](https://bitbucket.org/%7B215c6f33-1223-4e30-8896-080dd74b1648%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbuc...*Created originally on Bitbucket by [ysdfix (Masato Yoshida)](https://bitbucket.org/%7B215c6f33-1223-4e30-8896-080dd74b1648%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
* Modified to support a formula with a line feeds
This change is related to #723.
This change is to support workbooks with formulas containing newlines\(line-feeds\).https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/282Fix unimportant typos2020-06-26T12:05:05ZBitbucket ImporterFix unimportant typos*Created originally on Bitbucket by [tochev (Tochev)](https://bitbucket.org/%7Bfa44ca1b-c098-4952-9e3f-28557c45867f%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Mar...*Created originally on Bitbucket by [tochev (Tochev)](https://bitbucket.org/%7Bfa44ca1b-c098-4952-9e3f-28557c45867f%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/283Handle empty datetimes in document properties2020-06-26T12:05:06ZBitbucket ImporterHandle empty datetimes in document properties*Created originally on Bitbucket by [tochev (Tochev)](https://bitbucket.org/%7Bfa44ca1b-c098-4952-9e3f-28557c45867f%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Mar...*Created originally on Bitbucket by [tochev (Tochev)](https://bitbucket.org/%7Bfa44ca1b-c098-4952-9e3f-28557c45867f%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/288add hyperlink support for write_only workbooks2020-06-26T12:05:14ZBitbucket Importeradd hyperlink support for write_only workbooks*Created originally on Bitbucket by [wardi (Ian Ward)](https://bitbucket.org/%7B3f17df42-45c9-4333-ad03-0651eb525d3e%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Ma...*Created originally on Bitbucket by [wardi (Ian Ward)](https://bitbucket.org/%7B3f17df42-45c9-4333-ad03-0651eb525d3e%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
this change also overrides the hyperlink references to allow users to create cells with the WriteOnlyCell function \(always set to “A1”\) but have hyperlinks appear in the correct placehttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/298Working towards dropping Python 2.x support2019-04-10T08:08:21ZBitbucket ImporterWorking towards dropping Python 2.x support*Created originally on Bitbucket by [pythooonuser (Felix Siebeneicker)](https://bitbucket.org/%7Bba558ba0-bda6-46a5-9310-750083cde298%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined...*Created originally on Bitbucket by [pythooonuser (Felix Siebeneicker)](https://bitbucket.org/%7Bba558ba0-bda6-46a5-9310-750083cde298%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
* Removing long support
* Removing long references
* Removing singleton compat
* Removing safe\_repr
* Removing safe\_repr references
* Removing basestring from compat
* Removing basestring references
* Removing unicode from compat
* Adding unicode back in
* Removing accumulate function from compat
* Removing abc from compat
* Removing range compat references
* Fixing documentation referencehttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/299Add quotes around sheetnames if they contain special characters.2020-06-26T12:05:30ZBitbucket ImporterAdd quotes around sheetnames if they contain special characters.*Created originally on Bitbucket by [gaolycn (Renjun Gao)](https://bitbucket.org/%7B89506527-2775-4e4a-9488-76e185f137eb%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket...*Created originally on Bitbucket by [gaolycn (Renjun Gao)](https://bitbucket.org/%7B89506527-2775-4e4a-9488-76e185f137eb%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
I added some Chinese characters.https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/302Replacing import * to avoid jython issues2020-06-26T12:05:38ZBitbucket ImporterReplacing import * to avoid jython issues*Created originally on Bitbucket by [francisoud (Benjamin Francisoud)](https://bitbucket.org/%7Be8b0c6b4-2da4-4e1c-a1c5-9d862f9e0674%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined ...*Created originally on Bitbucket by [francisoud (Benjamin Francisoud)](https://bitbucket.org/%7Be8b0c6b4-2da4-4e1c-a1c5-9d862f9e0674%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
* replacing all import\* \(wildcard\) by the full list of class Fix for https://bitbucket.org/openpyxl/openpyxl/issues/943/
* typo error in from when replacing wildcards Fix for https://bitbucket.org/openpyxl/openpyxl/issues/943/
* leaving the wildcard on chart/shapes.py because: 1/ jython doesn't complaint on this one ?! 2/ removing the wildcard makes me import many other stuff to avoid errors \(for example from openpyxl.xml.constants import DRAWING\_NS\)https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/304Fix critical typo 'mitre' to 'miter' causing error when saving certain drawings2020-06-26T12:05:40ZBitbucket ImporterFix critical typo 'mitre' to 'miter' causing error when saving certain drawings*Created originally on Bitbucket by [n23 (TC)](https://bitbucket.org/%7B82dc7bbd-6dce-4d32-8416-f343f0566710%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as ...*Created originally on Bitbucket by [n23 (TC)](https://bitbucket.org/%7B82dc7bbd-6dce-4d32-8416-f343f0566710%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
fix critical typo 'mitre' to 'miter' causing error when saving certain drawingshttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/305Fix critical typo 'mitre' to 'miter' causing error when saving certain drawings2018-12-12T14:39:02ZBitbucket ImporterFix critical typo 'mitre' to 'miter' causing error when saving certain drawings*Created originally on Bitbucket by [n23 (TC)](https://bitbucket.org/%7B82dc7bbd-6dce-4d32-8416-f343f0566710%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as ...*Created originally on Bitbucket by [n23 (TC)](https://bitbucket.org/%7B82dc7bbd-6dce-4d32-8416-f343f0566710%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
Fix critical typo 'mitre' to 'miter' causing error when saving certain drawingshttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/309Test and fix for issue 1157: FileSharing password causes ValueError exception2018-12-31T05:07:40ZBitbucket ImporterTest and fix for issue 1157: FileSharing password causes ValueError exception*Created originally on Bitbucket by [jraber (Jeff Raber)](https://bitbucket.org/%7B1ef39c86-50ce-441f-94e2-cc96683761e1%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket....*Created originally on Bitbucket by [jraber (Jeff Raber)](https://bitbucket.org/%7B1ef39c86-50ce-441f-94e2-cc96683761e1%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
* Add test for password protected shared workbook. Issue #1157
* Define hashValue and saltValue as Base64Binary. Issue #1157https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/312Treat invalid datetime values from Excel as numeric, resolves #11522020-06-26T12:05:51ZBitbucket ImporterTreat invalid datetime values from Excel as numeric, resolves #1152*Created originally on Bitbucket by [jraber (Jeff Raber)](https://bitbucket.org/%7B1ef39c86-50ce-441f-94e2-cc96683761e1%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket....*Created originally on Bitbucket by [jraber (Jeff Raber)](https://bitbucket.org/%7B1ef39c86-50ce-441f-94e2-cc96683761e1%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
* Tests for conversion of invalid datetime values
* Treat invalid Excel datetime values as numeric
* Add Jeff Raber to the list of authorshttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/314Added support for writing formula-value tuples2020-06-26T12:05:53ZBitbucket ImporterAdded support for writing formula-value tuples*Created originally on Bitbucket by [cliffckerr (Cliff Kerr)](https://bitbucket.org/%7Bcb617af6-c63f-4fcd-b114-ecc4c1ca202c%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbuc...*Created originally on Bitbucket by [cliffckerr (Cliff Kerr)](https://bitbucket.org/%7Bcb617af6-c63f-4fcd-b114-ecc4c1ca202c%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
This small PR adds support for writing both formulas and calculated values. All that is required is to supply a tuple for the cell value, which is parsed as a formula and calculated value, instead of raising an error as it did before. This addresses:
[https://stackoverflow.com/questions/33008610/python-openpyxl-read-xlsx-data-after-writing-on-existing-xlsx-with-formula](https://stackoverflow.com/questions/33008610/python-openpyxl-read-xlsx-data-after-writing-on-existing-xlsx-with-formula)
and
[https://bitbucket.org/openpyxl/openpyxl/issues/251/add-a-value-cache-to-cellcell](https://bitbucket.org/openpyxl/openpyxl/issues/251/add-a-value-cache-to-cellcell)https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/316protection.rst edited online with Bitbucket - disabe corrected to disable2020-06-26T12:05:56ZBitbucket Importerprotection.rst edited online with Bitbucket - disabe corrected to disable*Created originally on Bitbucket by [henningb (Henning Bragge)](https://bitbucket.org/%7B1f8d159a-f709-4cf4-ab81-59b31991cc93%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitb...*Created originally on Bitbucket by [henningb (Henning Bragge)](https://bitbucket.org/%7B1f8d159a-f709-4cf4-ab81-59b31991cc93%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
protection.rst edited online with Bitbucket - disabe corrected to disablehttps://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/319Feature/write numpy to cell2019-02-08T18:09:52ZBitbucket ImporterFeature/write numpy to cell*Created originally on Bitbucket by [CoryKramer (Cory Kramer)](https://bitbucket.org/%7Bb770e48f-bd38-468d-8272-9cf6671cbd8f%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbu...*Created originally on Bitbucket by [CoryKramer (Cory Kramer)](https://bitbucket.org/%7Bb770e48f-bd38-468d-8272-9cf6671cbd8f%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
Fixed writing numpy numeric types to cell value. Fix for Issue #1181.https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/323Fixing quotes in sheetname2020-06-26T12:06:05ZBitbucket ImporterFixing quotes in sheetname*Created originally on Bitbucket by [Randomneo (Ростислав Місюра)](https://bitbucket.org/%7B5680167a-a38c-4095-a697-df0aa7531b25%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on B...*Created originally on Bitbucket by [Randomneo (Ростислав Місюра)](https://bitbucket.org/%7B5680167a-a38c-4095-a697-df0aa7531b25%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
Fixing bug with quotes in sheet name Issue #1190https://foss.heptapod.net/openpyxl/openpyxl/-/merge_requests/324manifest: use private mime type database2020-06-26T12:06:06ZBitbucket Importermanifest: use private mime type database*Created originally on Bitbucket by [Hans-Jakob (Hans-Jakob Holtz)](https://bitbucket.org/%7B2ddbb2a6-effc-4c15-afe5-6ce3d97095f7%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on ...*Created originally on Bitbucket by [Hans-Jakob (Hans-Jakob Holtz)](https://bitbucket.org/%7B2ddbb2a6-effc-4c15-afe5-6ce3d97095f7%7D/)*
*Changesets for this Pull Request have not been imported, because it had been already declined on Bitbucket. Marked as closed by the import user.*
Bugfixes should be based on the current production branch and new features on the development branch. If in doubt send an e-mail to me or the mailing list.
Pull requests without tests, and unit tests are preferred over functional tests, will not be accepted. Please check the development documentation on how to set up testing. Also, please configure pipelines for your account so that your pull request will run through the test matrix.
If you're adding new features then please consider extending the documentation.