[GitHub] [poi] sfisque opened a new pull request, #330: Patch averageif

2022-04-28 Thread GitBox


sfisque opened a new pull request, #330:
URL: https://github.com/apache/poi/pull/330

   adds missing support for singular AverageIf function


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



Re: want to provide patch

2022-04-28 Thread stanton fisque
so i've cloned the repo, created a branch locally to make changes, added the 
code and a corresponding unit test.  but when i try to push back, i get 
permission failure.  it appears i cannot create a new branch, so that begs the 
question, how does one submit a PR if they cannot create a feature branch for 
the PR source.


Stanton Fisque
principal technologist
latticeware.com
portland, oregon

> On Apr 28, 2022, at 09:00 AM, Nick Burch  wrote:
> 
> On Thu, 28 Apr 2022, stanton fisque wrote:
>> i'd like to provide a patch for some missing functionality, specifically the 
>> support handler for AverageIf (the generalized version is present but not 
>> the singular version).  what is the best way to provide that? is there a 
>> repo where a pull request can be provided?
> 
> Great! You'll want:
> * https://poi.apache.org/devel/guidelines.html
> * https://github.com/apache/poi
> 
> For formula functions, see also
> * https://poi.apache.org/components/spreadsheet/eval.html
> * 
> http://home.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx
> 
> Nick
> 
> -
> To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
> For additional commands, e-mail: dev-h...@poi.apache.org
> 


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



Re: want to provide patch

2022-04-28 Thread Nick Burch

On Thu, 28 Apr 2022, stanton fisque wrote:
i'd like to provide a patch for some missing functionality, specifically 
the support handler for AverageIf (the generalized version is present 
but not the singular version).  what is the best way to provide that? 
is there a repo where a pull request can be provided?


Great! You'll want:
 * https://poi.apache.org/devel/guidelines.html
 * https://github.com/apache/poi

For formula functions, see also
 * https://poi.apache.org/components/spreadsheet/eval.html
 * 
http://home.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx

Nick

-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



want to provide patch

2022-04-28 Thread stanton fisque
i'd like to provide a patch for some missing functionality, specifically the 
support handler for AverageIf (the generalized version is present but not the 
singular version).  what is the best way to provide that?  is there a repo 
where a pull request can be provided?


Stanton Fisque
principal technologist
latticeware.com
portland, oregon


-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66029] poi 5.0 generated xlsx file RUN TO EMAIL APPENDS .TXT TO OUTPUT

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66029

--- Comment #12 from Axel Howind  ---
As I understand this, the problem is that the files generated with POI 5 are
displayed as "Binary" instead of "Excel Spreadsheet" in your inhouse
application. Since Excel does not expose this problem (I can open both without
any error using MS Excel, this is rather a problem with your application code.

You should check how your application determines the file format. It should be
updated accordingly. Both attached files start with the required PK-zip header
(504B0304). Whatever your application does to determine the file type from
there on is unknown to us POI developers if you cannot share the code. If you
use a library for file type detection, open an issue with that library
maintainers.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66039] Versions greater than 5.1 damages structured references while setCellFormula

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66039

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |regression

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 65969] support bookmarks in XWPFParagraph

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=65969

Dominik Stadler  changed:

   What|Removed |Added

   Severity|normal  |enhancement

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66020] Log4j error message while creating HSSFWorkbook object

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66020

Dominik Stadler  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |INVALID

--- Comment #2 from Dominik Stadler  ---
Likely caused by an invalid classpath, thus closing this for now, please reopen
with more information if you still think there is a problem in Apache POI here.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66029] poi 5.0 generated xlsx file RUN TO EMAIL APPENDS .TXT TO OUTPUT

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66029

Dominik Stadler  changed:

   What|Removed |Added

   Severity|blocker |regression
   Priority|P1  |P2

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66040] XSLFTextParagraph uses the wrong text body when text shapes are copied from other slides

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66040

Dominik Stadler  changed:

   What|Removed |Added

 OS||All

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66039] Versions greater than 5.1 damages structured references while setCellFormula

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66039

Dominik Stadler  changed:

   What|Removed |Added

 OS||All

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org



[Bug 66040] New: XSLFTextParagraph uses the wrong text body when text shapes are copied from other slides

2022-04-28 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66040

Bug ID: 66040
   Summary: XSLFTextParagraph uses the wrong text body when text
shapes are copied from other slides
   Product: POI
   Version: 5.2.0-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSLF
  Assignee: dev@poi.apache.org
  Reporter: axel.richter.pri...@web.de
  Target Milestone: ---

Since apache poi 4 the apache developers decided using
org.apache.poi.xddf.usermodel.text.* for text paragraphs and text runs also in
XSLF. Up to apache poi 3.17 XSLF had have it's own classes for text paragraphs
and text runs. Those are further present (maybe for backwards compatibility)
but in versions greater than apache po 3.17 they are using the wrong text body
when text shapes are copied from other slides. 

See
https://stackoverflow.com/questions/72017058/apache-poi-changes-applied-to-the-wrong-slide
for a complete example.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org