apache-poi-logo The Apache POI Project's mission is to create and maintain Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, you can read and write MS Excel files using Java. In addition, you can read and write MS Word and MS PowerPoint files using Java. Apache POI is your Java Excel solution (for Excel 97-2008). We have a complete API for porting other OOXML and OLE2 formats and welcome others to participate.

My Contributions to the Open Source project Apache POI: adding missing Excel functions in Java

Bug 54673 - [PATCH] Simple wildcard support in HLOOKUP, VOOLKUP, MATCH, COUNTIF
Add support for wildcards
? (question mark) Any single character
&160;&160;&160; For example, sm?th finds "smith" and "smyth"
* (asterisk) Any number of characters
&160;&160;&160; For example, *east finds "Northeast" and "Southeast"
~ (tilde) followed by ?, *, or ~A question mark, asterisk, or tilde
&160;&160;&160; For example, fy91~? finds "fy91?"

Bug 54723 - [PATCH] Support for percentage in VALUE() function
support for VALUE("30%") or VALUE("30 %") as excel support this

Bug 54720 - [PATCH] Support for Row/Col Area Range like 8:8 or H:H
Range support in the form of NameType.ROW:NameType.ROW&160;&160;&160; like 8:8 or 6:8

Bug 55037 - [PATCH] patch for missing function DELTA
Add support for function Delta
http://office.microsoft.com/en-001/excel-help/delta-HP005209057.aspx

Bug 55036 - [PATCH] patch for missing function Dec2HEx
Converts a decimal number to hexadecimal.
http://office.microsoft.com/en-001/excel-help/dec2hex-HP005209054.aspx

Bug 55038 - [PATCH] patch for missing function Dec2Oct
Converts a decimal number to octal.
http://office.microsoft.com/en-001/excel-help/dec2oct-HP005209055.aspx

Bug 55041 - [PATCH] patch for missing function CODE
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
http://office.microsoft.com/en-001/mac-excel-help/code-function-HA102927539.aspx

Bug 55042 - [PATCH] patch for missing function COMPLEX
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
http://office.microsoft.com/en-001/excel-help/complex-HP005209019.aspx

Bug 55043 - [PATCH] patch for missing function QUOTIENT
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.
http://office.microsoft.com/en-001/excel-help/quotient-HP005209227.aspx

Bug 55047 - [PATCH] patch for missing function REPT
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
http://office.microsoft.com/en-001/mac-excel-help/rept-function-HA102927993.aspx

Bug 55055 - [PATCH] patch for missing function Bin2Dec
Converts a binary number to decimal.
Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
http://office.microsoft.com/en-001/excel-help/bin2dec-HP005209002.aspx

Bug 55057 - [PATCH] patch for missing function Hex2Dec
Converts a hexadecimal number to decimal.
Number cannot contain more than 10 characters (40 bits). The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
http://office.microsoft.com/en-001/excel-help/hex2dec-HP005209111.aspx

Bug 55058 - [PATCH] patch for missing function FactDouble
Returns the double factorial of a number.
http://office.microsoft.com/en-001/excel-help/factdouble-HP005209085.aspx

Bug 55079 - [PATCH] patch for missing function IMAGINARY
Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
http://office.microsoft.com/en-001/excel-help/imaginary-HP005209120.aspx

Bug 55080 - [PATCH] patch for missing function IMREAL
Returns the real coefficient of a complex number in x + yi or x + yj text format.
http://office.microsoft.com/en-001/excel-help/imreal-HP005209131.aspx

Bug 55081 - [PATCH] patch for missing function WEEKNUM
Returns a number that indicates where the week falls numerically within a year.
http://office.microsoft.com/en-001/excel-help/weeknum-HP005209337.aspx

Bug 55082 - [PATCH] patch for missing function ROMAN
Converts an arabic numeral to roman, as text.
http://office.microsoft.com/en-001/excel-help/roman-HP005209238.aspx

More to come soon!

comments powered by Disqus

You might like also

Clue a command line tool for Apache Lucene search software
Lucene Core&160; is an open-source search software, provides Java-based indexing and search technology, as well as spellchecking, hit highlighting and advanced analysis/tokenization capabilities. Luke is a handy development and diagnostic tool, which accesses already existing Lucene indexes and allows you to display and modify their content. Luke is awesome, but often times it is not feasible to inspect an index on a remote machine using a GUI. That's where Clue comes in. You can SSH into your production box and …
1358 Days ago
Need for Speed? mod_pagespeed from Google
mod_pagespeed is the latest addition to our family of products, performing on-the-fly optimization in the Apache™ 2 HTTP Server. It provides webmasters and web developers that manage their Apache 2 configuration with technology that applies Page Speed performance best practices automatically. Webmasters can get the benefits of the optimizations without having to manually going back and fixing the performance issues that Page Speed detects. This solution is valid if you do not want to carefully optimize your site, and it …
2545 Days ago
Subversion and mod Security
I was receiving some strange errors (HTTP error 501) while committing to my public subversion (http://svn.waltercedric.com), all my problems were related to mod security This error 501 means most of the time that the client changed authentication halfway through the commit. That is, it started the commit by sending http requests with a Basic auth header of user1, and then a few requests later it sent a Basic auth header with a different user. Yes but.. …
3084 Days ago
Installing Munin on OpenSuse 11.x
&160; Munin the monitoring tool surveys all your computers and remembers what it saw. It presents all the information in graphs through a web interface. Its emphasis is on plug and play capabilities. After completing a installation a high number of monitoring plugins will be playing with no more effort. Using Munin you can easily monitor the performance of your computers, networks, SANs, applications, weather measurements and whatever comes to mind. It makes it easy to determine "what's different today" …
3112 Days ago
No Thumbnail was found
From http://www.mysqlperformanceblog.com Percona XtraDB includes all of InnoDB&8217;s ACID-compliant design and advanced MVCC architecture, and adds features, more tunability, more metrics, more scalability on many cores, and better memory usage. We choose features and fixes based on customer requests and on our best judgment of real-world needs. We have not included all the InnoDB patches available. For example Google&8217;s well-known InnoDB patch set is omitted (at least for now). The first version of our new storage engine is 1.0.2-1, which …
3168 Days ago
Site optimization: it's all about your image size and format
I really like this small Firefox extension Smushit as it allow to quickly check if all my images are optimized for the best size and thus speed of rendering. But wait IE/Opera/Chrome can still use this bookmarlet :-) to optimize the images found on any web page! From http://www.smushit.com/ Image optimization is an art that not many people master. There are many good image editing tools that allow us to get the best visual result for a certain file size …
3195 Days ago
No Thumbnail was found
From WikiPedia Inline linking (also known as hotlinking, leeching, piggy-backing, direct linking, offsite image grabs and bandwidth theft) is the use of a linked object, often an image, from one site into a web page belonging to a second site. The second site is said to have an inline link to the site where the object is located. This is not just Bandwidth Stealing, as It cost CPU and bandwidth which means less performance for your visitors, It cost a …
3217 Days ago
How to install mod_security 2.5.7
ModSecurityTM is an open source intrusion detection and prevention engine for web applications (or a web application firewall). Operating as an Apache Web server module or standalone, the purpose of ModSecurity is to increase web application security, protecting web applications from known and unknown attacks. from http://www.modsecurity.org/ You'll have to create a free account at https://bsn.breach.com to get the real link # cd # wget https://bsn.breach.com/downloads/t=5156aa8803d6f186cf38688be522a402/modsecurity-apache/modsecurity-apache_2.5.7.tar.gz # tar -zxfv modsecurity-apache_2.5.7.tar.gz # cd modsecurity-apache_2.5.7/apache2 # ./configure # make Copy the library …
3220 Days ago
No Thumbnail was found
A lot of people have tried numerous times to download files from my download section without success, the error message was always the same Unrecoverable error "PCLZIP_ERR_BAD_FORMAT (-10)" Also, Some tried to unpack the zip file locally using stuffit/Winrar/7Zip and get an error suggesting that the archive is damaged. Only Internet Explorer users were having issues, this is because of Internet explorer not able to handle compression of all file types. I solved the issue by changing my mod_deflate.conf which …
3354 Days ago
Benchmarking your LAMP server
The acronym LAMP refers to a solution stack of software, usually free and open source software, used to run dynamic Web sites or servers. It stand for: Linux, for the operating system; Apache, the Web server; MySQL, the database management system (or database server); Perl, Python, and PHP, the programming languages. &160;ab is a tool for benchmarking your Apache Hypertext Transfer Protocol (HTTP) server. It is designed to give you an impression of how your current Apache installation performs. This …
3492 Days ago