summaryrefslogtreecommitdiffhomepage
path: root/test/workbook/worksheet/tc_worksheet.rb
AgeCommit message (Collapse)Author
2023-06-10Fix safe Style/ColonMethodCall offensesGeremia Taglialatela
Caxlsx is using both `.` and `::`, 220 occurrences vs 280 to invoke methods on `Axlsx` module. This commit standardizes the approach towards `.`, which will also allow shorter lines. Performance is not affected ``` Comparison: Axlsx.validate: 8515252.3 i/s Axlsx::validate: 8512863.7 i/s - same-ish: difference falls within error ```
2023-05-22Use Ruby 1.9 hash syntax (non-production code)Geremia Taglialatela
2023-05-04Enable Style/FrozenStringLiteralComment and autocorrectPaul Kmiec
2023-05-03Fix Style/RedundantFileExtensionInRequire offenseGeremia Taglialatela
2023-05-03Add RuboCop MinitestGeremia Taglialatela
2023-05-03Fix offenses to non-production codeGeremia Taglialatela
- Lint/AmbiguousBlockAssociation - Lint/AmbiguousOperatorPrecedence - Lint/EmptyBlock - Lint/RedundantSplatExpansion - Lint/RedundantStringCoercion - Lint/SymbolConversion - Lint/UnusedBlockArgument - Style/BlockDelimiters - Style/CommentAnnotation - Style/EachForSimpleLoop - Style/EmptyMethod - Style/ExpandPathArguments - Style/FileWrite - Style/GlobalStdStream (UNSAFE) - Style/HashEachMethods (UNSAFE) - Style/NestedParenthesizedCalls - Style/NilComparison - Style/NumericLiteralPrefix (manually fixed) - Style/ParallelAssignment - Style/PreferredHashMethods (UNSAFE) - Style/RedundantInterpolation (UNSAFE) - Style/RedundantParentheses (UNSAFE) - Style/RegexpLiteral - Style/RescueStandardError - Style/SpecialGlobalVars (UNSAFE) - Style/SymbolProc (UNSAFE) - Style/ZeroLengthPredicate (UNSAFE)
2023-04-13Merge branch 'master' into escape-formulas-improvementJohnny Shields
2023-04-09Fix Layout/ExtraSpacing offensesGeremia Taglialatela
Configure with `AllowBeforeTrailingComments: true`
2023-04-09Fix offenses related to indentation consistencyGeremia Taglialatela
2023-04-08Fix space-related offensesGeremia Taglialatela
- Layout/SpaceAfterComma - Layout/SpaceAroundEqualsInParameterDefault - Layout/SpaceAroundOperators - Layout/SpaceBeforeBlockBraces - Layout/SpaceInsideBlockBraces - Layout/SpaceInsideHashLiteralBraces - Layout/SpaceInsideParens
2023-04-08Fix offenses related to trailing commasGeremia Taglialatela
2023-04-08Fix EmptyLines related offensesGeremia Taglialatela
2023-04-08Fix Layout/SpaceBeforeFirstArg offensesGeremia Taglialatela
``` rubocop --only Layout/SpaceBeforeFirstArg -a ```
2023-04-07Fix Layout/SpaceAroundBlockParameters offensesGeremia Taglialatela
``` rubocop --only Layout/SpaceAroundBlockParameters -a ```
2023-04-06Fix Layout/EmptyLineBetweenDefs offensesGeremia Taglialatela
``` rubocop --only Layout/EmptyLineBetweenDefs -a ```
2023-04-06Fix Layout/EmptyLines offensesGeremia Taglialatela
``` rubocop --only Layout/EmptyLines -a ```
2023-04-06Remove Layout/TrailingWhitespace offensesGeremia Taglialatela
``` rubocop --only Layout/TrailingWhitespace -a ```
2023-03-31Add settings for escape_formulas at global, workbook, worksheet, row and ↵johnnyshields
cell levels.
2022-11-02Improve BorderCreator argsWeston Ganger
2022-10-12Resolve all TODOsWeston Ganger
2021-12-29Fix Worksheet#name_to_cell bug which returned reversed row/col indexesWeston Ganger
2020-12-10Fix calculation of worksheet name lengthLuka Lüdicke
- The previous change caused unnecessary issues - We approximate that Excel calculates the character length with UTF-16 - Fixes https://github.com/caxlsx/caxlsx/issues/67
2020-12-10Delete redundant worksheet name too long testLuka Lüdicke
2020-11-26Group worksheet name tests togetherLuka Lüdicke
Opposes a redundant test
2019-12-17Check size in bytes as opposed to string sizeIan Clarkson
- `size` returns length in characters, but doesn't factor in multibyte Unicode characters. By switching to `bytesize`, we check the relevant measure of how many bytes the worksheet name is. - Fixes https://github.com/randym/axlsx/issues/588 - Copy of PR against original axlsx (https://github.com/randym/axlsx/pull/589)
2018-02-08chore(coverage): 100% coverage, 100% docsrandym
2017-04-01chore(test): update tests for depreciated methodsrandym
2016-11-12fix warning: constant ::Fixnum is deprecatedtakkanm
fix Fixnum deprecated warning on Ruby2.4-preview3. Fixnum was unify into Integer. https://bugs.ruby-lang.org/issues/12005
2016-11-02Allow a Row to be passed to merge_cellsMike Dillon
2016-02-01Add test case for worksheet rendering as requestedBruce Davidson
2014-08-01Add example and test for auto filters on multiple worksheet (refs #338)Jonathan Tron
2014-04-04Fix boolean values so the output matches Excel and works on NumbersJurriaan Pruis
Use 1 or 0 instead of 'true' or 'false' in the XML output
2014-03-12Fix autowidth in combination with sanitizingJurriaan Pruis
By only sanitizing just before serialisation.
2014-02-26Huge refactoringJurriaan Pruis
Do not create huge strings Let Row inherit from SimpleTypedList Optimized sanitizing Optimized validation And more..
2014-02-26Add auto_filter defined name in `Axlsx::Worksheet#to_xml_string` (refs #285)Jonathan Tron
The way ot was done previously (adding the defined name on `Axlsx::Worksheet#auto_filter=`) meant that it was added only when using this method. But it's possible to assign range on the auto-created `AutoFilter` with: ```ruby workheet.auto_filter.range = "A1:B2" ``` In this case the defined name was never added to the workbook.
2014-02-26Fix wrong value for auto_filter defined name (refs #285)Jonathan Tron
2014-01-23fixing comments for 2010 starter editionDustin Smith
2013-09-29Integrate workbook views and alter serializationRandy Morgan
This integrates workbook views and sheet state into serialization. I also noticed that we were populating defined names during serialization. While it is good to delay this as late as possible as there is always the chance that some conditional programming by the consumer adds, and then removes an autofilter, I am choosing to risk it at this point for cleaner code.
2013-09-13repair pivot table data ref populate and bring coverage back up to 100%Randy Morgan
2013-09-13Fixes for anchor swapping when adding images. - Two -> One swap still pending.Randy Morgan
2013-09-13Page Breaks - round oneRandy Morgan
This sets up the basic col and row break creation and serialization. You can specify either a string reference like "C7" or provide an Axlsx::Cell instance to specify the break point. Serialization is working cleanly but excel does not automatically render those breaks yet. You need to switch to page preview mode.
2013-08-29dont rely on jruby 1.9 to produce an ordered hashRandy Morgan
2013-08-19More work on page breaksRandy Morgan
2013-07-08Make relationship ids more reliable.Stefan Daschek
Relationship instances now keep track of their own id – this should be much more reliable than the old way of more or less “guessing” the relationship id based on the position of some object in some array. Fixes https://github.com/randym/axlsx/issues/212, especially. Each relationship now has its own, unique id – except for the cases when it doesn’t: Some relationships need to share the same id, see `Relation#should_use_same_id_as?` for the gory details. All tests pass, and the full example.xlsx is generated without errors and looks fine in Excel for Mac 2011. The pivot table example still has the problems mentioned in https://github.com/randym/axlsx/issues/168 – but as far as I can tell I didn’t make it worse (Excel is still be able to “repair” the file, and the repaired file then contains the pivot table).
2013-06-23fix typo in specsRandy Morgan
2013-06-23added sparse array transposition with blocks for rows/cols switching and ↵Randy Morgan
some docs updates for release prep
2013-05-12implement transpose for SimpleTypedList that supports sparse data.Randy Morgan
2013-04-28Refactored and renamed space preservationRandy Morgan
preserve_spaces has been moved to the workbook and renamed xml_space as that provides a good reference for people trying to figure out what it does, and let's the author specify space preservation for serializations using the shared strings table as well as the default inline serialization in cells.
2013-04-27Add a preserve_spaces option to worksheet, defaults to trueAdam Gardiner
2013-01-02Worksheet name uniqueness doesn't apply to itselfEdward Anderson
This constraint would prevent you from creating a new worksheet with the name that it would have gotten by default.