1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890
|
### 1.3.4 29.03.2025
Author: Niklaus Giger <niklaus.giger@member.fsf.org>
* Formatted using standardrb
* Fixes for Ruby 3.4
* Bumped minimal Ruby version to 2.6
### 1.3.3 20.11.2024
commit 6464ab51195eb3593fbc2feed7436d0b6b057f73
Author: Edouard Brière <edouard.briere@gmail.com>
* Remove trailing slash from spec.homepage
### 1.3.2 15.1.2024
commit a2f54fec58339818c54e4193eed21fbb72aceff9
Author: Andrew Nesbitt <andrewnez@gmail.com>
* Add funding_uri to gemspec
### 1.3.1 15.1.2024
commit dd69d23f00427066cda8d2b30355e044b8c07eff
Author: Mark Young <mark.young@atg.auto>
* Fix spreadsheet.gemspec issues.
### 1.3.0 23.9.2021
Author: Brian Chan <i@b123400.net>
* Issues #138 #262, see github.com/zdavatz/spreadsheet
### 1.2.9 21.5.2021
Author: Mark Edmondson <mark.edmondson@gmail.com>
* See git log for changes.
### 1.2.8 27.2.2021
* Author: manxingxing <manxingxing@gmail.com>
* See git log for changes.
### 1.2.7 20.1.2021
Author: Niklaus Giger <ngiger@ywesee.com>
Date: Wed Jan 20 15:52:17 2021 +0100
* Remove .travis.ci, hoe, obsolete Warning
* Added GithubActions
### 1.2.6 22.1.2020
Author: tetsuya-ogawa <tetsuya.ogawa87@gmail.com>
Date: Wed Jan 22 15:18:00 2020 +0900
* add instance method "<<" to Spreadsheet::Worksheet
### 1.2.5 23.10.2019
Author: Jesús Manuel García Muñoz <jesus@bebanjo.com>
Date: Wed Oct 23 20:26:01 2019 +0200
* Fixes unrecognized date format
### 1.2.4 24.05.2019
Author: Cyril Champier <cyril.champier@doctolib.com>
Date: Fri May 24 12:56:52 2019 +0200
* correct ruby version check
* can read frozen string io
### 1.2.3 12.03.2019
Author: taichi <taichi730@gmail.com>
Date: Tue Mar 12 22:29:12 2019 +0900
* Remove workaround for ruby-ole gem
### 1.2.2 01.03.2019
Author: taichi <taichi730@gmail.com>
Date: Fri Mar 1 13:00:28 2019 +0900
* fixed unit test errors caused by frozen-string-literal
* removed ruby 2.3.8 with frozen-string-literal from CI regression
(It seems that standard libraries for this version does not support the
feature enough.)
* enable '--enable-frozen-string-literal' option on CI test
### 1.2.1 28.02.2019
Author: taichi <taichi730@gmail.com>
Date: Thu Feb 28 10:30:46 2019 +0900
* Merge pull request #231 from taichi-ishitani/separated_version_file
* Merge pull request #230 from taichi-ishitani/frozen_string_literal_support
### 1.2.0 17.2.2019
Author: James McLaren <jamesmclaren555@gmail.com>
* spreadsheet-1.2.0.gem released
### 1.1.9 26.1.2019
Author: Nick Weiland <nickweiland@gmail.com>
* spreadsheet-1.1.9.gem released.
### 1.1.8 / 20.08.2018
Author: VitaliyAdamkov <adamkov@tex.ua>
Date: Mon Aug 20 09:48:31 2018 +0300
* Cancel :lazy usage
* Use lazy select to speed up a little
* Omit rails :try usage
* stub for :postread_worksheet method
* sometimes it selects empty array..
Author: 545ch4 <s@rprojekt.org>
Date: Wed Mar 28 15:33:04 2018 +0200
* [ruby-2.4] Fix weird first line of spreadsheet.gemspec
* Doesn't seem to be a valid .gemspec command/field.
### 1.1.7 / 15.03.2018
Author: Maarten Brouwers <github@murb.nl>
Date: Thu Mar 15 15:10:23 2018 +0100
* shadowing outer local variable - i
* Running rake resulted in the following warning: `lib/spreadsheet/worksheet.rb:345: warning: shadowing outer local variable - i`; this patch fixes that.
### 1.1.6 / 12.03.2018
Author: Todd Hambley <thambley@travelleaders.com>
Date: Mon Mar 12 14:20:39 2018 -0400
* fix reject for ruby 1.8.7
* fix using invalid code pages when writing workbook
### 1.1.5 / 20.11.2017
Author: Paco Guzmán <pacoguzman@users.noreply.github.com>
Date: Sun Nov 19 18:10:57 2017 +0100
* Avoid creating a class variable, that variable cannot be garbage collected and it retains a lot of memory
### 1.1.4 / 02.12.2016
Author: Richard Lee <dlackty@gmail.com>
Date: Mon Jan 16 03:52:42 2017 +0800
* Update Travis CI rubies
Author: Zeno R.R. Davatz <zdavatz@ywesee.com>
Date: Fri Dec 2 10:36:20 2016 +0100
* updated Gem to use the correct License on Rubygems to GPL-3.0 as stated in the LICENSE File.
### 1.1.3 / 06.08.2016
Author: Alexandre Balon-Perin <abalonperin@gilt.jp>
Date: Fri Aug 5 17:19:29 2016 +0900
* Fix issue with iconv on Ubuntu 12.04
* This fix is related to a bug in the iconv implementation packaged in libc6 on Ubuntu 12.04
* For some reasons, the encoding options //TRANSLIT//IGNORE are improperly applied.
* When //TRANSLIT is specified, instead of rescuing errors related to //TRANSLIT and checking if the //IGNORE is set, the code simply crashes.
### 1.1.2 / 29.03.2016
Author: Aleksandr Boykov <aleksandr.boykov@parelio.com>
Date: Mon Mar 28 14:07:35 2016 -0400
fixes compact! method when the excel document has dates
### 1.1.1 / 03.01.2016
Author: ChouAndy <chouandy@ecoworkinc.com>
Date: Sun Jan 3 17:26:18 2016 +0800
Fixed Unknown Codepage 0x5212
### 1.1.0 / 08.12.2015
Author: Matthew Boeh <matt@crowdcompass.com>
Date: Mon Dec 7 11:18:55 2015 -0800
* Disregard locale indicators when determining whether a cell contains a date/time.
### 1.0.9 / 18.11.2015
Author: 545ch4 <s@rprojekt.org>
Date: Mon Nov 16 10:26:27 2015 +0100
* Add smart method compact! to worksheet
* Use compact! to reduce the number of rows and columns by striping empty one at both ends.
### 1.0.8 / 20.10.2015
commit e9bd1dd34998803b63460f4951e9aa34e569bd8f
Author: Pierre Laprée <pilap82@users.noreply.github.com>
Date: Tue Oct 20 03:12:22 2015 +0200
* Remove stray `puts`
* A `puts` instruction pollutes the log and doesn't serve any purpose. As such, we propose its removal.
### 1.0.7 / 23.09.2015
Author: Leopoldo Lee Agdeppa III <leopoldo.agdeppa@gmail.com>
Date: Wed Sep 23 08:24:16 2015 +0800
* Update worksheet.rb
* Adding Test for Freeze panels
* Update worksheet.rb
* Added freeze (freeze panel) functionality
* Update worksheet.rb
* Freeze (freeze window) functionality added to worksheet
### 1.0.6 / 14.09.2015
Author: Yann Plancqueel <yplancqueel@gmail.com>
Date: Sat Sep 12 15:32:49 2015 +0200
* bugfix opening a spreadsheet with missing format
### 1.0.5 / 01.09.2015
Author: kunashir <kunashir@list.ru>
Date: Tue Sep 1 13:12:49 2015 +0300
* add format for nubmer with out #
### 1.0.4 / 18.07.2015
Author: Edmund Mai <edmundm@crowdtap.com>
Date: Fri Jul 17 15:32:47 2015 -0400
* Fixes slow Spreadsheet.open response in console
### 1.0.3 / 10.03.2015
Author: Robert Eshleman <c.robert.eshleman@gmail.com>
Date: Mon Mar 9 09:47:59 2015 -0400
* Update `ruby-ole` to `1.2.11.8`
** `ruby-ole` <= `1.2.11.7` throws a duplicated key warning in Ruby 2.2.
** This commit updates `ruby-ole` to `1.2.11.8`, which fixes this warning.
** Related discussion: [aquasync/ruby-ole#15] - [aquasync/ruby-ole#15]: https://github.com/aquasync/ruby-ole/issues/15
### 1.0.2 / 05.03.2015
Author: cantin <cantin2010@gmail.com>
Date: Thu Mar 5 16:13:59 2015 +0800
* add Rational support
* add rational requirement
* use old rational syntax in test
### 1.0.1 / 22.01.2015
Author: Sergey Konotopov <lalalalalala@gmail.com>
Date: Wed Jan 21 13:19:56 2015 +0300
* Fixing Excel::Worksheet#dimensions
### 1.0.0 / 29.08.2014
* added spreadsheet/errors.rb to Manifest.txt
### 0.9.9 / 28.08.2014
Author: PikachuEXE <pikachuexe@gmail.com>
Date: Wed Aug 27 09:55:41 2014 +0800
* Add custom error classes
* Raise custom error for unknown code page or unsupported encoding
### 0.9.8 / 19.08.2014
Author: PikachuEXE <pikachuexe@gmail.com>
Date: Tue Aug 19 09:54:30 2014 +0800
* Fix Encoding for MRI 2.1.0
### 0.9.7 / 04.02.2014
* Avoid exception when reading text objects
* Add test for drawings with text (currenty broken)
* Restore xlsopcodes script which had been mangled in previous commits
* Remove ruby 1.9 from roadmap, it's already working fine
* Fix excel file format documentation which had been mangled in previous commits
### 0.9.6 / 02.12.2013
Author: Malcolm Blyth <trashbat@co.ck>
Date: Mon Dec 2 11:44:25 2013 +0000
* Fixed issue whereby object author being null caused a gross failure.
* Now returns object author as an empty string
### 0.9.5 / 20.11.2013
Author: Malcolm Blyth <trashbat@co.ck>
Date: Tue Nov 19 15:14:31 2013 +0000
* Bumped revision
* Fixed author stringname error (damn this 1 based counting)
* Updating integration test to check for comments contained within the cells.
* Checking also for multiple comments in a sheet
### 0.9.4 / 12.11.2013
* Updated Manifest.txt
### 0.9.3 / 12.11.2013
commit e15d8b45d7587f7ab78c7b7768de720de9961341 (refs/remotes/gguerrero/master)
Author: Guillermo Guerrero <g.guerrero.bus@gmail.com>
Date: Tue Nov 12 11:50:30 2013 +0100
* Refactor update_format for cloning format objects
* Added lib/spreadsheet/note.rb to Manifest.txt file
* 'update_format' methods now receive a hash of key => values to update
Author: Przemysław Ciąćka <przemyslaw.ciacka@gmail.com>
Date: Tue Nov 12 00:07:57 2013 +0100
* Added lib/spreadsheet/note.rb to Manifest.txt file
### 0.9.2 / 11.11.2013
commit e70dc0dbbc966ce312b45b0d44d0c3b1dc10aad6
Author: Malcolm Blyth <trashbat@co.ck>
Date: Mon Nov 11 15:53:58 2013 +0000
*Corrected compressed string formatting - *U (UTF-8) should have been *S (16-bit string)
*Completed addition of notes hash to worksheet
*Bumped revision
*Updated reader and note
Note class no longer extends string for simplicity and debug of class (pp now works a bit more easily)
Reader has had loads of changes (still WIP) to allow objects of class
Note and NoteObject to be created and combined in the postread_worksheet function
*Adding noteObject to deal with the Object (and ultimately text comment field) created by excel's madness
### 0.9.1 / 24.10.2013
* Author: Matti Lehtonen <matti.lehtonen@puujaa.com>
Date: Thu Oct 24 09:41:50 2013 +0300
* Add support for worksheet visibility
### 0.9.0 / 16.09.2013
* Author: Pavel <pavel.evst@gmail.com>
Date: Mon Sep 16 14:02:49 2013 +0700
* Test cases for Worksheet#margins, Worksheet#pagesetup, Workbook#delete_worksheet. Fix bugs related to it.
* Page margins reader/writter
* Markdownify GUIDE
* Add page setup options (landscape or portrait and adjust_to)
### 0.8.9 / 24.08.2013
Author: Doug Renn <renn@nestegg.com>
Date: Fri Aug 23 17:10:24 2013 -0600
* Work around to handle number formats that are being mistaken time formats
### 0.8.8 / 02.08.2013
Author: Nathan Colgate <nathancolgate@gmail.com>
Date: Thu Aug 1 15:01:57 2013 -0500
* Update excel/internals.rb to reference a valid Encoding type
* Encoding.find("MACINTOSH") was throwing an error. Encoding.find("MACROMAN") does not.
### 0.8.7 / 24.07.2013
Author: Yasuhiro Asaka <yasaka@ywesee.com>
Date: Wed Jul 24 11:31:12 2013 +0900
* Remove warnings for test suite
* warning: mismatched indentations at 'end' with 'class' at xxx
* warning: method redefined; discarding old xxx
* warning: assigned but unused variable xxx
* warning: previous definition of xxx was here
* The source :rubygems is deprecated because HTTP
* requests are insecure. (Gemfile)
### 0.8.6 / 11.07.2013
Author: Arjun Anand and Robert Stern <dev+arjuna+rstern@reenhanced.com>
Date: Wed Jul 10 13:45:30 2013 -0400
* Allow editing of an existing worksheet.
### 0.8.5 / 24.04.2013
* Applied Patch by Joao Almeida: When editing an existing sheet, cells merge was not working.
* https://github.com/voraz/spreadsheet/pull/14.patch
### 0.8.4 / 20.04.2013
* Applied Patch by boss@airbladesoftware.com
* https://groups.google.com/d/msg/rubyspreadsheet/73IoEwSx69w/barE7uVnIzwJ
### 0.8.3 / 12.03.2013
Author: Keith Walsh <keith.walsh@adtegrity.com>
Date: Mon Mar 11 16:48:25 2013 -0400
* Typo correction in guide example.
### 0.8.2 / 28.02.2013
Author: Roque Pinel <roque.pinel@infotechfl.com>
Date: Wed Feb 27 12:10:29 2013 -0500
* Requiring BigDecimal for checking.
* Made API friendly to BigDecimal precision.
* Changes introduced by the user 'valeriusjames'.
### 0.8.1 / 18.02.2013
* Updated Manifest.txt to include lib/spreadsheet/excel/rgb.rb
### 0.8.0 / 18.02.2013
* Adding support for converting color palette values to RGB values (not vice-versa..yet)
* by https://github.com/dancaugherty/spreadsheet/compare/master...rgb
### 0.7.9 / 06.02.2013
Author: Eugeniy Belyaev (zhekanax)
* You can merge if you are interested in perl-like Workbook.set_custom_color
implementation. I know it is not really a proper way to deal with custom colors, but
nevertheless it makes it possible.
* https://github.com/zdavatz/spreadsheet/pull/27
### 0.7.8 / 06.02.2013
Author: Kenichi Kamiya <kachick1@gmail.com>
Date: Wed Feb 6 11:23:35 2013 +0900
* Link to Travis CI on README
* Remove warnings "assigned but unused variable" in test
* Remove warnings "assigned but unused variable"
* Enable $VERBOSE flag when running test
### 0.7.7 / 22.01.2013
Author: DeTeam <timur.deteam@gmail.com>
Date: Tue Jan 22 19:11:52 2013 +0400
* Make tests pass
* Readme updated
* RuntimeError when file is empty
* Hoe in dev deps
* Finish with bundler
* Add a Gemfile
also see: https://github.com/zdavatz/spreadsheet/pull/24
### 0.7.6 / 15.01.2013
Author: Kenichi Kamiya <kachick1@gmail.com>
Date: Tue Jan 15 15:52:58 2013 +0900
* Remove warnings "method redefined; discarding old default_format"
* Remove warnings "`*' interpreted as argument prefix"
* Remove warnings "instance variable @{ivar} not initialized"
* Remove warnings "assigned but unused variable"
also see: https://github.com/zdavatz/spreadsheet/pull/21
### 0.7.5 / 06.12.2012
* Add error tolerant values for Iconv when writing spreadsheet
* by andrea@spaghetticode.it
### 0.7.4 / 06.10.2012
* Adds Spreadsheet::Excel::Row#to_a method to properly decode Date and DateTime data.
* patches by https://github.com/mdgreenfield/spreadsheet
### 0.7.3 / 26.06.2012
* Fix Format borders
* see https://github.com/zdavatz/spreadsheet/pull/6 for full details.
* patches by uraki66@gmail.com
### 0.7.2 / 14.06.2012
* many changes by Mina Naguib <mina.git@naguib.ca>
* see git log for full details
### 0.7.1 / 08.05.2012
* Author: Artem Ignatiev <zazubrik@gmail.com>
* remove require and rake altogether
* gem build and rake gem both work fine without those requires,
* and requiring 'rake' broke bundler
* add rake as development dependency
* Somehow it broken rake on my other project
### 0.7.0 / 07.05.2012
* Author: Artem Ignatiev <zazubrik@gmail.com>
* use both ruby 1.8 and 1.9 compatible way of getting character code when hashing
* Fix syntax for ruby-1.9
* return gemspec so that bundler can find it
When bundler loads gemspec, it evaluates it, and if the return value is
not a gem specification built, refuses to load the gem.
* Testing worksheet protection
### 0.6.9 / 28.04.2012
* Yield is more simple here too.
* No need to capture the block in Spreadsheet.open
* Rather than extending a core class, let's just use #rcompact from a helper module
### 0.6.8 / 20.01.2012
* adds the fix to allow the writing of empty rows, by ClemensP.
* Test also by ClemensP.
### 0.6.7 / 18.01.2012
* http://dev.ywesee.com/wiki.php/Gem/Spreadsheet points point 2.
* Tests by Michal
* Patches by Timon
### 0.6.6 / 18.01.2012
* http://dev.ywesee.com/wiki.php/Gem/Spreadsheet points 8 and 9.
* Fixes byjsaak@napalm.hu
* Patches by Vitaly Klimov
### 0.6.5.9 / 7.9.2011
* Fixed a frozen string bug thanks to dblock (Daniel Doubrovkine),
* dblock@dblock.org
* https://github.com/dblock/spreadsheet/commit/164dcfbb24097728f1a7453702c270107e725b7c
### 0.6.5.8 / 30.8.2011
* This patch is about adding a sheet_count method to workbook so that it returns
* the total no of worksheets for easy access. Please check. By
* tamizhgeek@gmail.com
* https://gist.github.com/1180625
### 0.6.5.7 / 20.7.2011
* Fixed the bug introduced by Roel van der Hoorn and updated the test cases.
* https://github.com/vanderhoorn/spreadsheet/commit/c79ab14dcf40dee1d6d5ad2b174f3fe31414ca28
### 0.6.5.6 / 20.7.2011
* Added a fix from Roel van der Hoorn to sanitize_worksheets if 'sheets' is empty.
* https://github.com/vanderhoorn/spreadsheet/commit/c109f2ac5486f9a38a6d93267daf560ab4b9473e
### 0.6.5.5 / 24.6.2011
* updated the color code for orange to 0x0034 => :orange, thanks to the hint of Jonty
* https://gist.github.com/1044700
### 0.6.5.4 / 18.4.2011
* Updated worksheet.rb according to the Patch of Björn Andersson.
* https://gist.github.com/925007#file_test.patch
* http://url.ba/09p9
### 0.6.5.3 / 23.3.2011
* Updated Txt lib/spreadsheet/excel/writer/biff8.rb with a Patch from Alexandre Bini
* See this for full detail: http://url.ba/6r1z
### 0.6.5.2 / 14.2.2011
* Updated test/integration.rb to work with Ruby ruby 1.9.2p136 (2010-12-25 revision 30365) [i686-linux]
* Thanks for the hint tomiacannondale@gmail.com
### 0.6.5.1 / 17.1.2011
* One enhancement thanks to Qiong Peng, Moo Yu, and Thierry Thelliez
* http://dev.ywesee.com/wiki.php/Gem/Spreadsheet
### 0.6.5 / 07.12.2010
* 2 Enhancements courtesy to ISS AG.
* Outlining (Grouping) of lines and columns is now possible. The outlining
maximum is 8. This means you can do 8 subgroups in a group.
* Hiding and Unhiding of lines and columns is now possible.
* Both of above two points is now possible by creating a new Excel File from
scratch or editing an existing XLS and adding groups or hiding lines to it.
### 0.6.4.1 / 2009-09-17
* 3 Bugfixes
* Fixes the issue reported by Thomas Preymesser and tracked down most of the
way by Hugh McGowan in
http://rubyforge.org/tracker/index.php?func=detail&aid=26647&group_id=678&atid=2677
where reading the value of the first occurrence of a shared formula
failed.
* Fixes the issue reported by Anonymous in
http://rubyforge.org/tracker/index.php?func=detail&aid=26546&group_id=678&atid=2677
where InvalidDate was raised for some Dates.
* Fixes the issue reported by John Lee in
http://rubyforge.org/tracker/index.php?func=detail&aid=27110&group_id=678&atid=2677
which is probably a duplicate of the Bug previously reported by Kadvin XJ in
http://rubyforge.org/tracker/index.php?func=detail&aid=26182&group_id=678&atid=2677
where unchanged rows were marked as changed in the Excel-Writer while the
File was being written, triggering an Error.
* 1 minor enhancement
* Detect row offsets from Cell data if Row-Ops are missing
This fixes a bug reported by Alexander Logvinov in
http://rubyforge.org/tracker/index.php?func=detail&aid=26513&group_id=678&atid=2677
### 0.6.4 / 2009-07-03
* 5 Bugfixes
* Fixes the issue reported by Harley Mackenzie in
http://rubyforge.org/tracker/index.php?func=detail&aid=24119&group_id=678&atid=2677
where in some edge-cases numbers were stored incorrectly
* Fixes the issue reported and fixed by someone23 in
http://rubyforge.org/tracker/index.php?func=detail&aid=25732&group_id=678&atid=2677
where using Row-updater methods with blocks caused LocalJumpErrors
* Fixes the issue reported and fixed by Corey Burrows in
http://rubyforge.org/tracker/index.php?func=detail&aid=25784&group_id=678&atid=2677
where "Setting the height of a row, either in Excel directly, or via the
Spreadsheet::Row#height= method results in a row that Excel displays with
the maximum row height (409)."
* Fixes the issue reported by Don Park in
http://rubyforge.org/tracker/index.php?func=detail&aid=25968&group_id=678&atid=2677
where some Workbooks could not be parsed due to the OLE-entry being all
uppercase
* Fixes the issue reported by Iwan Buetti in
http://rubyforge.org/tracker/index.php?func=detail&aid=24414&group_id=678&atid=2677
where parsing some Workbooks failed with an Invalid date error.
* 1 major enhancement
* Spreadsheet now runs on Ruby 1.9
### 0.6.3.1 / 2009-02-13
* 3 Bugfixes
* Only selects the First Worksheet by default
This deals with an issue reported by Biörn Andersson in
http://rubyforge.org/tracker/?func=detail&atid=2677&aid=23736&group_id=678
where data-edits in OpenOffice were propagated through all selected
sheets.
* Honors Row, Column, Worksheet and Workbook-formats
and thus fixes a Bug introduced in
http://scm.ywesee.com/?p=spreadsheet;a=commit;h=52755ad76fdda151564b689107ca2fbb80af3b78
and reported in
http://rubyforge.org/tracker/index.php?func=detail&aid=23875&group_id=678&atid=2678
and by Joachim Schneider in
http://rubyforge.org/forum/forum.php?thread_id=31056&forum_id=2920
* Fixes a bug reported by Alexander Skwar in
http://rubyforge.org/forum/forum.php?thread_id=31403&forum_id=2920
where the user-defined formatting of Dates and Times was overwritten with
a default format, and other issues connected with writing Dates and Times
into Spreadsheets.
* 1 minor enhancements
* Spreadsheet shold now be completely warning-free,
as requested by Eric Peterson in
http://rubyforge.org/forum/forum.php?thread_id=31346&forum_id=2920
### 0.6.3 / 2009-01-14
* 1 Bugfix
* Fixes the issue reported by Corey Martella in
http://rubyforge.org/forum/message.php?msg_id=63651
as well as other issues engendered by the decision to always shorten
Rows to the last non-nil value.
* 2 minor enhancements
* Added bin/xlsopcodes, a tool for examining Excel files
* Documents created by Spreadsheet can now be Printed in Excel and
Excel-Viewer.
This issue was reported by Spencer Turner in
http://rubyforge.org/tracker/index.php?func=detail&aid=23287&group_id=678&atid=2677
### 0.6.2.1 / 2008-12-18
* 1 Bugfix
* Using Spreadsheet together with 'jcode' could lead to broken Excel-Files
Thanks to Eugene Mikhailov for tracking this one down in:
http://rubyforge.org/tracker/index.php?func=detail&aid=23085&group_id=678&atid=2677
### 0.6.2 / 2008-12-11
* 14 Bugfixes
* Fixed a bug where #<boolean>! methods did not trigger a call to
#row_updated
* Corrected the Row-Format in both Reader and Writer (was Biff5 for some
reason)
* Populates Row-instances with @default_format, @height, @outline_level
and @hidden attributes
* Fixed a Bug where Workbooks deriving from a Template-Workbook without
SST could not be saved
Reported in
http://rubyforge.org/tracker/index.php?func=detail&aid=22863&group_id=678&atid=2678
* Improved handling of Numeric Values (writes a RK-Entry for a Float
only if it can be encoded with 4 leading zeroes, and a Number-Entry for an
Integer only if it cannot be encoded as an RK)
* Fixes a bug where changes to a Row were ignored if they were
outside of an existing Row-Block.
* Fixes a bug where MULRK-Entries sometimes only contained a single RK
* Fixes a bug where formatting was ignored if it was applied to empty Rows
Reported by Zomba Lumix in
http://rubyforge.org/forum/message.php?msg_id=61985
* Fixes a bug where modifying a Row in a loaded Workbook could lead to Rows
with smaller indices being set to nil.
Reported by Ivan Samsonov in
http://rubyforge.org/forum/message.php?msg_id=62816
* Deals with rounding-problems when calculating Time
Reported by Bughunter extraordinaire Bjørn Hjelle
* Correct splitting of wide characters in SST
Reported by Michel Ziegler and by Eugene Mikhailov in
http://rubyforge.org/tracker/index.php?func=detail&aid=23085&group_id=678&atid=2677
* Fix an off-by-one error in write_mulrk that caused Excel to complain that
'Data may be lost', reported by Emma in
http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/321979
and by Chris Lowis in
http://rubyforge.org/tracker/index.php?func=detail&aid=22892&group_id=678&atid=2677
* Read formats correctly in read_mulrk
Reported by Ivan Samsonov
Fixes that part of http://rubyforge.org/forum/message.php?msg_id=62821
which is a bug. Does nothing for the disappearance of Rich-Text
formatting, which will not be addressed until 0.7.0
* Fixes a (benign?) bug, where adding text to a template-file resulted in
a duplicate extsst-record.
* 2 minor enhancements
* Improved recognition of Time-Formats
* Improvement to Robustness: allow Spreadsheet::Workbook.new
Takes care of http://rubyforge.org/forum/message.php?msg_id=62941
Reported by David Chamberlain
### 0.6.1.9 / 2008-11-07
* 1 Bugfix
* Fixes a precision-issue in Excel::Row#datetime: Excel records Time-Values
with more significant bits (but not necessarily more precise) than
DateTime can handle.
(Thanks to Bjørn Hjelle for the Bugreport)
* 1 minor enhancement
* Added support for appending Worksheets to a Workbook
(Thanks to Mohammed Rabbani for the report)
### 0.6.1.8 / 2008-10-31
* 1 Bugfix
* Fixes a bug where out-of-sequence reading of multiple Worksheets could
lead to data from the wrong Sheet being returned.
(Thanks to Bugreporter extraordinaire Bjørn Hjelle)
### 0.6.1.7 / 2008-10-30
* 1 Bugfix
* Fixes a bug where all Formulas were ignored.
(Thanks to Bjørn Hjelle for the report)
* 1 minor enhancement
* Allow the substitution of an IO object with a StringIO.
(Thanks to luxor for the report)
### 0.6.1.6 / 2008-10-28
* 2 Bugfixes
* Fixed encoding and decoding of BigNums, negative and other large Numbers
http://rubyforge.org/tracker/index.php?func=detail&aid=22581&group_id=678&atid=2677
* Fix a bug where modifications to default columns weren't stored
http://rubyforge.org/forum/message.php?msg_id=61567
* 1 minor enhancement
* Row#enriched_data won't return a Bogus-Date if the data isn't a Numeric
value
(Thanks to Bjørn Hjelle for the report)
### 0.6.1.5 / 2008-10-24
* 2 Bugfixes
* Removed obsolete code which triggered Iconv::InvalidEncoding
on Systems with non-gnu Iconv:
http://rubyforge.org/tracker/index.php?func=detail&aid=22541&group_id=678&atid=2677
* Handle empty Worksheets
(Thanks to Charles Lowe for the Patches)
### 0.6.1.4 / 2008-10-23
* 1 Bugfix
* Biff8#wide now works properly even if $KCODE=='UTF-8'
(Thanks to Bjørn Hjelle for the Bugreport)
* 1 minor enhancement
* Read/Write functionality for Links (only URLs can be written as of now)
### 0.6.1.3 / 2008-10-21
* 2 Bugfixes
* Renamed UTF8 to UTF-8 to support freebsd
(Thanks to Jacob Atzen for the Patch)
* Fixes a Bug where only the first Rowblock was read correctly if there were
no DBCELL records terminating the Rowblocks.
(Thanks to Bjørn Hjelle for the Bugreport)
### 0.6.1.2 / 2008-10-20
* 2 Bugfixes
* Corrected the Font-Encoding values in Excel::Internals
(Thanks to Bjørn Hjelle for the Bugreport)
* Spreadsheet now skips Richtext-Formatting runs and Asian Phonetic
Settings when reading the SST, fixing a problem where the presence of
Richtext could lead to an incomplete SST.
### 0.6.1.1 / 2008-10-20
* 1 Bugfix
* Corrected the Manifest - included column.rb
### 0.6.1 / 2008-10-17
* 3 minor enhancements
* Adds Column formatting and Worksheet#format_column
* Reads and writes correct Fonts (Font-indices > 3 appear to be 1-based)
* Reads xf data
### 0.6.0 / 2008-10-13
* 1 major enhancement
* Initial upload of the shiny new Spreadsheet Gem after three weeks of
grueling labor in the dark binary mines of Little-Endian Biff and long
hours spent polishing the surfaces of documentation.
|