1Revision history for Perl module Spreadsheet::WriteExcel. 2 32.40 2013-11-06 4 5 ! Fix for minor typo/bug that caused issues with Math::BigInt. 6 RT 90061. 7 8 92.39 2013-06-06 10 11 ! Added Debian patch for Pod encoding. RT #85897. 12 Thanks Gregor Herrmann. 13 14 152.38 2012-22-11 16 17 Maintenance release. Minor fixes only. 18 19 ! Removed failing testcases to allow S::WE to be tested/packaged 20 on recent perls. 21 22 ! Fix filter_column bug where filter is applied to the wrong column. 23 Merge pull request #4 from blazzy/master. 24 25 ! Enabled set_zoom() for Chart worksheets. It was documented but 26 wasn't working. Reported by Praphull Kumar. 27 28 ! Enabled set_tab_color() for Chart worksheets. It was documented 29 but wasn't working. 30 31 ! Fix typo in docs. Closes RT#70432. 32 33 ! Fix for rounding in test with longdoubles. Fixes RT#68954. 34 35 ! Handle chart sheets with utf8 name. Fixes RT#67014. 36 37 ! Fix for undefined formulas. Fixes RT#61560. 38 39 402.37 2010-02-02 41 42 + Added set_chartarea() and set_plotarea() methods to set 43 chart and plot background colours and border lines. 44 45 ! Fixed bug where embedded charts gave "Data may be lost" 46 warning. Reported by Andreas Strobitzer. 47 48 ! Fixed issue where set_properties() didn't work with ::Big. 49 Marked ::Big as deprecated in the docs in favour of using 50 Spreadsheet::WriteExcel directly. Removed WorkbookBig.pm. 51 52 532.36 2010-21-01 54 55 ! Fix for bug that gave a name conflict error for repeat rows and 56 autofilters in some non-English versions of Excel. 57 http://rt.cpan.org/Public/Bug/Display.html?id=38099 58 59 ! Fixed tab selection for Charts. 60 61 + Added xl_range_formula() to Spreadsheet::WriteExcel::Utility to 62 help with creating chart ranges. Added example to Chart docs. 63 64 + Added set_legend() method with initial legend formatting options. 65 66 + Documented Worksheet methods that are applicable to Charts. 67 68 692.35 2010-10-01 70 71 + Added support for Stock charts. 72 73 + Added support for Scatter charts. 74 75 + Improved Pie chart examples. 76 77 782.34 2010-08-01 79 80 + Added support for Pie charts. 81 82 ! Re-added index.html in docs dir for Debian (and others). 83 http://rt.cpan.org/Public/Bug/Display.html?id=53346 84 85 ! Fix for incorrectly encoded string result in repeat_formula(). 86 87 882.33 2010-03-01 89 90 + Added support for embedded charts. See insert_chart(). 91 92 932.32 2009-31-12 94 95 + Added support for native charts. See Charts.pm. 96 Column, Bar, Line and Area charts supported. 97 98 ! Fixed Apache2::Const vars in mod_perl2.pl example. 99 Thanks to Ryan Perry. 100 101 1022.31 2009-10-12 103 104 ! Fixed resources in Makefile.PL. 105 106 ! Updated screenshots of example programs. 107 108 1092.30 2009-25-11 110 111 ! Updated Pod generator to include screenshots of example programs. 112 113 1142.29 2009-25-11 115 116 ! Made version 0.19 of OLE::Storage_Lite a prerequisite to avoid 117 issues when using set_properties with Win 7 or Gnumeric. 118 119 1202.28 2009-22-11 121 122 ! Fix to NAME section in Example.pm to get CPAN to generate pod docs 123 for it. 124 125 1262.27 2009-21-11 127 128 + Added autogenerated Examples.pm. 129 130 1312.26 2009-13-11 132 133 + Beta release of defined names. 134 135 ! Fix for fuzzy images issue reported by Todd Eigenschink. 136 + Added 25_position_object.t tests to cover above issue. 137 138 ! Fixed bug where file size wasn't found for progressive JPEGs. 139 Reported by Yamashita Junji and Bruce Anderson II. 140 141 + Added set_country() method. 142 143 ! Fix for UTF8 strings passed to write_url(). 144 Reported by Jon Schutz. 145 http://rt.cpan.org/Public/Bug/Display.html?id=41048 146 147 ! Fixed very minor issue with uninitialised value for top 148 border colour in formats. Reported by Franz Fasching. 149 150 1512.25 2008-09-09 152 153 ! Fix for set_properties() bug due to 5.10/5.8 UTF-8 differences. 154 155 ! Fix for failing tests due to localtime() issues. 156 157 1582.24 2008-06-09 159 160 + Added set_properties() method to set document properties. 161 Added test suite and example. 162 163 1642.23 2008-10-08 165 166 + Added Excel data validation with examples and test suite. 167 168 1692.22 2008-19-07 170 171 + Added JPEG support. 172 173 + Added 29_process_jpg.t test for jpg dimension processing. 174 175 + Turned off compatibility_mode() in Spreadsheet::WriteExcel::Big 176 which was on by accident. 177 178 + Added "Warning about Office Service Pack 3" section to the 179 docs to explain Excel warnings with duplicate data. 180 181 + Expanded "Dates and Time in Excel" section of the docs. 182 183 + Added isa() to _process_images() to allow subclassing. 184 Reported by David Worenklein. 185 186 1872.21 2008-09-03 188 189 ! Fixed bug where UTF-8 strings in formulas weren't handled. 190 Thanks Sergey Zhuravlev. 191 http://rt.cpan.org/Public/Bug/Display.html?id=30368 192 193 ! Fixed collapse outlines compatibility with Gnumeric 194 and OpenOffice.org. 195 Reported by Barrie Slaymaker. 196 http://rt.cpan.org/Public/Bug/Display.html?id=33662 197 198 + Added outline_collapsed.pl example. 199 200 + Added document section about rewriting Excel files. 201 202 + Minor security fix to Format to avoid eval and 203 additional fix for RT 24218. 204 Thanks to Bram. 205 206 + Added increased compatibility with third party 207 Excel reading applications such as POI. 208 209 + Added optional compatibility_mode() to fix problems 210 that can occur with Office SP3. 211 212 + Fixed compatibility problem with Google Docs. 213 214 + Added set_start_page() method for setting the start page 215 number when printing. 216 217 2182.20 2007-06-10 219 220 221 + Added autofilter() and filter_column() method and 222 autofilter.pl example. 223 224 + Added embed_chart() method to allow extracted chart 225 templates to be embedded in a worksheet. 226 Added demo4.pl and demo5.pl examples. 227 228 + Added the insert_image() method and proper Excel 97 229 style image handling for PNG and BMP. 230 Images now work with Gnumeric and OpenOffice. 231 insert_bitmap() is now deprecated. 232 233 ! Made pane split optional when calling freeze_panes(). 234 Also renamed thaw_panes() as split_panes(). The old 235 method name is still available, but deprecated. 236 237 ! Renamed write_unicode() and write_unicode_le() methods 238 to the more explicit write_utf16be_string() and 239 write_utf16le_string(). The old method names are 240 still available, but deprecated. 241 242 2432.19 2007-14-06 244 245 + Beta testing only. Not released to CPAN. 246 247 2482.18 2007-18-01 249 250 ! Correct invalid user set_column() calls to prevent 251 crashes after Excel patch KB918419 is applied. 252 Thanks to Sharron McKenzie for debugging. 253 254 ! Fixed bug when writing comments longer than 8219 bytes. 255 Reported by jscaglione. 256 257 ! Fixed bug when using copy() with merged formats. 258 Reported by jscaglione. 259 260 ! Fixed bug where $@ was clobbered during garbage collection. 261 Reported by afoxson. 262 http://rt.cpan.org/Public/Bug/Display.html?id=24218 263 264 ! Removed all non-ascii characters from main docs to 265 avoid problems with troff and man. 266 Reported by Ken Williams. 267 http://rt.cpan.org/Public/Bug/Display.html?id=20948 268 269 + Added autoloading of OLE::Storage_Lite, when available, 270 to create workbooks larger than 7MB. It is no longer 271 required to explicitly use ::Big. 272 273 + Added handling of Unicode sheet names in formulas 274 as suggested by Zhur: 275 http://rt.cpan.org/Public/Bug/Display.html?id=20059 276 277 278 2792.17 2006-21-05 280 281 + Added set_tab_color() method and example (tab_colors.pl). 282 283 + Add set_page_view() method for Mac Excel view style 284 and better default worksheet dimensions. 285 286 + Added simulated row_wrap.pl example. 287 288 + Added simulated Autofit example (autofit.pl). 289 290 ! Fixed RT #17801, incorrect close value with filehandles. 291 Thanks to Josie. 292 293 ! Changed comment font to Excel's default of Tahoma 8. 294 Reported by Stefano Maurri. 295 296 ! Fixed bug that stopped Charts working in 2.16. 297 298 2992.16 2006-06-01 300 301 + Rewrote and reinstated the write_comment() method to take 302 account of the changes in the Excel 97+ comment format. 303 Currently conflicts with insert_bitmap(), see docs. 304 305 + Added standard styles such as comma, percent and currency. 306 307 ! Changed write_url() methods to allow numbers or formulas 308 as well as strings as the optional text. 309 Requested by many. 310 311 + Documented use of encoding flag in add_worksheet() to allow 312 handling of UTF-16 sheet names. 313 314 + Added encoding flag to merge_range() method to allow 315 handling of UTF-16 strings. Requested by many. 316 Added merge6.pl example program. 317 318 + Added hide_zero() worksheet method to allow hiding of zero 319 values in cells. 320 321 + Added print_across() worksheet method to allow changing of 322 the default print direction. 323 324 + Added right_to_left() worksheet method to allow changing of 325 the default worksheet direction in eastern versions of Excel. 326 327 + Documented the Worksheet hide() method. 328 329 + Added comments1.pl and comments2.pl example programs. 330 331 + Added tests for the internal methods used by write_comment(). 332 333 334 3352.15 2005-18-09 336 337 ! Changed OLE container stream name from "Book" to "Workbook" 338 for compatibility with some third party apps. 339 Thanks Wieland Pusch and Kevin McMahon. 340 341 ! Fixed bug that caused all worksheets to be selected in 342 OpenOfficeOrg causing strange linking of data between 343 Worksheets. Thanks M. Brodbelt. See 344 http://rt.cpan.org/NoAuth/Bug.html?id=14094 345 http://www.openoffice.org/issues/show_bug.cgi?id=52955 346 347 ! Changed file creation from end of program to the start of 348 program in order to avoid race conditions and extra file 349 creation on VMS. 350 351 + Added optional user supplied results for formulas as a 352 workaround for uncalculated values in some non-Excel apps. 353 Added formula_result.pl example of above. 354 355 3562.14 2005-09-05 357 358 ! Fixed handling of Unicode font names. 359 360 3612.13 2005-20-04 362 363 ! Made it a fatal error to use a merged format in a non- 364 merged cell (and vice-versa). This is a temporary measure 365 to prevent people from shooting themselves in the foot 366 until the Format.pm code can be refactored. 367 368 + Add 01_merge_formats.t test for above. 369 370 + Added date_time tests. 371 372 3732.12 2005-22-03 374 375 + Added further Unicode support. The following methods now 376 handle uft8 in perl 5.8: 377 add_worksheet() 378 set_header() 379 set_footer() 380 set_font() 381 set_num_format() 382 383 + Added unicode_cyrillic.pl example. 384 385 + Added 01_add_worksheet.t test. 386 387 3882.11 2004-30-09 389 390 - Removed undocumented date_time handling from write() to 391 avoid potential false matches. 392 393 + Added add_write_handler() method to allow users to add 394 their own data handlers to write(). 395 396 + Added 4 write_handler examples. 397 398 3992.10 2004-23-09 400 401 + Added chart support via external templates. 402 Added Chart.pm and add_chart_ext() method to Workbook object. 403 Added /charts directory with examples and documentation 404 405 + Added write_date_time() worksheet method for writing dates 406 and times in Excel date format. 407 Added date_time.pl example. 408 409 + Added automatic Unicode handling via utf8 in perl 5.8 and 410 later. Thanks Mark Fowler. 411 Added several unicode_*.pl examples in different encodings. 412 Thanks to Sean Burke for the sample encodings. 413 414 + Added write_to_scalar.pl example in order to answer frequently 415 asked question about writing an Excel file to a scalar. 416 417 4182.04 2004-18-08 419 420 ! Fixed handling of Euro symbol in num_format() strings. 421 422 ! Renamed the Excel 5 style merge() format to the more correct 423 center_across(). Updated examples accordingly. 424 425 ! Added bug warning about using merge formats outside of 426 merged ranges. 427 428 + Fixed handling of doubled double quotes in formula strings. 429 Thanks to a tip from merlyn. 430 431 + The 2.xx versions are now compatible with MS Access. Removed 432 statements to the contrary. 433 434 4352.03 2004-04-07 436 437 ! Fixed bug that prevented column outlines from displaying. 438 Thanks to Marc Rosenthal. 439 440 ! Enhanced add_worksheet() name checking to exclude case- 441 insensitive duplicate names. 442 Thanks to James Wilkinson. 443 444 ! Internal fix to number of rows in several (unseen) places. 445 446 + Added mod_perl 2 example program from Matisse Enzer. Thanks. 447 448 4492.02 2004-28-05 450 451 + Fixed internal version numbers to keep CPAN.pm happy. 452 Thanks to David Dyck. 453 454 + Minor changes to demo.pl merge5.pl and the html docs. 455 456 4572.01 2004-27-05 458 459 This version is a MAJOR revision to Spreadsheet::WriteExcel. The 460 format of the Excel file that it produces has been updated from 461 Excel 5 to Excel 97. This allows support for long, 32k character 462 strings and Unicode. 463 464 DUE TO THE MAJOR INTERNAL CHANGES IT IS RECOMMENDED THAT YOU TEST 465 THIS UPGRADE FULLY BEFORE DEPLOYING IT. 466 467 Also note that this version can be 1.5 to 2 times slower than 468 previous versions and the write_comment() method has been 469 temporarily removed. These issues will be fixed in later releases. 470 471 472 + Changed the default Excel format to Excel 97. 473 474 + Added support for strings up to 32767 character. 475 476 + Added support for Unicode strings. 477 478 + Improved speed in relation to pre-release versions. 479 However, it is still slower than the 1.xx versions. 480 481 + Improved OpenOffice.org support. 482 483 + Added more examples: diag_border.pl, indent.pl, 484 unicode.pl, unicode_japan.pl, unicode_list.pl 485 486 + Changed the distro dir structure. 487 488 - Temporarily removed write_comment() support since the Excel 5 489 version isn't compatible with Excel 97+. 490 491 4921.01 2004-24-05 493 494 ! Small non-bug fix to write_comment(). 495 496 4970.43 2004-28-04 498 499 ! Fixed longstanding bug where page setup features didn't 500 show up in OpenOffice.org. 501 502 ! Fixed localised @_ bug when using threaded perls. 503 Thanks Tamas Gulacsi and Stephan Loescher. 504 505 5060.42 2003-26-08 507 508 ! Fixed bug when using IO::Sclalar object as a filehandle. 509 Thanks to Kyle R. Burton and David Robins. 510 511 ! Fixed minor formula parser bug. 512 Thanks Michael Braig 513 514 ! Fixed handling of column sizing for widths less than 1 515 unit (again). Thanks to Rubio (again). 516 517 ! Failed new() returns undef instead of croak()ing as per docs. 518 519 5200.41 2003-24-04 521 522 + Added facility for adding outlines to worksheets. Added 523 outline.pl example. Thanks to Franco Venturi. 524 525 + Moved write_comment() code into the core modules. It is now 526 possible to write cell comments. 527 528 + Added option to return a slice from the sheets() method. 529 530 + Added link to latest Excel97 pre-release. 531 http://freshmeat.net/projects/writeexcel/#comment-24916 532 533 ! Changed, once more, the handling of temp files to avoid several 534 file closing bugs. Thanks to many. 535 536 ! Fixed handling of column sizing for widths less than 1 unit. 537 Thanks Rubio. 538 539 ! Renamed addworksheet() and addformat() to add_worksheet() 540 and add_format() for consistency with other method names. 541 Older names are supported but deprecated. 542 543 5440.40 2002-21-12 545 546 ! Fixed internal sheet indexing in formulas on some platforms. 547 This caused multi-sheet workbooks with formulas to crash. 548 Thanks Troy Daniels. 549 550 ! Fixed non-lexical filehandles to prevent problems in 551 multi-threaded environments. 552 Thanks Ning Xie. 553 554 5550.39 2002-23-09 556 557 + Added the set_codepage() workbook method. This is mainly to 558 prevent a bug that caused Gnumeric to crash but it is also 559 useful for people working with non ascii chars on the Macintosh. 560 Thanks Jody Goldberg. 561 562 ! Fixed the non-deletion of temporary files. Users of version 563 0.38 should probably clean up their tmp dirs manually. 564 Thanks Pierre Laplante. 565 566 ! Changed default handling of set_fg_color and set_bg_color from 567 what Excel expected to what everyone else expected. Setting the 568 fill colour of a cell should now be more intuitive. 569 570 + Replaced the merge_cells() method with the merge_range() method. 571 This is mainly to prevent the Excel 97 crashing bug that occurs 572 when merge_cells() is used correctly. It also provide a simpler 573 interface to the merge feature. Updated merge example programs. 574 575 ! Refactored the error raising mechanism for formulas. The source 576 of errors should now be clearer. 577 578 ! Minor internal fixes to Format.pm. 579 580 5810.38 2002-29-08 582 583 + Added formula caching to speed up the writing of formulas. 584 Thanks to Ron McKelvey. 585 586 + Added handling of A:A column notation in formulas and 587 applicable worksheet methods. 588 589 + Changed handling of numbers with leading zeroes so that they 590 can be treated as strings and the zeroes maintained. 591 592 + Modified $workbook->close() to return the value of the system 593 file close. 594 595 + Made file size exceeded a die() error instead of a warning. 596 597 + Added option to hide row with the set_row() method 598 599 + Added more examples: merge4.pl, merge5.pl, sendmail.pl and 600 repeat.pl 601 602 ! Fixed write_url() when handling relative links in the current 603 directory. Thanks Bob Mackay Andre de Bruin 604 605 ! Fixed handling of multiple AND()'s and OR()'s in formulas. 606 607 ! Fixed bug when creating a very large number of files within a 608 single program on Windows. 609 610 ! Added warning about Excel97 crashing bug with merge_cells(). 611 612 ! Fixed handling of parentheses in Worksheet names. 613 Thanks Jann Linder. 614 615 ! Fixed minor bugs in Format.pm. Thanks Johann Hanne. 616 617 ! Fixed File::Temp dependency in Makefile. Thanks to many. 618 619 6200.37 2002-29-04 621 622 + Added set_tempdir() method to allow a user defined temp 623 directory. This is mainly of use to IIS users. 624 625 + Fixed default format behaviour for formats set via the set_row() 626 and set_column() methods. 627 628 + Extended the hide_gridlines() method to allow hiding of screen 629 gridlines as well as print gridlines. 630 631 + Added long_string.pl a workaround example for the 255 char 632 limit. 633 634 + Added https match to url regex. Thanks The Tilghman. 635 636 6370.36 2002-09-04 638 639 + Added user definable colour palette. Thanks Bill Young. 640 641 + Added headers.pl and colors.pl examples. 642 643 6440.35 2002-18-03 645 646 + Added internal and external hyperlinks. Thanks Ian Penman. 647 648 + Added worksheet set_zoom() and set_print_scale(). 649 650 ! Changed default value of fit_to_pages() to allow printed output 651 to be one page wide and as long as required. 652 Thanks Michael Erickson. 653 654 ! Changed handling of undefs in write() method. Thanks Hanc Pavel. 655 656 ! Changed new() to return undef for file creation errors 657 Thanks Felipe P�rez Galiana. 658 659 ! Added check for header/footer length. Thanks Peter Dintelmann. 660 661 ! Added check for duplicate worksheet names. Thanks Keith Miller. 662 663 - Removed spurious return() to fix bug in set_repeat_rows(). 664 Thanks Brian White. 665 666 ! Added "use integer" when using shift << to avoid bug with 667 Perl 5.6.0 on HP-UX. Thanks Markus Schmitz, VSarkiss. 668 669 ! Fixed minor bug in Formula.pm. Thanks Sven Passig. 670 671 6720.34 2001-23-10 673 674 + Added Spreadsheet::WriteExcel::Utility module with helper 675 functions for row/col and dates. 676 677 + Added write_row and write_col methods after many requests. 678 679 + Added ability to insert bitmap images. 680 681 + Added cell protection and formula hiding. 682 683 + Added more examples. 684 685 6860.33 2001-30-07 687 688 + Added (hopefully) easier mechanism to add format properties. 689 690 + Added more page setup options: repeat rows and columns, hide 691 gridlines, print area, fit to pages and page breaks. 692 693 ! Added fix to protect print() from -l on the command line. 694 Thanks Cedric Bouvier and Kyle Krom. 695 696 + Added more examples. 697 698 6990.32 2001-17-05 700 701 + Added panes option. 702 703 + Added page setup options: paper type, orientation, headers 704 footers, centering. 705 706 + Added panes example. 707 708 7090.31 2001-12-04 710 711 ! Fixed several minor and major bugs in Formula.pm. 712 Thanks Shane Ashby and Borgar Olsen and Christian Kirsch. 713 714 + Added external worksheet references to formulas. 715 716 + Added A1 notation. 717 718 + Added facility to new() to accept valid filehandles. 719 Thanks Peter Dintelmann. 720 721 + Added more examples. Thanks Tom O'Sullivan. 722 723 ! Updated bigfile.pl example. Thanks to Takanori Kawai. 724 725 7260.30 2001-26-02 727 728 + Added formulas. 729 730 ! Fixed docs for write_url(). Thanks James Holmes. 731 732 ! Fixed bug when using a numeric format string of zeros. 733 Thanks Kenneth Stacey. 734 735 7360.26 2001-01-02 737 738 ! Fixed bug when using a border with the default colour. This 739 caused the cell format to become unchangeable from within Excel. 740 Thanks Shenyu Zheng. 741 742 ! Changed worksheet code to automatically fall back to storing 743 data in memory if opening a tmp file fails. 744 745 7460.25 2001-19-01 747 748 ! Changed distro file format back to Unix line endings. The 749 accidental DOS format was causing install problems. 750 751 7520.24 2001-14-01 753 754 + Added write_url method. 755 756 + Added set_merge() alias for set_align('merge') method. 757 758 + Added warnings about deprecated code when running under -w flag. 759 760 ! Documentation changes. 761 762 7630.23 2000-10-12 764 765 + Added customisable numeric formats. 766 767 + Added set_row() method. 768 769 + Added set_1904() method. 770 771 + Added extra examples including contributions. Thanks to all. 772 773 + Moved secondary modules to WriteExcel namespace to clean-up 774 Spreadsheet namespace which is now shared with ParseExcel. 775 776 ! Fixed class data bug. Thanks Cedric Bouvier. 777 778 ! Fixed Excel crashing!! bug in STYLE. Thanks Rich Sorden. 779 780 ! Tidied up internal storage of FONTs and XFs. 781 782 + Renamed set_col_width() method to set_column(). 783 784 + Renamed set_format() method to set_num_format(). 785 786 7870.22 2000-22-10 788 789 + Added Format.pm and the facility for cell formatting. 790 791 7920.21 2000-01-10 793 794 + Replaced direct access to worksheets array with a workbook 795 method; worksheets(). 796 797 + Added set_selection() and set_col_width() worksheet methods. 798 799 ! Replaced the missing thats, including the that that were 800 in the icebox. 801 802 + Added MS Access bug warning; thanks Harold Bamford. 803 804 8050.20 2000-27-08 806 807 + Added multiple worksheets and OLE wrapper. Now compatible with 808 Star Office, Gnumeric and XESS. 809 810 8110.11 2000-25-08 812 813 ! Changes to documentation. Explanation of how to use WriteExcel 814 in CGI's. Thanks Daniel Gardner. 815 816 8170.10 2000-13-05 818 819 ! Bug in close() and DESTROY sequence fixed. Thanks John Wren. 820 821 ! Biff version number fixed. Thanks Aurthur@ais, and then unfixed. 822 823 ! Shakey test and distro fixed. Thanks to many. 824 825 8260.09 2000-01-02 827 828 ! Code for writing DIMENSIONS updated to account for bug when 829 reading files with QuickView. 830 831 + Renamed xl_write methods to write. 832 833 8340.08 2000-16-01 835 836 First CPAN release. Spreadsheet::WriteExcel - Write text and 837 numbers to minimal Excel binary file. 838