Built-in function code

2015-12-04 Thread Javen O'Neal
In FunctionEval.java [1], there's an array that maps the binary function code used in BIFF8 to a function instance. I'm implementing Days [2] for bug 58468 [3], and I have no idea what the code is. Is there an easy way to figure out the code? Thanks! [1]

[Bug 58468] Not implemented function 'DAYS'

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58468 --- Comment #1 from Javen O'Neal --- Created attachment 33323 --> https://bz.apache.org/bugzilla/attachment.cgi?id=33323=edit Days function implementation Official documentation:

Re: Built-in function code

2015-12-04 Thread Javen O'Neal
>From what I can tell, DAYS wasn't added until Excel 2013 [1]. Clearly this means DAYS is not a recognized function in BIFF8. I developed a solution [2] for saving unregistered functions in bug 58452, but this gets tricky with common SS support regarding parsing, storing, and evaluating and to

Re: Ready for 3.14-Beta1?

2015-12-04 Thread Nick Burch
On Thu, 3 Dec 2015, Javen O'Neal wrote: Does releasing require having a community-trusted PGP key? I haven't outside the Apache web-of-trust (for now). Ideally a key in the Apache WoT, but one well into an alternate WoT (eg Debian) could work. If you let me know off-list where in the World

Re: Built-in function code

2015-12-04 Thread Nick Burch
On Fri, 4 Dec 2015, Javen O'Neal wrote: In FunctionEval.java [1], there's an array that maps the binary function code used in BIFF8 to a function instance. There's also src/resources/main/org/apache/poi/ss/formula/function/functionMetadata.txt I'm implementing Days [2] for bug 58468 [3],

Re: Built-in function code

2015-12-04 Thread Javen O'Neal
I got close to finding my answer in section 3.11.1 (starts on Page 74) of https://www.openoffice.org/sc/excelfileformat.pdf, but DAYS isn't included. Helpful resource if others are curious. On Fri, Dec 4, 2015 at 12:40 AM, Javen O'Neal wrote: > In FunctionEval.java [1],

Re: Ready for 3.14-Beta1?

2015-12-04 Thread David North
On 04/12/15 11:55, Nick Burch wrote: > On Thu, 3 Dec 2015, Javen O'Neal wrote: >> Does releasing require having a community-trusted PGP key? I haven't >> outside the Apache web-of-trust (for now). > > Ideally a key in the Apache WoT, but one well into an alternate WoT > (eg Debian) could work. If

[Bug 58106] unreadable content after remove formula

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58106 --- Comment #3 from Nick Burch --- I wonder if the "shift rows" formula changing logic could be re-used for this? -- You are receiving this mail because: You are the assignee for the bug.

[Bug 58418] Applying Auto Filter on SXSSFSheet leads to corrupt excel

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58418 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO

[Bug 58106] unreadable content after remove formula

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58106 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO

PGP - change of key for David North

2015-12-04 Thread David North
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hi everyone, This is just a quick note to mention that I am phasing out my PGP key B4812553 and will revoke it in January 2016. The reason for this is that the private key was on a laptop of mine which was stolen recently. Although the laptop was

[Bug 58607] DateTime formatting

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58607 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO

PGP change for David North (take 2)

2015-12-04 Thread David North
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 [re-sending as my mail client screwed up the signature on the last copy] Hi everyone, This is just a quick note to mention that I am phasing out my PGP key B4812553 and will revoke it in January 2016. The reason for this is that the private key

Re: Built-in function code

2015-12-04 Thread Nick Burch
On Fri, 4 Dec 2015, Javen O'Neal wrote: From what I can tell, DAYS wasn't added until Excel 2013 [1]. Clearly this means DAYS is not a recognized function in BIFF8. I developed a solution [2] for saving unregistered functions in bug 58452, but this gets tricky with common SS support regarding

[Bug 58084] Corrupted styles.xml for file created with XSSFWorkbook

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58084 Dominik Stadler changed: What|Removed |Added CC|

[Bug 58084] Corrupted styles.xml for file created with XSSFWorkbook

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58084 Bug 58084 depends on bug 55800, which changed state. Bug 55800 Summary: cloneStyleFrom(CellStyle cellStyle) creates error "Unreadable content". https://bz.apache.org/bugzilla/show_bug.cgi?id=55800 What|Removed

[Bug 55800] cloneStyleFrom(CellStyle cellStyle) creates error "Unreadable content".

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=55800 Dominik Stadler changed: What|Removed |Added Resolution|--- |DUPLICATE

[Bug 58084] Corrupted styles.xml for file created with XSSFWorkbook

2015-12-04 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=58084 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED

Build failed in Jenkins: POI-JDK8 #736

2015-12-04 Thread Apache Jenkins Server
See Changes: [centic] Bug 58084: Fix cloning Cell Styles with Borders [centic] Eclipse warnings, code formatting, javadoc, ... -- Started by an SCM change [EnvInject] - Loading node environment

Jenkins build is back to normal : POI-JDK8 #737

2015-12-04 Thread Apache Jenkins Server
See - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org