Branches

fix-280

View source
fix-280
Author Commit Message Labels Comments Date
12 commits behind default.
Alex Stapleton
Created new branch fix-280
Alex Stapleton
Merged in private/openpyxl-2/private/cellpy-edited-online-with-bitbucket-1392397044262 (pull request #2)
Alex Stapleton
cell.py edited online with Bitbucket
Alex Stapleton
Merged in private/openpyxl-1/private/cellpy-edited-online-with-bitbucket-1392392674982 (pull request #1)
Alex Stapleton
cell.py edited online with Bitbucket
Alex Stapleton
Don't copy Style()s when we are only reading them.
Charlie Clark
Merge
Charlie Clark
Handle unsized worksheets gracefully. Test still required.
Charlie Clark
Start explicitly handling unsized worksheets.
Charlie Clark
Update style to use convenience methods.
Charlie Clark
Sheet with no dimension information.
Charlie Clark
No need to call `.keys()` explicitly
Charlie Clark
Use `datadir` fixture
Charlie Clark
Move `read_dimension` to `iter_worksheet.py` and adjust tests.
Charlie Clark
Remove check for LXML when using iterparse but keep argument handling in case we do want to use lxml.etree.iterparse.
Charlie Clark
Remove expensive function with cached dictionary lookup of the reverse function.
Charlie Clark
Move licence to relevant module.
Charlie Clark
Merge
Charlie Clark
Fix docs.
Charlie Clark
Add tests for ReadOnlyCells
Charlie Clark
Move cell tests to package.
Charlie Clark
Rename RawCell to ReadOnly and add some checks to stop value or style being changed.
Charlie Clark
Cleanup imports.
Charlie Clark
Cleanup imports and Python 3 compatibility
Charlie Clark
Refactor into separate module.
Charlie Clark
Update docs.
Charlie Clark
Move IterableWorksheet into Worksheet package.
Charlie Clark
Always iterate.
Charlie Clark
Add some utility metaclasses.
Charlie Clark
Only ever need one copy of an empty cell and the coordinates should be irrelevant.
Charlie Clark
Allow cells to be accessed individually.
Charlie Clark
Break out of parsing loop as soon as row/column boundaries are reached.
Charlie Clark
Merge
Charlie Clark
Only cells with numerical types can be formatted as dates.
Charlie Clark
Memory optimisation.
Charlie Clark
Some optimisations for LXML
Charlie Clark
Iterating over cells in a row is more efficient than parsing their events.
Charlie Clark
Standardise on `cell.coordinate` and add warnings for alternative
Charlie Clark
Coordinates should always be calculated from position.
Charlie Clark
Get some numbers on cell implementations.
Charlie Clark
Make number format lookup cell responsibility.
Charlie Clark
Cell.TYPE_NULL is the same as Cell.TYPE_STRING. Add explicit detection for empty cells to prevent failure in the lookup.
Charlie Clark
xrange required for Python 3
Charlie Clark
.internal_value now returns the Excel value. Tests adjiusted.
Charlie Clark
Defer conversion to Python values until access but set number format on write but cache the lookup.
Charlie Clark
Clear elemens after use and free up some memory.
Charlie Clark
Make it easier to test just one or the other implementation.
Charlie Clark
Python 3 compatible.
Charlie Clark
Cache conversions.
Charlie Clark
Additional lxml optimisation.
Charlie Clark
Added some comments.
Charlie Clark
Respect workbook epoch.
Charlie Clark
Rename modules.
Charlie Clark
Delegate conversion from Excel to Python to the Cell.
Charlie Clark
Dictionaries can be converted directly to keys.
Charlie Clark
Made LRU py26 compatible
Charlie Clark
Replace namedtuple implementation with slots-based class. ._replace is very expensive with namedtuples.
Charlie Clark
Raise exception if index is out of bounds.
Charlie Clark
Separate method for adjusting cells.
Charlie Clark
Move definitions outside generator.
Charlie Clark
ROW_TAG not actually used.
Charlie Clark
Fully cache only column_index_from_string as is it much more expensive than creating the cache.
Charlie Clark
Add lru_cache
Charlie Clark
Some optimisations to reduce the number of function calls within the loop.
Charlie Clark
Cache column letter lookup.
Charlie Clark
Cache all column lookups.
Charlie Clark
Add a façade to allow lxml.etree.iterparse to be used with extra keywords.
Charlie Clark
Changed warning to show only when type inference is expected,
Charlie Clark
Indicate whether lxml is in use or not.
Charlie Clark
Type inference disabled by default.
Charlie Clark
Reinstate setting LXML constant via environment variable.
Charlie Clark
Remove dependency on openpyxl itself in the setup
Charlie Clark
Update copyright
Charlie Clark
Separate wtiter tests, add test for empty worksheet, use xml comparison and remove addtional tests for implicitly empty worksheets.
Charlie Clark
Remove stuff commented out that is no longer used.
Charlie Clark
Use XML comparison
Charlie Clark
User property
Charlie Clark
Use property.
Charlie Clark
Parametrise test.
Charlie Clark
Add setter for cell.data_type
Charlie Clark
Parametrise test.
Charlie Clark
Extend regex to handle microseconds.
Charlie Clark
Improve time regex and add dedicated test.
Charlie Clark
Fix for #260 wasn’t merged.
Charlie Clark
Merge fix for #260
Charlie Clark
Reintroduce more finegrained control for type inferference of strings.
Charlie Clark
Always use integers to refer to relationships for reliable sorting.
Charlie Clark
Compatibility for py26 / py32
Charlie Clark
Make regexes module scope. Coerce all objects to strings to avoid branching for regex.
Charlie Clark
Use pattern matching to identify values. Time REGEX looks like it needs some work but the methods are now separately testable.
Charlie Clark
Dedicated method for binding percentages.
Charlie Clark
Dedicated method for handling time strings.
Charlie Clark
Remove pointless branching and type coercion - we can only have strings here.
Charlie Clark
Remove SharedDate
Charlie Clark
Remove own conversion code and related tests.
Charlie Clark
Move date handling to separate method.
Charlie Clark
Removed dependency on SharedDate
Charlie Clark
Removed need for each cell to have a SharedDate() instance. Enforce use of calendar in datetime assignments.
Charlie Clark
Check public attribute.
Charlie Clark
Removed test in test_cell.py that claimed to be working with strings when it actually is working with dates.
Charlie Clark
Adjust for dates less than 1900-02-28 and reinstate test values.
Charlie Clark
Add test to show that Excel mucks around with dates < 1900-02-28
Charlie Clark
Test adjusted to reflect how Excel handles days.
Charlie Clark
Fix conversion of Excel values < 1 to time objects.
Charlie Clark
Avoid rounding erros by working directly with the fractions of the day.
Charlie Clark
Convert fractional parts of days to hours, minutes, seconds and microseconds.
Charlie Clark
Handle dates.
Charlie Clark
Remove own conversion code.
Charlie Clark
Delegate calculations to functions not class methods.
Charlie Clark
Convert all parts of a datetime object.
Charlie Clark
Add missing test for converting times.
Charlie Clark
Correct conversion of microseconds to seconds.
Charlie Clark
Add more conversion functions.
Charlie Clark
Calendar constants are calculated values.
Charlie Clark
Remove unused imports
Charlie Clark
Get shippable to update dependencies
Charlie Clark
Install inlines all instructions.
Charlie Clark
Update test configruations for Travis and Shippable.
Charlie Clark
Bring github mirror up to date
Charlie Clark
Add Python 3.4 to test environments - not sure if it’s supported yet.
Charlie Clark
Numbers with leading zeros are not valid in Python 3.4
Charlie Clark
Initial delegation of datetime conversion to jdcal. tox -r required.
Charlie Clark
Prevent import errors from stopping openpyxl installing.
Charlie Clark
Don’t use strings to calculate centuries.
Charlie Clark
Use real workbook / worksheet for testing cell values to be able to handle values that always require formatting.
Charlie Clark
Convert to pytest style.
Charlie Clark
Convert to pytest style.
Charlie Clark
Convert to pytest style.
Charlie Clark
Revert to using regex to be able to handle microseconds from OpenOffice files.
Charlie Clark
Use strptime to convert from timestamps.
Charlie Clark
Add some tests for format conversion
Charlie Clark
Cleanup imports
Charlie Clark
Convert to individual tests.
Charlie Clark
Tests refactored: test_datetime.py will only test the date_time module. Other tests moved to test_cell.py but some of them need fixing as they are dependent upon real worksheets.
Charlie Clark
Test module renamed as it is mainly to do with testing datetimes.
Charlie Clark
Convert to pytest style and add check for expected value.
Charlie Clark
Convert from nose style to pytest.
Charlie Clark
Correct incorrectly converted test.
Charlie Clark
Merged in jbovey/openpyxl/1.9 (pull request #73)
John Bovey
added tox environments for keep_vba and a fixture for datadir
John Bovey
merged latest repository
John Bovey
Added support for saving back to the same file when leep_vba=True
John Bovey
added OPENPYXL_KEEP_VBA environment variable to aid testing
Charlie Clark
Cleanup some functions and add test values for colours.
Charlie Clark
Better test values, set accuracy to 100th of a degree.
Charlie Clark
Refactored tests with saner values and make them pass.
Charlie Clark
Add some more documentation and correct tests for converting between pixels and points.
Charlie Clark
Add some background information on units used by Excel.
Charlie Clark
If using LXML set the default (empty) namespace to CONTYPES_NS so that the workbook is inspectable by MS tools.
Charlie Clark
Use a range of values for tests. Some pretty weird results that need investigating.
Charlie Clark
Handle value==0
Charlie Clark
Naive initial implementation.
Charlie Clark
Stub test for units module.
Charlie Clark
Update docs
Charlie Clark
Merged in amorris/openpyxl/1.9 (pull request #77)
w...@myemptybucket.com
Removed duplicate regex.
Charlie Clark
Merged in amorris/openpyxl/1.9 (pull request #76)
w...@myemptybucket.com
resolves #46 - update ColumnDimension and RowDimension to access styles in the same manner as Cell.
w...@myemptybucket.com
resolves #46 - update ColumnDimension and RowDimension to access styles in the same manner as Cell.
Adam Morris
Merged ericgazoni/openpyxl/1.9 into 1.9
w...@myemptybucket.com
Merged parent branc
w...@myemptybucket.com
Merge with parent 1.9
w...@myemptybucket.com
Merge with parent 1.9
Charlie Clark
Reinstate from __future__ import division, removed in error.
Charlie Clark
Add tox environment for Python 3.4 since virtualenv 1.11.1 was released.
Charlie Clark
Merge in pull request #75
Charlie Clark
Merge
Charlie Clark
Merge in changes on how IterableWorksheet handles the archive.
Charlie Clark
Corrected range of characters: ASCII 1 to 32 are invalid.
Charlie Clark
Breakout components into separate modules
Charlie Clark
Cleanup after removing openpyxl.shared
Charlie Clark
openpyxl.shared removed
Charlie Clark
Break out „shared“ folder. Additional namespace is not really required. compat, xml, exceptions, units and date_time can all be library modules or packages.
Charlie Clark
Moved to cell package.
Charlie Clark
Module has been replaced by a package
Charlie Clark
Replace module with package
Charlie Clark
Replace module with package
Charlie Clark
Replace module with package
Charlie Clark
Replace module with package
Charlie Clark
Replace module with package
Charlie Clark
Replace module with package.
Charlie Clark
Merge
Charlie Clark
Merge in 1.8,2
Charlie Clark
Initial implementation to allow client code to handle ASCII < 32 more gracefully.
Charlie Clark
Break cells into separate package.
Charlie Clark
Update copyright
Charlie Clark
Update docs and authors
Charlie Clark
Merged in shibu/openpyxl/1.9 (pull request #70)
SHIBUKAWA Yoshiki
Add filterColumn, sortCondition support to AutoFilter.
Charlie Clark
Update docs.
Charlie Clark
Exclude any tests that may come with patch submissions.
Charlie Clark
Merge in 1.8.1
Charlie Clark
Stub implementation for a dedicated class for handling shared formulae
Charlie Clark
Environmental variables are always strings. Thanks to John Bovey for pointing this out.
Charlie Clark
More extensive checking of the range.
Charlie Clark
Make sure test does something
Charlie Clark
lxml now a test dependency.
Charlie Clark
Add a profile for checking memoery use.
Charlie Clark
Make testable
Charlie Clark
Merge
Charlie Clark
Update roadmap
Charlie Clark
Update docs.
Charlie Clark
Remove unused imports.
Charlie Clark
Use the constant for the „xl“ prefix.
Charlie Clark
Stanadardise on using worksheet_path to identify a worksheet.
Charlie Clark
Remove read_sheet_titles (replaced by read_sheets) and fix tests.
Charlie Clark
Refactor functions to accept archive/Excel file rather than just part of it. Reduces coupling between functions.
Charlie Clark
Move detect_worksheets in workbook.py and remove constants no longer used.
Charlie Clark
Tests no longer failing thanks to corrected sheet ordering.
Charlie Clark
Ensure relations are in order; this is still using a string comparison so not totally reliable.
Charlie Clark
Temporarily fix breaking test which seems to be breaking due to the fact that the worksheets are stored out of order in the archive.
Charlie Clark
Remove unused function. If this is required then sheet ids should be obtained from the xml.
Charlie Clark
Use same parameters for related tests.
Charlie Clark
Rename parameter to be the same as for detect_worksheets
Charlie Clark
Parametrise test.
Charlie Clark
Parametrise test
Charlie Clark
Changes to the way sheets are handled seems to have side effects on the way ranges work.
Charlie Clark
Cleanup
Charlie Clark
Correct envlist syntax - commas are still required even when envs are separated by newlines.
Charlie Clark
Improved worksheet identification using only information from the archive.
Charlie Clark
New implementation of detect_worksheets which returns title and path.
Charlie Clark
Add test for reading content types.
Charlie Clark
Add a function and test to read sheet titles *and* relations
Charlie Clark
Add function and test to read workbook relationships.
Charlie Clark
Add test for detecting worksheets.
Charlie Clark
Whitespace.
Charlie Clark
Refactor worksheet detection for easier testing.
Charlie Clark
Add sample file that is incorrectly read.
Charlie Clark
Add additional bugfix to do and order bugs numerically.
Charlie Clark
Allow fixable tests as xpass
Charlie Clark
Update roadmap.
Charlie Clark
Add a Python 2.6 / No lxml environment to catch API changes in xml.etree
Charlie Clark
Cleaned up after running py.test —flakes.
Charlie Clark
Reorganise Python 3 specific names into one block.
Charlie Clark
Add pytest-flakes environment.
Charlie Clark
Adjust nolxml environment to try and run all tests.
Charlie Clark
Mark tests which explicitly require lxml. Some of these might benefit from refactoring in the future as the tests do not just validate.
Charlie Clark
Allow test configuration to drive whether lxml is available or not.
Charlie Clark
Whitespace
Charlie Clark
Add some notes on improving IterableWorksheet
Charlie Clark
Update docs
Charlie Clark
Update test configuration.
Charlie Clark
Convert to pytest
Charlie Clark
Bump version.
Charlie Clark
Merge in correction from 1.8
Charlie Clark
Merge in changes from 1.8
Charlie Clark
Refactor charts into separate modules.
Charlie Clark
Enforce absolute imports
Charlie Clark
Update roadmap
Charlie Clark
Prepare 1.9 branch