From 0a18b407d24e9e5b2f5d4ddaa7749f31a051800b Mon Sep 17 00:00:00 2001 From: opensides Date: Fri, 28 Oct 2005 12:20:41 +0000 Subject: [PATCH] remove examples not necessary to make plugin work git-svn-id: https://oss.gonicus.de/repositories/gosa/trunk@1741 594d385d-05f5-0310-b6e9-bd551577e9d8 --- include/php_writeexcel/CHANGELOG | 61 --- include/php_writeexcel/CONTACT | 1 - include/php_writeexcel/FAQ | 18 - include/php_writeexcel/HOMEPAGE | 1 - include/php_writeexcel/LICENSE | 504 -------------------- include/php_writeexcel/README | 118 ----- include/php_writeexcel/THANKS | 5 - include/php_writeexcel/example-bigfile.php | 27 -- include/php_writeexcel/example-demo.php | 102 ---- include/php_writeexcel/example-merge2.php | 59 --- include/php_writeexcel/example-simple.php | 39 -- include/php_writeexcel/example-stocks.php | 70 --- include/php_writeexcel/example-textwrap.php | 71 --- 13 files changed, 1076 deletions(-) delete mode 100644 include/php_writeexcel/CHANGELOG delete mode 100644 include/php_writeexcel/CONTACT delete mode 100644 include/php_writeexcel/FAQ delete mode 100644 include/php_writeexcel/HOMEPAGE delete mode 100644 include/php_writeexcel/LICENSE delete mode 100644 include/php_writeexcel/README delete mode 100644 include/php_writeexcel/THANKS delete mode 100644 include/php_writeexcel/example-bigfile.php delete mode 100644 include/php_writeexcel/example-demo.php delete mode 100644 include/php_writeexcel/example-merge2.php delete mode 100644 include/php_writeexcel/example-simple.php delete mode 100644 include/php_writeexcel/example-stocks.php delete mode 100644 include/php_writeexcel/example-textwrap.php diff --git a/include/php_writeexcel/CHANGELOG b/include/php_writeexcel/CHANGELOG deleted file mode 100644 index a4615cbc1..000000000 --- a/include/php_writeexcel/CHANGELOG +++ /dev/null @@ -1,61 +0,0 @@ -0.2.2 (2003-10-08): -- Cleaned up class.writeexcel_biffwriter.inc.php -- Cleaned up _append() and _prepend() in class.writeexcel_biffwriter.inc.php - and class.writeexcel_worksheet.inc.php to no longer use func_get_args() - but require exactly one argument instead (internal api change) -- Changed class to support tmpfile. Because of this it is possible now to - create an excel sheet on the fly that can be send by web server and is - afterwards deleted. To provoke this behaviour you just pass an empty file - name and later on use the writexcel_workbook->send(filename) function. - (contributed by Andreas Brodowski) -- Imported and changed the PEAR::Spreadsheet Parser.php file to allow - formulas in worksheets (contributed by Andreas Brodowski) - -0.2.1 (2002-11-11): -- Corrected two typos in class.writeexcel_format.inc.php - (thanks to Peter van Aarle) -- Fixed cell bg_color (thanks to Jason McCarver for the patch) -- Added support for Big/Little Endian (thanks to Marc Dilasser) -- Added FAQ -- Random cleanups - -0.2.0 (2002-09-04): -- Added missing methods set_bg_color(), set_rotation(), set_text_justlast(), - set_locked(), set_hidden(), set_font_script(), set_font_shadow(), - set_font_outline() and set_font_strikeout() to - class.writeexcel_format.inc.php -- Cleaned up class.writeexcel_format.inc.php -- Moved $monthdays() in functions.writeexcel_utility.inc.php into - xl_date_list() -- Fixed all calls to call_user_func_array() and call_user_method_array() - where the first parameter was an undefined constant (thanks Arnaud Limbourg) -- Cleaned up class.writeexcel_olewriter.inc.php -- Temporarily moved class.writeexcel_formula.inc.php out of the archive - because formulas are not yet supported -- Added support for files bigger than 7 MB - (class.writeexcel_workbookbig.inc.php), requires php_ole -- Added example which creates a file bigger than 7 MB (example-bigfile.php) -- Changed dates in CHANGELOG to international notation -- Updated the README file - -0.1.2 (2002-08-10): -- Fixed xl_date_list() in class.writeexcel_utility.inc.php -- Cleaned up class.writeexcel_utility.inc.php -- Renamed class.writeexcel_utility.inc.php to - functions.writeexcel_utility.inc.php (it isn't actually a class) -- Changed "pack("NN", 0xD0CF11E0, 0xA1B11AE1)" to - "pack("C8", 0xD0, 0xCF, 0x11, 0xE0, 0xA1, 0xB1, 0x1A, 0xE1)" - in class.writeexcel_olewriter.inc.php which seems to work around a bug in - some PHP versions (thanks to Maître Reizz for this one!) - -0.1.1 (2002-07-30): -- Fixed several PHP warnings regarding call-time pass-by-reference and - undefined constants -- Changed "Spreadsheet::WriteExcel" to "php_writeexcel" in example-demo.php -- Changed fopen() calls to explicitely open files in binary mode - -0.1.0 (2002-05-20): -- Added support for inserting bitmaps (insert_bitmap in writeexcel_worksheet) -- Some fixes for improved compatibility with the Spreadsheet::WriteExcel - examples (see example-*.php) -- Some random bugfixes diff --git a/include/php_writeexcel/CONTACT b/include/php_writeexcel/CONTACT deleted file mode 100644 index 97aa88033..000000000 --- a/include/php_writeexcel/CONTACT +++ /dev/null @@ -1 +0,0 @@ -You can contact me via email at . diff --git a/include/php_writeexcel/FAQ b/include/php_writeexcel/FAQ deleted file mode 100644 index 574eaa685..000000000 --- a/include/php_writeexcel/FAQ +++ /dev/null @@ -1,18 +0,0 @@ -Q: Could you please add support for XYZGJGNDF? -A: Sorry, this project is at its alpha stage. I won't add any new features - until there is a stable version. - -Q: The files class.ole_pps_root.php and class.ole_pps_file.php are - missing. Where can I get them? -A: They are only required for big file (>7 MB) support and available - as a seperate project at - http://bettina-attack.de/jonny/view.php?path=/projects/php_ole/ - -Q: How can I create files bigger than 7 MB? -A: Use class.writeexcel_workbookbig.inc.php instead of - class.writeexcel_workbook.inc.php. You'll need the php_ole project - available at - http://bettina-attack.de/jonny/view.php?path=/projects/php_ole/ - -Q: Will you make the project PEAR compliant? -A: Probably. But this means a lot of work and will require some time. diff --git a/include/php_writeexcel/HOMEPAGE b/include/php_writeexcel/HOMEPAGE deleted file mode 100644 index 9415c9d94..000000000 --- a/include/php_writeexcel/HOMEPAGE +++ /dev/null @@ -1 +0,0 @@ -http://www.bettina-attack.de/jonny/projects/php_writeexcel/ diff --git a/include/php_writeexcel/LICENSE b/include/php_writeexcel/LICENSE deleted file mode 100644 index b1e3f5a26..000000000 --- a/include/php_writeexcel/LICENSE +++ /dev/null @@ -1,504 +0,0 @@ - GNU LESSER GENERAL PUBLIC LICENSE - Version 2.1, February 1999 - - Copyright (C) 1991, 1999 Free Software Foundation, Inc. - 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - Everyone is permitted to copy and distribute verbatim copies - of this license document, but changing it is not allowed. - -[This is the first released version of the Lesser GPL. It also counts - as the successor of the GNU Library Public License, version 2, hence - the version number 2.1.] - - Preamble - - The licenses for most software are designed to take away your -freedom to share and change it. By contrast, the GNU General Public -Licenses are intended to guarantee your freedom to share and change -free software--to make sure the software is free for all its users. - - This license, the Lesser General Public License, applies to some -specially designated software packages--typically libraries--of the -Free Software Foundation and other authors who decide to use it. You -can use it too, but we suggest you first think carefully about whether -this license or the ordinary General Public License is the better -strategy to use in any particular case, based on the explanations below. - - When we speak of free software, we are referring to freedom of use, -not price. Our General Public Licenses are designed to make sure that -you have the freedom to distribute copies of free software (and charge -for this service if you wish); that you receive source code or can get -it if you want it; that you can change the software and use pieces of -it in new free programs; and that you are informed that you can do -these things. - - To protect your rights, we need to make restrictions that forbid -distributors to deny you these rights or to ask you to surrender these -rights. These restrictions translate to certain responsibilities for -you if you distribute copies of the library or if you modify it. - - For example, if you distribute copies of the library, whether gratis -or for a fee, you must give the recipients all the rights that we gave -you. You must make sure that they, too, receive or can get the source -code. If you link other code with the library, you must provide -complete object files to the recipients, so that they can relink them -with the library after making changes to the library and recompiling -it. And you must show them these terms so they know their rights. - - We protect your rights with a two-step method: (1) we copyright the -library, and (2) we offer you this license, which gives you legal -permission to copy, distribute and/or modify the library. - - To protect each distributor, we want to make it very clear that -there is no warranty for the free library. Also, if the library is -modified by someone else and passed on, the recipients should know -that what they have is not the original version, so that the original -author's reputation will not be affected by problems that might be -introduced by others. - - Finally, software patents pose a constant threat to the existence of -any free program. We wish to make sure that a company cannot -effectively restrict the users of a free program by obtaining a -restrictive license from a patent holder. Therefore, we insist that -any patent license obtained for a version of the library must be -consistent with the full freedom of use specified in this license. - - Most GNU software, including some libraries, is covered by the -ordinary GNU General Public License. This license, the GNU Lesser -General Public License, applies to certain designated libraries, and -is quite different from the ordinary General Public License. We use -this license for certain libraries in order to permit linking those -libraries into non-free programs. - - When a program is linked with a library, whether statically or using -a shared library, the combination of the two is legally speaking a -combined work, a derivative of the original library. The ordinary -General Public License therefore permits such linking only if the -entire combination fits its criteria of freedom. The Lesser General -Public License permits more lax criteria for linking other code with -the library. - - We call this license the "Lesser" General Public License because it -does Less to protect the user's freedom than the ordinary General -Public License. It also provides other free software developers Less -of an advantage over competing non-free programs. These disadvantages -are the reason we use the ordinary General Public License for many -libraries. However, the Lesser license provides advantages in certain -special circumstances. - - For example, on rare occasions, there may be a special need to -encourage the widest possible use of a certain library, so that it becomes -a de-facto standard. To achieve this, non-free programs must be -allowed to use the library. A more frequent case is that a free -library does the same job as widely used non-free libraries. In this -case, there is little to gain by limiting the free library to free -software only, so we use the Lesser General Public License. - - In other cases, permission to use a particular library in non-free -programs enables a greater number of people to use a large body of -free software. For example, permission to use the GNU C Library in -non-free programs enables many more people to use the whole GNU -operating system, as well as its variant, the GNU/Linux operating -system. - - Although the Lesser General Public License is Less protective of the -users' freedom, it does ensure that the user of a program that is -linked with the Library has the freedom and the wherewithal to run -that program using a modified version of the Library. - - The precise terms and conditions for copying, distribution and -modification follow. Pay close attention to the difference between a -"work based on the library" and a "work that uses the library". The -former contains code derived from the library, whereas the latter must -be combined with the library in order to run. - - GNU LESSER GENERAL PUBLIC LICENSE - TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION - - 0. This License Agreement applies to any software library or other -program which contains a notice placed by the copyright holder or -other authorized party saying it may be distributed under the terms of -this Lesser General Public License (also called "this License"). -Each licensee is addressed as "you". - - A "library" means a collection of software functions and/or data -prepared so as to be conveniently linked with application programs -(which use some of those functions and data) to form executables. - - The "Library", below, refers to any such software library or work -which has been distributed under these terms. A "work based on the -Library" means either the Library or any derivative work under -copyright law: that is to say, a work containing the Library or a -portion of it, either verbatim or with modifications and/or translated -straightforwardly into another language. (Hereinafter, translation is -included without limitation in the term "modification".) - - "Source code" for a work means the preferred form of the work for -making modifications to it. For a library, complete source code means -all the source code for all modules it contains, plus any associated -interface definition files, plus the scripts used to control compilation -and installation of the library. - - Activities other than copying, distribution and modification are not -covered by this License; they are outside its scope. The act of -running a program using the Library is not restricted, and output from -such a program is covered only if its contents constitute a work based -on the Library (independent of the use of the Library in a tool for -writing it). Whether that is true depends on what the Library does -and what the program that uses the Library does. - - 1. You may copy and distribute verbatim copies of the Library's -complete source code as you receive it, in any medium, provided that -you conspicuously and appropriately publish on each copy an -appropriate copyright notice and disclaimer of warranty; keep intact -all the notices that refer to this License and to the absence of any -warranty; and distribute a copy of this License along with the -Library. - - You may charge a fee for the physical act of transferring a copy, -and you may at your option offer warranty protection in exchange for a -fee. - - 2. You may modify your copy or copies of the Library or any portion -of it, thus forming a work based on the Library, and copy and -distribute such modifications or work under the terms of Section 1 -above, provided that you also meet all of these conditions: - - a) The modified work must itself be a software library. - - b) You must cause the files modified to carry prominent notices - stating that you changed the files and the date of any change. - - c) You must cause the whole of the work to be licensed at no - charge to all third parties under the terms of this License. - - d) If a facility in the modified Library refers to a function or a - table of data to be supplied by an application program that uses - the facility, other than as an argument passed when the facility - is invoked, then you must make a good faith effort to ensure that, - in the event an application does not supply such function or - table, the facility still operates, and performs whatever part of - its purpose remains meaningful. - - (For example, a function in a library to compute square roots has - a purpose that is entirely well-defined independent of the - application. Therefore, Subsection 2d requires that any - application-supplied function or table used by this function must - be optional: if the application does not supply it, the square - root function must still compute square roots.) - -These requirements apply to the modified work as a whole. If -identifiable sections of that work are not derived from the Library, -and can be reasonably considered independent and separate works in -themselves, then this License, and its terms, do not apply to those -sections when you distribute them as separate works. But when you -distribute the same sections as part of a whole which is a work based -on the Library, the distribution of the whole must be on the terms of -this License, whose permissions for other licensees extend to the -entire whole, and thus to each and every part regardless of who wrote -it. - -Thus, it is not the intent of this section to claim rights or contest -your rights to work written entirely by you; rather, the intent is to -exercise the right to control the distribution of derivative or -collective works based on the Library. - -In addition, mere aggregation of another work not based on the Library -with the Library (or with a work based on the Library) on a volume of -a storage or distribution medium does not bring the other work under -the scope of this License. - - 3. You may opt to apply the terms of the ordinary GNU General Public -License instead of this License to a given copy of the Library. To do -this, you must alter all the notices that refer to this License, so -that they refer to the ordinary GNU General Public License, version 2, -instead of to this License. (If a newer version than version 2 of the -ordinary GNU General Public License has appeared, then you can specify -that version instead if you wish.) Do not make any other change in -these notices. - - Once this change is made in a given copy, it is irreversible for -that copy, so the ordinary GNU General Public License applies to all -subsequent copies and derivative works made from that copy. - - This option is useful when you wish to copy part of the code of -the Library into a program that is not a library. - - 4. You may copy and distribute the Library (or a portion or -derivative of it, under Section 2) in object code or executable form -under the terms of Sections 1 and 2 above provided that you accompany -it with the complete corresponding machine-readable source code, which -must be distributed under the terms of Sections 1 and 2 above on a -medium customarily used for software interchange. - - If distribution of object code is made by offering access to copy -from a designated place, then offering equivalent access to copy the -source code from the same place satisfies the requirement to -distribute the source code, even though third parties are not -compelled to copy the source along with the object code. - - 5. A program that contains no derivative of any portion of the -Library, but is designed to work with the Library by being compiled or -linked with it, is called a "work that uses the Library". Such a -work, in isolation, is not a derivative work of the Library, and -therefore falls outside the scope of this License. - - However, linking a "work that uses the Library" with the Library -creates an executable that is a derivative of the Library (because it -contains portions of the Library), rather than a "work that uses the -library". The executable is therefore covered by this License. -Section 6 states terms for distribution of such executables. - - When a "work that uses the Library" uses material from a header file -that is part of the Library, the object code for the work may be a -derivative work of the Library even though the source code is not. -Whether this is true is especially significant if the work can be -linked without the Library, or if the work is itself a library. The -threshold for this to be true is not precisely defined by law. - - If such an object file uses only numerical parameters, data -structure layouts and accessors, and small macros and small inline -functions (ten lines or less in length), then the use of the object -file is unrestricted, regardless of whether it is legally a derivative -work. (Executables containing this object code plus portions of the -Library will still fall under Section 6.) - - Otherwise, if the work is a derivative of the Library, you may -distribute the object code for the work under the terms of Section 6. -Any executables containing that work also fall under Section 6, -whether or not they are linked directly with the Library itself. - - 6. As an exception to the Sections above, you may also combine or -link a "work that uses the Library" with the Library to produce a -work containing portions of the Library, and distribute that work -under terms of your choice, provided that the terms permit -modification of the work for the customer's own use and reverse -engineering for debugging such modifications. - - You must give prominent notice with each copy of the work that the -Library is used in it and that the Library and its use are covered by -this License. You must supply a copy of this License. If the work -during execution displays copyright notices, you must include the -copyright notice for the Library among them, as well as a reference -directing the user to the copy of this License. Also, you must do one -of these things: - - a) Accompany the work with the complete corresponding - machine-readable source code for the Library including whatever - changes were used in the work (which must be distributed under - Sections 1 and 2 above); and, if the work is an executable linked - with the Library, with the complete machine-readable "work that - uses the Library", as object code and/or source code, so that the - user can modify the Library and then relink to produce a modified - executable containing the modified Library. (It is understood - that the user who changes the contents of definitions files in the - Library will not necessarily be able to recompile the application - to use the modified definitions.) - - b) Use a suitable shared library mechanism for linking with the - Library. A suitable mechanism is one that (1) uses at run time a - copy of the library already present on the user's computer system, - rather than copying library functions into the executable, and (2) - will operate properly with a modified version of the library, if - the user installs one, as long as the modified version is - interface-compatible with the version that the work was made with. - - c) Accompany the work with a written offer, valid for at - least three years, to give the same user the materials - specified in Subsection 6a, above, for a charge no more - than the cost of performing this distribution. - - d) If distribution of the work is made by offering access to copy - from a designated place, offer equivalent access to copy the above - specified materials from the same place. - - e) Verify that the user has already received a copy of these - materials or that you have already sent this user a copy. - - For an executable, the required form of the "work that uses the -Library" must include any data and utility programs needed for -reproducing the executable from it. However, as a special exception, -the materials to be distributed need not include anything that is -normally distributed (in either source or binary form) with the major -components (compiler, kernel, and so on) of the operating system on -which the executable runs, unless that component itself accompanies -the executable. - - It may happen that this requirement contradicts the license -restrictions of other proprietary libraries that do not normally -accompany the operating system. Such a contradiction means you cannot -use both them and the Library together in an executable that you -distribute. - - 7. You may place library facilities that are a work based on the -Library side-by-side in a single library together with other library -facilities not covered by this License, and distribute such a combined -library, provided that the separate distribution of the work based on -the Library and of the other library facilities is otherwise -permitted, and provided that you do these two things: - - a) Accompany the combined library with a copy of the same work - based on the Library, uncombined with any other library - facilities. This must be distributed under the terms of the - Sections above. - - b) Give prominent notice with the combined library of the fact - that part of it is a work based on the Library, and explaining - where to find the accompanying uncombined form of the same work. - - 8. You may not copy, modify, sublicense, link with, or distribute -the Library except as expressly provided under this License. Any -attempt otherwise to copy, modify, sublicense, link with, or -distribute the Library is void, and will automatically terminate your -rights under this License. However, parties who have received copies, -or rights, from you under this License will not have their licenses -terminated so long as such parties remain in full compliance. - - 9. You are not required to accept this License, since you have not -signed it. However, nothing else grants you permission to modify or -distribute the Library or its derivative works. These actions are -prohibited by law if you do not accept this License. Therefore, by -modifying or distributing the Library (or any work based on the -Library), you indicate your acceptance of this License to do so, and -all its terms and conditions for copying, distributing or modifying -the Library or works based on it. - - 10. Each time you redistribute the Library (or any work based on the -Library), the recipient automatically receives a license from the -original licensor to copy, distribute, link with or modify the Library -subject to these terms and conditions. You may not impose any further -restrictions on the recipients' exercise of the rights granted herein. -You are not responsible for enforcing compliance by third parties with -this License. - - 11. If, as a consequence of a court judgment or allegation of patent -infringement or for any other reason (not limited to patent issues), -conditions are imposed on you (whether by court order, agreement or -otherwise) that contradict the conditions of this License, they do not -excuse you from the conditions of this License. If you cannot -distribute so as to satisfy simultaneously your obligations under this -License and any other pertinent obligations, then as a consequence you -may not distribute the Library at all. For example, if a patent -license would not permit royalty-free redistribution of the Library by -all those who receive copies directly or indirectly through you, then -the only way you could satisfy both it and this License would be to -refrain entirely from distribution of the Library. - -If any portion of this section is held invalid or unenforceable under any -particular circumstance, the balance of the section is intended to apply, -and the section as a whole is intended to apply in other circumstances. - -It is not the purpose of this section to induce you to infringe any -patents or other property right claims or to contest validity of any -such claims; this section has the sole purpose of protecting the -integrity of the free software distribution system which is -implemented by public license practices. Many people have made -generous contributions to the wide range of software distributed -through that system in reliance on consistent application of that -system; it is up to the author/donor to decide if he or she is willing -to distribute software through any other system and a licensee cannot -impose that choice. - -This section is intended to make thoroughly clear what is believed to -be a consequence of the rest of this License. - - 12. If the distribution and/or use of the Library is restricted in -certain countries either by patents or by copyrighted interfaces, the -original copyright holder who places the Library under this License may add -an explicit geographical distribution limitation excluding those countries, -so that distribution is permitted only in or among countries not thus -excluded. In such case, this License incorporates the limitation as if -written in the body of this License. - - 13. The Free Software Foundation may publish revised and/or new -versions of the Lesser General Public License from time to time. -Such new versions will be similar in spirit to the present version, -but may differ in detail to address new problems or concerns. - -Each version is given a distinguishing version number. If the Library -specifies a version number of this License which applies to it and -"any later version", you have the option of following the terms and -conditions either of that version or of any later version published by -the Free Software Foundation. If the Library does not specify a -license version number, you may choose any version ever published by -the Free Software Foundation. - - 14. If you wish to incorporate parts of the Library into other free -programs whose distribution conditions are incompatible with these, -write to the author to ask for permission. For software which is -copyrighted by the Free Software Foundation, write to the Free -Software Foundation; we sometimes make exceptions for this. Our -decision will be guided by the two goals of preserving the free status -of all derivatives of our free software and of promoting the sharing -and reuse of software generally. - - NO WARRANTY - - 15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO -WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW. -EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR -OTHER PARTIES PROVIDE THE LIBRARY "AS IS" WITHOUT WARRANTY OF ANY -KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE -IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR -PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE -LIBRARY IS WITH YOU. SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME -THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. - - 16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN -WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY -AND/OR REDISTRIBUTE THE LIBRARY AS PERMITTED ABOVE, BE LIABLE TO YOU -FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR -CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE -LIBRARY (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING -RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A -FAILURE OF THE LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF -SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH -DAMAGES. - - END OF TERMS AND CONDITIONS - - How to Apply These Terms to Your New Libraries - - If you develop a new library, and you want it to be of the greatest -possible use to the public, we recommend making it free software that -everyone can redistribute and change. You can do so by permitting -redistribution under these terms (or, alternatively, under the terms of the -ordinary General Public License). - - To apply these terms, attach the following notices to the library. It is -safest to attach them to the start of each source file to most effectively -convey the exclusion of warranty; and each file should have at least the -"copyright" line and a pointer to where the full notice is found. - - - Copyright (C) - - This library is free software; you can redistribute it and/or - modify it under the terms of the GNU Lesser General Public - License as published by the Free Software Foundation; either - version 2.1 of the License, or (at your option) any later version. - - This library is distributed in the hope that it will be useful, - but WITHOUT ANY WARRANTY; without even the implied warranty of - MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - Lesser General Public License for more details. - - You should have received a copy of the GNU Lesser General Public - License along with this library; if not, write to the Free Software - Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA - -Also add information on how to contact you by electronic and paper mail. - -You should also get your employer (if you work as a programmer) or your -school, if any, to sign a "copyright disclaimer" for the library, if -necessary. Here is a sample; alter the names: - - Yoyodyne, Inc., hereby disclaims all copyright interest in the - library `Frob' (a library for tweaking knobs) written by James Random Hacker. - - , 1 April 1990 - Ty Coon, President of Vice - -That's all there is to it! - - diff --git a/include/php_writeexcel/README b/include/php_writeexcel/README deleted file mode 100644 index eb53e6634..000000000 --- a/include/php_writeexcel/README +++ /dev/null @@ -1,118 +0,0 @@ -What is it all about? ---------------------- -php_writeexcel is a port of John McNamara's excellent Spreadsheet::WriteExcel -Perl package to PHP. It allows you to generate Microsoft Excel documents on -your PHP enabled Web server without any other tools. - - - -Where to start --------------- -I've included six example PHP scripts which are also taken out of the -Spreadsheet::WriteExcel package and ported to PHP: -- example-simple.php -- example-merge2.php -- example-stocks.php -- example-textwrap.php -- example-demo.php -- example-bigfile.php -All you have to do is to tar xzvf the package to a directory accessible -via a web server. Then fetch any of the example scripts with your -favourite web browser and Excel should come into place and show you -a sheet. - - - -Problems of porting Perl code to PHP ------------------------------------- -When you take a first look at both languages, they seem to be very -similar: Variable names begin with a dollar sign, control structures -look like in C. You don't have to change most of these things. - -Then, there are things which can be done by find and replace: Perl subs -are functions in PHP. Perl properties like $this->{prop} are $this->prop -in PHP. "elsif" in Perl is "elseif" in PHP. Even porting Perl's so called -OOP is not very difficult: just delete the "my $this=shift;" at the -beginning of each method and then put all the methods into a class {} block. -Just be aware that in Perl not the function declaration decides if the -function is a method or not, but the call of the function. If you say -myfunc(), it's a function, if you say $obj->myfunc(), it's a method. - -Then the trouble begins. There were three major things I had problems -with while porting SpreadSheet::WriteExcel to PHP: -- function (sub) handling: - In Perl's list philosophy the number of paramaters and return values - are variable by design: Just use myfunc(@myarray) to pass a complete - array to the function and the array's values will be the function's - arguments. - In PHP this is possible though undesirable as you have to use ugly - things like call_user_function_array() and call_user_method_array() - if you want to translate the Perl code literally. -- Reference juggling: - This can be very confusing when reading Perl code making - excessive use of it. References are supported by PHP, but it's - hard to translate them mainly due to to PHP's habit to copy - EVERYTHING on any assignment. Even if you do a "$obj=new myclass();", - PHP will create a copy of the instantiated class. It's sometimes - hard to recognize when you have to use the "=&" operator to create - a reference instead of a copy. And, hey, when the hell will the - PHP developers implement a foreach loop which assigns the array - values by reference?? :-( -- Perl's AUTOLOAD method - PHP does not have such a thing. When - a class has many properties and the AUTOLOAD method is used - to simulate a set_xxx() for each property, you'll have to define all - possible function calls manually. - - - -What features are currently supported? --------------------------------------- -Basically all features of Spreadsheet::WriteExcel will hopefully be -supported one day. However, it makes use of some Perl packages with -functions I did not yet find for PHP. - -Spreadsheet::WriteExcel uses the Parse::RecDescent package for formula -support. I havn't looked for a Recursive Descent parser for PHP yet. Thus -Excel formulas are not yet supported. - -Spreadsheet::WriteExcel uses the OLE::Storage_Lite package for -supporting Excel files bigger than approx. 7 MB. I have ported this -package already and called it php_ole. But I really don't know how -reliable it is, so use it with care! - -All other features SHOULD work. - - - -Documentation -------------- -Sorry, there is no documentation yet. You'll have to use the documentation -for Spreadsheet::WriteExcel available at -http://search.cpan.org/doc/JMCNAMARA/Spreadsheet-WriteExcel-0.37/WriteExcel/doc/WriteExcel.html -for now. Try to translate the Perl code into PHP with the help of the -examples. Please note that you have to assign variables by reference -(using the =& operator) quite often! - - - -Reporting bugs --------------- -If you've found a bug, please send a bug report to jonny@nurfuerspam.de. -Please include "php_writeexcel" in the subject so that I can search for bug -reports by searching for that string. -Please note that my email address has changed. Several mails have been lost, -so if you patch didn't get it, please resend it. -If you get error messages, please include them in your report. Please also -check your Apache error_log for messages coming from php_writeexcel. -If you get corrupted Excel files, please include them in your email. If -one of the demos generates a corrupted file please try to find out the -differences between your file and the file you are getting from the -online demo at the php_writeexcel homepage! - - - - -Syntax different from SpreadSheet::WriteExcel ---------------------------------------------- -The worksheet methods set_h_pagebreaks() and set_v_pagebreaks() take -exactly one argument which must be an array with the desired page breaks. diff --git a/include/php_writeexcel/THANKS b/include/php_writeexcel/THANKS deleted file mode 100644 index 241147852..000000000 --- a/include/php_writeexcel/THANKS +++ /dev/null @@ -1,5 +0,0 @@ -Thanks go to John McNamara for his excellent Spreadsheet::WriteExcel -package. Without him, php_writeexcel wouldn't exist. - -Also thanks to all people who sent me patches and bug reports (see -the CHANGES file). diff --git a/include/php_writeexcel/example-bigfile.php b/include/php_writeexcel/example-bigfile.php deleted file mode 100644 index 586ae487b..000000000 --- a/include/php_writeexcel/example-bigfile.php +++ /dev/null @@ -1,27 +0,0 @@ -addworksheet(); - -$worksheet->set_column(0, 50, 18); - -for ($col=0;$col<50;$col++) { - for ($row=0;$row<6000;$row++) { - $worksheet->write($row, $col, "ROW:$row COL:$col"); - } -} - -$workbook->close(); - -header("Content-Type: application/x-msexcel"); -$fh=fopen($fname, "rb"); -fpassthru($fh); -unlink($fname); - -?> diff --git a/include/php_writeexcel/example-demo.php b/include/php_writeexcel/example-demo.php deleted file mode 100644 index ba72ea86b..000000000 --- a/include/php_writeexcel/example-demo.php +++ /dev/null @@ -1,102 +0,0 @@ -addworksheet('Demo'); -$worksheet2 =& $workbook->addworksheet('Another sheet'); -$worksheet3 =& $workbook->addworksheet('And another'); - -####################################################################### -# -# Write a general heading -# -$worksheet->set_column('A:B', 32); -$heading =& $workbook->addformat(array( - bold => 1, - color => 'blue', - size => 18, - merge => 1, - )); - -$headings = array('Features of php_writeexcel', ''); -$worksheet->write_row('A1', $headings, $heading); - -####################################################################### -# -# Some text examples -# -$text_format =& $workbook->addformat(array( - bold => 1, - italic => 1, - color => 'red', - size => 18, - font => 'Comic Sans MS' - )); - -$worksheet->write('A2', "Text"); -$worksheet->write('B2', "Hello Excel"); -$worksheet->write('A3', "Formatted text"); -$worksheet->write('B3', "Hello Excel", $text_format); - -####################################################################### -# -# Some numeric examples -# -$num1_format =& $workbook->addformat(array(num_format => '$#,##0.00')); -$num2_format =& $workbook->addformat(array(num_format => ' d mmmm yyy')); - -$worksheet->write('A4', "Numbers"); -$worksheet->write('B4', 1234.56); -$worksheet->write('A5', "Formatted numbers"); -$worksheet->write('B5', 1234.56, $num1_format); -$worksheet->write('A6', "Formatted numbers"); -$worksheet->write('B6', 37257, $num2_format); - -####################################################################### -# -# Formulae -# -/* -$worksheet->set_selection('B7'); -$worksheet->write('A7', 'Formulas and functions, "=SIN(PI()/4)"'); -$worksheet->write('B7', '=SIN(PI()/4)'); -*/ - -####################################################################### -# -# Hyperlinks -# -$worksheet->write('A8', "Hyperlinks"); -$worksheet->write('B8', 'http://www.php.net/'); - -####################################################################### -# -# Images -# -$worksheet->write('A9', "Images"); -$worksheet->insert_bitmap('B9', 'php.bmp', 16, 8); - -####################################################################### -# -# Misc -# -$worksheet->write('A17', "Page/printer setup"); -$worksheet->write('A18', "Multiple worksheets"); - -$workbook->close(); - - -// We'll be outputting a PDF -header('Content-type: application/x-msexcel'); - -// It will be called downloaded.pdf -header('Content-Disposition: attachment; filename="demo.xls"'); - -// The PDF source is in original.pdf -readfile($fname); -?> diff --git a/include/php_writeexcel/example-merge2.php b/include/php_writeexcel/example-merge2.php deleted file mode 100644 index 5287f91c3..000000000 --- a/include/php_writeexcel/example-merge2.php +++ /dev/null @@ -1,59 +0,0 @@ -addworksheet(); - -# Set the column width for columns 2 and 3 -$worksheet->set_column(1, 2, 20); - -# Set the row height for row 2 -$worksheet->set_row(2, 30); - -# Create a border format -$border1 =& $workbook->addformat(); -$border1->set_color('white'); -$border1->set_bold(); -$border1->set_size(15); -$border1->set_pattern(0x1); -$border1->set_fg_color('green'); -$border1->set_border_color('yellow'); -$border1->set_top(6); -$border1->set_bottom(6); -$border1->set_left(6); -$border1->set_align('center'); -$border1->set_align('vcenter'); -$border1->set_merge(); # This is the key feature - -# Create another border format. Note you could use copy() here. -$border2 =& $workbook->addformat(); -$border2->set_color('white'); -$border2->set_bold(); -$border2->set_size(15); -$border2->set_pattern(0x1); -$border2->set_fg_color('green'); -$border2->set_border_color('yellow'); -$border2->set_top(6); -$border2->set_bottom(6); -$border2->set_right(6); -$border2->set_align('center'); -$border2->set_align('vcenter'); -$border2->set_merge(); # This is the key feature - -# Only one cell should contain text, the others should be blank. -$worksheet->write (2, 1, "Merged Cells", $border1); -$worksheet->write_blank(2, 2, $border2); - -$workbook->close(); - -header("Content-Type: application/x-msexcel"); -$fh=fopen($fname, "rb"); -fpassthru($fh); -unlink($fname); - -?> diff --git a/include/php_writeexcel/example-simple.php b/include/php_writeexcel/example-simple.php deleted file mode 100644 index cef35c755..000000000 --- a/include/php_writeexcel/example-simple.php +++ /dev/null @@ -1,39 +0,0 @@ -addworksheet(); - -# The general syntax is write($row, $column, $token). Note that row and -# column are zero indexed -# - -# Write some text -$worksheet->write(0, 0, "Hi Excel!"); - -# Write some numbers -$worksheet->write(2, 0, 3); # Writes 3 -$worksheet->write(3, 0, 3.00000); # Writes 3 -$worksheet->write(4, 0, 3.00001); # Writes 3.00001 -$worksheet->write(5, 0, 3.14159); # TeX revision no.? - -# Formulas are not yet supported -//$worksheet->write(7, 0, '=A3 + A6'); -//$worksheet->write(8, 0, '=IF(A5>3,"Yes", "No")'); - -# Write a hyperlink -$worksheet->write(7, 0, 'http://www.php.net/'); - -$workbook->close(); - -header("Content-Type: application/x-msexcel"); -$fh=fopen($fname, "rb"); -fpassthru($fh); -unlink($fname); - -?> diff --git a/include/php_writeexcel/example-stocks.php b/include/php_writeexcel/example-stocks.php deleted file mode 100644 index 2b7ff7601..000000000 --- a/include/php_writeexcel/example-stocks.php +++ /dev/null @@ -1,70 +0,0 @@ -addworksheet(); - -# Set the column width for columns 1, 2, 3 and 4 -$worksheet->set_column(0, 3, 15); - -# Create a format for the column headings -$header =& $workbook->addformat(); -$header->set_bold(); -$header->set_size(12); -$header->set_color('blue'); - -# Create a format for the stock price -$f_price =& $workbook->addformat(); -$f_price->set_align('left'); -$f_price->set_num_format('$0.00'); - -# Create a format for the stock volume -$f_volume =& $workbook->addformat(); -$f_volume->set_align('left'); -$f_volume->set_num_format('#,##0'); - -# Create a format for the price change. This is an example of a conditional -# format. The number is formatted as a percentage. If it is positive it is -# formatted in green, if it is negative it is formatted in red and if it is -# zero it is formatted as the default font colour (in this case black). -# Note: the [Green] format produces an unappealing lime green. Try -# [Color 10] instead for a dark green. -# -$f_change =& $workbook->addformat(); -$f_change->set_align('left'); -$f_change->set_num_format('[Green]0.0%;[Red]-0.0%;0.0%'); - -# Write out the data -$worksheet->write(0, 0, 'Company', $header); -$worksheet->write(0, 1, 'Price', $header); -$worksheet->write(0, 2, 'Volume', $header); -$worksheet->write(0, 3, 'Change', $header); - -$worksheet->write(1, 0, 'Damage Inc.' ); -$worksheet->write(1, 1, 30.25, $f_price); # $30.25 -$worksheet->write(1, 2, 1234567, $f_volume); # 1,234,567 -$worksheet->write(1, 3, 0.085, $f_change); # 8.5% in green - -$worksheet->write(2, 0, 'Dump Corp.' ); -$worksheet->write(2, 1, 1.56, $f_price); # $1.56 -$worksheet->write(2, 2, 7564, $f_volume); # 7,564 -$worksheet->write(2, 3, -0.015, $f_change); # -1.5% in red - -$worksheet->write(3, 0, 'Rev Ltd.' ); -$worksheet->write(3, 1, 0.13, $f_price); # $0.13 -$worksheet->write(3, 2, 321, $f_volume); # 321 -$worksheet->write(3, 3, 0, $f_change); # 0 in the font color (black) - -$workbook->close(); - -header("Content-Type: application/x-msexcel"); -$fh=fopen($fname, "rb"); -fpassthru($fh); -unlink($fname); - -?> diff --git a/include/php_writeexcel/example-textwrap.php b/include/php_writeexcel/example-textwrap.php deleted file mode 100644 index 7d54012b3..000000000 --- a/include/php_writeexcel/example-textwrap.php +++ /dev/null @@ -1,71 +0,0 @@ -addworksheet(); - -# Set the column width for columns 1, 2 and 3 -$worksheet->set_column(1, 1, 24); -$worksheet->set_column(2, 2, 34); -$worksheet->set_column(3, 3, 34); - -# Set the row height for rows 1, 4, and 6. The heigt of row 2 will adjust -# automatically to fit the text. -# -$worksheet->set_row(0, 30); -$worksheet->set_row(3, 40); -$worksheet->set_row(5, 80); - -# No newlines -$str1 = "For whatever we lose (like a you or a me) "; -$str1 .= "it's always ourselves we find in the sea"; - -# Embedded newlines -$str2 = "For whatever we lose\n(like a you or a me)\n"; -$str2 .= "it's always ourselves\nwe find in the sea"; - - -# Create a format for the column headings -$header =& $workbook->addformat(); -$header->set_bold(); -$header->set_font("Courier New"); -$header->set_align('center'); -$header->set_align('vcenter'); - -# Create a "vertical justification" format -$format1 =& $workbook->addformat(); -$format1->set_align('vjustify'); - -# Create a "text wrap" format -$format2 =& $workbook->addformat(); -$format2->set_text_wrap(); - -# Write the headers -$worksheet->write(0, 1, "set_align('vjustify')", $header); -$worksheet->write(0, 2, "set_align('vjustify')", $header); -$worksheet->write(0, 3, "set_text_wrap()", $header); - -# Write some examples -$worksheet->write(1, 1, $str1, $format1); -$worksheet->write(1, 2, $str1, $format1); -$worksheet->write(1, 3, $str2, $format2); - -$worksheet->write(3, 1, $str1, $format1); -$worksheet->write(3, 2, $str1, $format1); -$worksheet->write(3, 3, $str2, $format2); - -$worksheet->write(5, 1, $str1, $format1); -$worksheet->write(5, 2, $str1, $format1); -$worksheet->write(5, 3, $str2, $format2); - -$workbook->close(); - -header("Content-Type: application/x-msexcel"); -$fh=fopen($fname, "rb"); -fpassthru($fh); -unlink($fname); - -?> -- 2.30.2