[Bug 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #9 from J English  ---
Your recommended solution worked! Thanks again for all your help guys

-- 
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

Build failed in Jenkins: POI » POI-DSL-1.8 #1072

2024-05-08 Thread Apache Jenkins Server 
See 

Changes:


--
[...truncated 24.60 KB...]
at hudson.FilePath$FileCallableWrapper.call(FilePath.java:3616)
at hudson.remoting.UserRequest.perform(UserRequest.java:211)
at hudson.remoting.UserRequest.perform(UserRequest.java:54)
at hudson.remoting.Request$2.run(Request.java:377)
at 
hudson.remoting.InterceptingExecutorService.lambda$wrap$0(InterceptingExecutorService.java:78)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.tmatesoft.sqljet.core.SqlJetException: BUSY: error code is BUSY
at 
org.tmatesoft.sqljet.core.internal.pager.SqlJetPager.begin(SqlJetPager.java:2778)
at 
org.tmatesoft.sqljet.core.internal.btree.SqlJetBtree.beginTrans(SqlJetBtree.java:931)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.doBeginTransaction(SqlJetEngine.java:561)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.access$100(SqlJetEngine.java:55)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine$12.runSynchronized(SqlJetEngine.java:535)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.runSynchronized(SqlJetEngine.java:217)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.runEngineTransaction(SqlJetEngine.java:529)
at 
org.tmatesoft.sqljet.core.table.SqlJetDb.runTransaction(SqlJetDb.java:252)
at 
org.tmatesoft.sqljet.core.table.SqlJetDb.runWriteTransaction(SqlJetDb.java:225)
at 
org.tmatesoft.svn.core.internal.wc17.db.statement.SVNWCDbCreateSchema.exec(SVNWCDbCreateSchema.java:225)
... 29 more
org.tmatesoft.sqljet.core.SqlJetException: BUSY: error code is BUSY
at 
org.tmatesoft.sqljet.core.internal.pager.SqlJetPager.begin(SqlJetPager.java:2778)
at 
org.tmatesoft.sqljet.core.internal.btree.SqlJetBtree.beginTrans(SqlJetBtree.java:931)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.doBeginTransaction(SqlJetEngine.java:561)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.access$100(SqlJetEngine.java:55)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine$12.runSynchronized(SqlJetEngine.java:535)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.runSynchronized(SqlJetEngine.java:217)
at 
org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.runEngineTransaction(SqlJetEngine.java:529)
at 
org.tmatesoft.sqljet.core.table.SqlJetDb.runTransaction(SqlJetDb.java:252)
at 
org.tmatesoft.sqljet.core.table.SqlJetDb.runWriteTransaction(SqlJetDb.java:225)
at 
org.tmatesoft.svn.core.internal.wc17.db.statement.SVNWCDbCreateSchema.exec(SVNWCDbCreateSchema.java:225)
Caused: org.tmatesoft.svn.core.SVNException: svn: E200030: BUSY
at 
org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorManager.java:70)
at 
org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorManager.java:57)
at 
org.tmatesoft.svn.core.internal.db.SVNSqlJetDb.createSqlJetError(SVNSqlJetDb.java:195)
at 
org.tmatesoft.svn.core.internal.wc17.db.statement.SVNWCDbCreateSchema.exec(SVNWCDbCreateSchema.java:303)
at 
org.tmatesoft.svn.core.internal.wc17.db.SVNWCDb.createDb(SVNWCDb.java:292)
at 
org.tmatesoft.svn.core.internal.wc17.db.SVNWCDb.init(SVNWCDb.java:239)
at 
org.tmatesoft.svn.core.internal.wc17.SVNWCContext.initWC(SVNWCContext.java:5017)
at 
org.tmatesoft.svn.core.internal.wc17.SVNWCContext.initializeWC(SVNWCContext.java:4966)
at 
org.tmatesoft.svn.core.internal.wc2.ng.SvnNgAbstractUpdate.checkout(SvnNgAbstractUpdate.java:871)
at 
org.tmatesoft.svn.core.internal.wc2.ng.SvnNgCheckout.run(SvnNgCheckout.java:26)
at 
org.tmatesoft.svn.core.internal.wc2.ng.SvnNgCheckout.run(SvnNgCheckout.java:11)
at 
org.tmatesoft.svn.core.internal.wc2.ng.SvnNgOperationRunner.run(SvnNgOperationRunner.java:20)
at 
org.tmatesoft.svn.core.internal.wc2.SvnOperationRunner.run(SvnOperationRunner.java:21)
at 
org.tmatesoft.svn.core.wc2.SvnOperationFactory.run(SvnOperationFactory.java:1239)
at org.tmatesoft.svn.core.wc2.SvnOperation.run(SvnOperation.java:294)
at 
hudson.scm.subversion.CheckoutUpdater$SubversionUpdateTask.perform(CheckoutUpdater.java:139)
Also:   hudson.remoting.Channel$CallSiteStackTrace: Remote call to builds59
at 
hudson.remoting.Channel.attachCallSiteStackTrace(Channel.java:1787)
at 
hudson.remoting.UserRequest$ExceptionResponse.retrieve(UserRequest.java:356)
at hudson.remoting.Channel.call(Channel.java:1003)

[Bug 68987] support allowStoredEntriesWithDataDescriptor=true when reading zip data

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68987

--- Comment #1 from PJ Fanning  ---
I added r1917587

-- 
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 68987] New: support allowStoredEntriesWithDataDescriptor=true when reading zip data

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68987

Bug ID: 68987
   Summary: support allowStoredEntriesWithDataDescriptor=true when
reading zip data
   Product: POI
   Version: 5.2.3-FINAL
  Hardware: All
OS: All
Status: NEW
  Severity: normal
  Priority: P2
 Component: OPC
  Assignee: dev@poi.apache.org
  Reporter: fannin...@yahoo.com
  Target Milestone: ---

See
https://stackoverflow.com/questions/78441630/apache-poi-read-word-then-throw-unsupportedzipfeatureexception-unsupported-featu

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #8 from J English  ---
Yes, the reason is that we import data from a csv file, which stores the data
as comma-delimited String values; thus, when we import the data, all values are
imported as a Strings and I use POI to populate the cells in the order
specified in the csv file. Also, depending my clients, I can have different
variations of excel files, some with multiple numeric columns, which introduces
a layer of unpredictability.

However, I do understand what you mean. In order for a value to be recognized
as a numeric value, I need to parse the value as an integer value before
setting that value for the cell. That makes sense to me. I will give that a
try. Thank you so much for your help. I really appreciate it.

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #7 from sfis...@gmail.com ---
honestly, the real solution is coerce the values going into the cells to
double, that way the underlying framework does not change the cell type to
string.

from reading the javadoc of the various setCellValue( x ) methods, this seems
fairly apparent

is there a reason you are trying to push strings into cells that are being
typed numeric?  

is there a reason you are not parsing/converting/coercing them to numeric
doubles before insertion?

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #6 from J English  ---
PJ, my bad I forgot to answer your original question. Yes, I did try
re-ordering the code by setting the cell type after the cell value, but it
displayed the following data in the excel file, which seemed pretty odd.

0
1
2
3
4

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

PJ Fanning  changed:

   What|Removed |Added

 Resolution|--- |INFORMATIONPROVIDED
 Status|NEEDINFO|RESOLVED

--- Comment #5 from PJ Fanning  ---
I think you are best off talking to Microsoft. I will close this. There is
nothing in the file generated from POI that prevents you from changing the cell
type in Microsoft Excel.

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #4 from J English  ---
Thank you both for your inputs.

Yes, there are no formulas included the code because I have a customer that
wants to add their own custom formulas to the spreadsheet after the file has
generated.

Also, the is a very slimmed down version of my original code. We normally
import data from a csv file, which stores the data as comma-delimited String
values; thus, when we import the data, all values are imported as a String.

One thing, you might also notice though, and maybe this might be a question for
Microsoft, if you attempt to change the cell type for one of the modified
cells, the change never take effect. I wasn't sure if there was anything in POI
that might be locking the cell type because I am able to update to cell style.
For example, try manually changing the cell type to something random like
'Percentage' and you'll see what I'm referring to. 

Can you please advise if you think the cell type issue might be a POI thing? I
think that if the cell type can be updated, it should resolve the issue with
the manually added formulas.

Thank you

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #3 from PJ Fanning  ---
*** Bug 68974 has been marked as a duplicate of this bug. ***

-- 
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 68974] Unable to edit cell type on excel file that was generated via Apache Poi API

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68974

PJ Fanning  changed:

   What|Removed |Added

 Status|NEEDINFO|RESOLVED
 Resolution|--- |DUPLICATE

--- Comment #9 from PJ Fanning  ---


*** This bug has been marked as a duplicate of bug 68985 ***

-- 
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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

--- Comment #2 from Nick Burch  ---
I can't see any formula setting in your code

If you set a formula with POI and we don't evaluate it properly, that's our bug
(or possibly one of our limitations)

If you open a file in Excel, it looks fine, but then Excel doesn't do something
correctly when you make changes to it, that sounds a lot like an Excel bug.

Given that you don't pay us any money, and you presumably do pay Microsoft
quite a bit of money for Excel, I would suggest you report this apparent Excel
bug to the people you have a paid-for support contract with...

-- 
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

Re: [Bug 68985] New: Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread stanton fisque 
this does not appear to be a bug.  reading the javadoc for Cell.setCellValue( 
String )

value - value to set the cell to. For formulas, we'll set the formula string, 
for String cells we'll set its value. For other types, we will change the cell 
to a string cell and set its value. If value is null then we will change the 
cell to a Blank cell.
 <>Stanton Fisque
principal technologist
latticeware.com
portland, oregon

> On May 8, 2024, at 13:04 PM, bugzi...@apache.org wrote:
> 
> https://bz.apache.org/bugzilla/show_bug.cgi?id=68985
> 
>Bug ID: 68985
>   Summary: Unable to edit cell type on excel file that was
>generated via Apache Poi API (edit)
>   Product: POI
>   Version: unspecified
>  Hardware: PC
>Status: NEW
>  Severity: normal
>  Priority: P2
> Component: XSSF
>  Assignee: dev@poi.apache.org
>  Reporter: jengl...@xifin.com
>  Target Milestone: ---
> 
> To give a quick synopsis, I'm using Apache POI API to generate an excel file.
> After the file is generated, I am unable to apply formulas to the any of the
> modified rows. The reason appears to be related to the cell type of the cells,
> which cannot be updated after the file has generated. Even if I manually 
> change
> the cell type of the cells via the Excel spreadsheet, the changes do not take
> effect.
> 
> To reproduce, simply run the test below and open the generate excel file. If
> you manually add '=SUM(A1:A5)' to any cell to get the sum of the cells, you
> will notice that the formula is not calculating correctly.
> 
> Any help would be greatly appreciated.
> 
> Thank you
> 
> import org.apache.poi.ss.usermodel.CellType;
> import org.apache.poi.xssf.usermodel.XSSFCell;
> import org.apache.poi.xssf.usermodel.XSSFRow;
> import org.apache.poi.xssf.usermodel.XSSFSheet;
> import org.apache.poi.xssf.usermodel.XSSFWorkbook;
> 
> import java.io.FileOutputStream;
> 
> public class TestExcelWriter
> {
>public static void main(String[] args) throws Exception
>{
>XSSFWorkbook workbook = new XSSFWorkbook();
>workbook.setForceFormulaRecalculation(true);
>XSSFSheet sheet = workbook.createSheet();
> 
>int row = 0;
>String[] values = {"1.00", "2.00", "3.00", "4.00", "5.00",};
>for (String value : values)
>{
>XSSFRow newRow = sheet.createRow(row);
>XSSFCell newCell = newRow.createCell(0);
>newCell.setCellType(CellType.NUMERIC);
>newCell.setCellValue(value);
>row++;
>}
> 
>FileOutputStream out = new FileOutputStream("outputFile.xlsx");
>workbook.write(out);
>out.close();
>}
> }
> 
> -- 
> 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 68985] Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

PJ Fanning  changed:

   What|Removed |Added

 OS||All
 Status|NEW |NEEDINFO

--- Comment #1 from PJ Fanning  ---
newCell.setCellValue(value);

if value is a String - the cell type is set to string

this will override the setCellType call you made BEFORE the setCellValue

any chance that you could reorder the code to set the type AFTER you set the
value?

I would suggest that you try using a debugger on the code and you will see what
is happening.

-- 
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 68985] New: Unable to edit cell type on excel file that was generated via Apache Poi API (edit)

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68985

Bug ID: 68985
   Summary: Unable to edit cell type on excel file that was
generated via Apache Poi API (edit)
   Product: POI
   Version: unspecified
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSSF
  Assignee: dev@poi.apache.org
  Reporter: jengl...@xifin.com
  Target Milestone: ---

To give a quick synopsis, I'm using Apache POI API to generate an excel file.
After the file is generated, I am unable to apply formulas to the any of the
modified rows. The reason appears to be related to the cell type of the cells,
which cannot be updated after the file has generated. Even if I manually change
the cell type of the cells via the Excel spreadsheet, the changes do not take
effect.

To reproduce, simply run the test below and open the generate excel file. If
you manually add '=SUM(A1:A5)' to any cell to get the sum of the cells, you
will notice that the formula is not calculating correctly.

Any help would be greatly appreciated.

Thank you

import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;

public class TestExcelWriter
{
public static void main(String[] args) throws Exception
{
XSSFWorkbook workbook = new XSSFWorkbook();
workbook.setForceFormulaRecalculation(true);
XSSFSheet sheet = workbook.createSheet();

int row = 0;
String[] values = {"1.00", "2.00", "3.00", "4.00", "5.00",};
for (String value : values)
{
XSSFRow newRow = sheet.createRow(row);
XSSFCell newCell = newRow.createCell(0);
newCell.setCellType(CellType.NUMERIC);
newCell.setCellValue(value);
row++;
}

FileOutputStream out = new FileOutputStream("outputFile.xlsx");
workbook.write(out);
out.close();
}
}

-- 
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 68983] POI can't create poifiles sub dir if temp dir is a symlink

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68983

--- Comment #2 from PJ Fanning  ---
I added back one check that was removed in the previous patch to the
DefaultTempFileCreationStrategy.

r1917583

-- 
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 68983] POI can't create poifiles sub dir if temp dir is a symlink

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68983

Matafagafo  changed:

   What|Removed |Added

 CC||matafag...@yahoo.com

-- 
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

Re: [PR] Bump net.bytebuddy:byte-buddy-agent from 1.14.12 to 1.14.15 [poi]

2024-05-08 Thread via GitHub 


dependabot[bot] commented on PR #633:
URL: https://github.com/apache/poi/pull/633#issuecomment-2101059799

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
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: [PR] Bump net.bytebuddy:byte-buddy from 1.14.12 to 1.14.15 [poi]

2024-05-08 Thread via GitHub 


dependabot[bot] commented on PR #632:
URL: https://github.com/apache/poi/pull/632#issuecomment-2101059779

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
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: [PR] Bump net.bytebuddy:byte-buddy from 1.14.12 to 1.14.15 [poi]

2024-05-08 Thread via GitHub 


asfgit closed pull request #632: Bump net.bytebuddy:byte-buddy from 1.14.12 to 
1.14.15
URL: https://github.com/apache/poi/pull/632


-- 
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: [PR] Bump com.google.guava:guava from 32.1.1-jre to 33.2.0-jre [poi]

2024-05-08 Thread via GitHub 


dependabot[bot] commented on PR #630:
URL: https://github.com/apache/poi/pull/630#issuecomment-2101059754

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
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: [PR] Bump com.github.spotbugs from 5.2.1 to 6.0.14 [poi]

2024-05-08 Thread via GitHub 


dependabot[bot] commented on PR #631:
URL: https://github.com/apache/poi/pull/631#issuecomment-2101059750

   OK, I won't notify you again about this release, but will get in touch when 
a new version is available. If you'd rather skip all updates until the next 
major or minor version, let me know by commenting `@dependabot ignore this 
major version` or `@dependabot ignore this minor version`. You can also ignore 
all major, minor, or patch releases for a dependency by adding an [`ignore` 
condition](https://docs.github.com/en/code-security/supply-chain-security/configuration-options-for-dependency-updates#ignore)
 with the desired `update_types` to your config file.
   
   If you change your mind, just re-open this PR and I'll resolve any conflicts 
on it.


-- 
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: [PR] Bump net.bytebuddy:byte-buddy-agent from 1.14.12 to 1.14.15 [poi]

2024-05-08 Thread via GitHub 


asfgit closed pull request #633: Bump net.bytebuddy:byte-buddy-agent from 
1.14.12 to 1.14.15
URL: https://github.com/apache/poi/pull/633


-- 
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: [PR] Bump com.google.guava:guava from 32.1.1-jre to 33.2.0-jre [poi]

2024-05-08 Thread via GitHub 


asfgit closed pull request #630: Bump com.google.guava:guava from 32.1.1-jre to 
33.2.0-jre
URL: https://github.com/apache/poi/pull/630


-- 
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: [PR] Bump com.github.spotbugs from 5.2.1 to 6.0.14 [poi]

2024-05-08 Thread via GitHub 


asfgit closed pull request #631: Bump com.github.spotbugs from 5.2.1 to 6.0.14
URL: https://github.com/apache/poi/pull/631


-- 
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

[Bug 68983] POI can't create poifiles sub dir if temp dir is a symlink

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68983

--- Comment #1 from PJ Fanning  ---
You can register your own TempFileCreationStrategy.

https://github.com/apache/poi/blob/c960ee60709a4059796a13eec3b383ea4363f4fc/poi/src/main/java/org/apache/poi/util/TempFile.java#L44

I would be against reverting the changes to use the Java NIO codebase instead
of the insecure java.io.File code. I would even be against having the code fall
back to the insecure java.io.File code.

If someone can provide a solution that only uses secure code then that is ok.

Users can implement their own TempFileCreationStrategy and do whatever they
please.

ASF default code must be secure in all cases.

-- 
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

[PR] Bump net.bytebuddy:byte-buddy-agent from 1.14.12 to 1.14.15 [poi]

2024-05-08 Thread via GitHub 


dependabot[bot] opened a new pull request, #633:
URL: https://github.com/apache/poi/pull/633

   Bumps [net.bytebuddy:byte-buddy-agent](https://github.com/raphw/byte-buddy) 
from 1.14.12 to 1.14.15.
   
   Release notes
   Sourced from https://github.com/raphw/byte-buddy/releases;>net.bytebuddy:byte-buddy-agent's
 releases.
   
   Byte Buddy 1.14.14
   
   Adjust type validation to accept additional names that are legal in the 
class file format.
   Fix dynamic attach on Windows when a service user is active.
   Avoid failure when using Android's strict mode.
   
   Byte Buddy 1.14.13
   
   Avoid resolving type variables when generic type processing is 
disabled.
   Improve error message for Byte Buddy agent external attach.
   Fix build for modular jars when using later version than Java 8.
   
   
   
   
   Changelog
   Sourced from https://github.com/raphw/byte-buddy/blob/master/release-notes.md;>net.bytebuddy:byte-buddy-agent's
 changelog.
   
   Byte Buddy release notes
   23. April 2024: version 1.14.14
   
   Adjust type validation to accept additional names that are legal in the 
class file format.
   Fix dynamic attach on Windows when a service user is active.
   Avoid failure when using Android's strict mode.
   
   28. March 2024: version 1.14.13
   
   Avoid resolving type variables when generic type processing is 
disabled.
   Improve error message for Byte Buddy agent external attach.
   Fix build for modular jars when using later version than Java 8.
   
   
   
   
   Commits
   
   https://github.com/raphw/byte-buddy/commit/a24599ab06e5d869383c9bf3ed600b25e055e3b2;>a24599a
 [maven-release-plugin] prepare release byte-buddy-1.14.15
   https://github.com/raphw/byte-buddy/commit/0e0cbdf4dbfa60ec7972414a5be2bdd0e805021e;>0e0cbdf
 [release] Release new version
   https://github.com/raphw/byte-buddy/commit/5b5bcaf96013b27fc23b91fcb2bd57184d8d2d17;>5b5bcaf
 Minor code normalizations.
   https://github.com/raphw/byte-buddy/commit/189787960f8389e857c791a51af5e7f396e7e293;>1897879
 Add missing forwarding.
   https://github.com/raphw/byte-buddy/commit/156ba853296fa6bcb688cdcaf249ec080d3746b0;>156ba85
 J9 Allow attachment as root (https://redirect.github.com/raphw/byte-buddy/issues/1631;>#1631)
   https://github.com/raphw/byte-buddy/commit/01ed75b4b53bc43b54d8b7814c158cf310393c68;>01ed75b
 Switch from global property to explicit argument.
   https://github.com/raphw/byte-buddy/commit/f04d254b61e4f05fd647fbcbcb61de32fea1d652;>f04d254
 Add property to allow disabling user check for J9 which does not seem to be 
i...
   https://github.com/raphw/byte-buddy/commit/5b7c966d82ac8e47d486111b1ce16c358c1b402b;>5b7c966
 Update internal Byte Buddy.
   https://github.com/raphw/byte-buddy/commit/e258ec5be04f77060c1f99c6535ef30b6cad9a3b;>e258ec5
 Update checkout plugin.
   https://github.com/raphw/byte-buddy/commit/61209f4785428aee60c3ea6d425355d59db3bf13;>61209f4
 [maven-release-plugin] prepare for next development iteration
   Additional commits viewable in https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.12...byte-buddy-1.14.15;>compare
 view
   
   
   
   
   
   [![Dependabot compatibility 
score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=net.bytebuddy:byte-buddy-agent=gradle=1.14.12=1.14.15)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores)
   
   Dependabot will resolve any conflicts with this PR as long as you don't 
alter it yourself. You can also trigger a rebase manually by commenting 
`@dependabot rebase`.
   
   [//]: # (dependabot-automerge-start)
   [//]: # (dependabot-automerge-end)
   
   ---
   
   
   Dependabot commands and options
   
   
   You can trigger Dependabot actions by commenting on this PR:
   - `@dependabot rebase` will rebase this PR
   - `@dependabot recreate` will recreate this PR, overwriting any edits that 
have been made to it
   - `@dependabot merge` will merge this PR after your CI passes on it
   - `@dependabot squash and merge` will squash and merge this PR after your CI 
passes on it
   - `@dependabot cancel merge` will cancel a previously requested merge and 
block automerging
   - `@dependabot reopen` will reopen this PR if it is closed
   - `@dependabot close` will close this PR and stop Dependabot recreating it. 
You can achieve the same result by closing it manually
   - `@dependabot show  ignore conditions` will show all of 
the ignore conditions of the specified dependency
   - `@dependabot ignore this major version` will close this PR and stop 
Dependabot creating any more for this major version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this minor version` will close this PR and stop 
Dependabot creating any more for this minor version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this dependency` will close this PR and stop 
Dependabot creating any more for

[PR] Bump net.bytebuddy:byte-buddy from 1.14.12 to 1.14.15 [poi]

2024-05-08 Thread via GitHub 


dependabot[bot] opened a new pull request, #632:
URL: https://github.com/apache/poi/pull/632

   Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 
1.14.12 to 1.14.15.
   
   Release notes
   Sourced from https://github.com/raphw/byte-buddy/releases;>net.bytebuddy:byte-buddy's 
releases.
   
   Byte Buddy 1.14.14
   
   Adjust type validation to accept additional names that are legal in the 
class file format.
   Fix dynamic attach on Windows when a service user is active.
   Avoid failure when using Android's strict mode.
   
   Byte Buddy 1.14.13
   
   Avoid resolving type variables when generic type processing is 
disabled.
   Improve error message for Byte Buddy agent external attach.
   Fix build for modular jars when using later version than Java 8.
   
   
   
   
   Changelog
   Sourced from https://github.com/raphw/byte-buddy/blob/master/release-notes.md;>net.bytebuddy:byte-buddy's
 changelog.
   
   Byte Buddy release notes
   23. April 2024: version 1.14.14
   
   Adjust type validation to accept additional names that are legal in the 
class file format.
   Fix dynamic attach on Windows when a service user is active.
   Avoid failure when using Android's strict mode.
   
   28. March 2024: version 1.14.13
   
   Avoid resolving type variables when generic type processing is 
disabled.
   Improve error message for Byte Buddy agent external attach.
   Fix build for modular jars when using later version than Java 8.
   
   
   
   
   Commits
   
   https://github.com/raphw/byte-buddy/commit/a24599ab06e5d869383c9bf3ed600b25e055e3b2;>a24599a
 [maven-release-plugin] prepare release byte-buddy-1.14.15
   https://github.com/raphw/byte-buddy/commit/0e0cbdf4dbfa60ec7972414a5be2bdd0e805021e;>0e0cbdf
 [release] Release new version
   https://github.com/raphw/byte-buddy/commit/5b5bcaf96013b27fc23b91fcb2bd57184d8d2d17;>5b5bcaf
 Minor code normalizations.
   https://github.com/raphw/byte-buddy/commit/189787960f8389e857c791a51af5e7f396e7e293;>1897879
 Add missing forwarding.
   https://github.com/raphw/byte-buddy/commit/156ba853296fa6bcb688cdcaf249ec080d3746b0;>156ba85
 J9 Allow attachment as root (https://redirect.github.com/raphw/byte-buddy/issues/1631;>#1631)
   https://github.com/raphw/byte-buddy/commit/01ed75b4b53bc43b54d8b7814c158cf310393c68;>01ed75b
 Switch from global property to explicit argument.
   https://github.com/raphw/byte-buddy/commit/f04d254b61e4f05fd647fbcbcb61de32fea1d652;>f04d254
 Add property to allow disabling user check for J9 which does not seem to be 
i...
   https://github.com/raphw/byte-buddy/commit/5b7c966d82ac8e47d486111b1ce16c358c1b402b;>5b7c966
 Update internal Byte Buddy.
   https://github.com/raphw/byte-buddy/commit/e258ec5be04f77060c1f99c6535ef30b6cad9a3b;>e258ec5
 Update checkout plugin.
   https://github.com/raphw/byte-buddy/commit/61209f4785428aee60c3ea6d425355d59db3bf13;>61209f4
 [maven-release-plugin] prepare for next development iteration
   Additional commits viewable in https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.12...byte-buddy-1.14.15;>compare
 view
   
   
   
   
   
   [![Dependabot compatibility 
score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=net.bytebuddy:byte-buddy=gradle=1.14.12=1.14.15)](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores)
   
   Dependabot will resolve any conflicts with this PR as long as you don't 
alter it yourself. You can also trigger a rebase manually by commenting 
`@dependabot rebase`.
   
   [//]: # (dependabot-automerge-start)
   [//]: # (dependabot-automerge-end)
   
   ---
   
   
   Dependabot commands and options
   
   
   You can trigger Dependabot actions by commenting on this PR:
   - `@dependabot rebase` will rebase this PR
   - `@dependabot recreate` will recreate this PR, overwriting any edits that 
have been made to it
   - `@dependabot merge` will merge this PR after your CI passes on it
   - `@dependabot squash and merge` will squash and merge this PR after your CI 
passes on it
   - `@dependabot cancel merge` will cancel a previously requested merge and 
block automerging
   - `@dependabot reopen` will reopen this PR if it is closed
   - `@dependabot close` will close this PR and stop Dependabot recreating it. 
You can achieve the same result by closing it manually
   - `@dependabot show  ignore conditions` will show all of 
the ignore conditions of the specified dependency
   - `@dependabot ignore this major version` will close this PR and stop 
Dependabot creating any more for this major version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this minor version` will close this PR and stop 
Dependabot creating any more for this minor version (unless you reopen the PR 
or upgrade to it yourself)
   - `@dependabot ignore this dependency` will close this PR and stop 
Dependabot creating any more for this dependency (unless

[Bug 68983] POI can't create poifiles sub dir if temp dir is a symlink

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68983

Dominik Stadler  changed:

   What|Removed |Added

   Severity|critical|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 66397] [PATCH] fix doc of createTempFile in TempFile and replace synchronized with ReentrantLock

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=66397

--- Comment #4 from Jürgen Zeller  ---
This patch introduced the bug described in
https://bz.apache.org/bugzilla/show_bug.cgi?id=68983, Files.createDirectories()
does not work with sym links, see 68983 for details.

-- 
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 68983] New: POI can't create poifiles sub dir if temp dir is a symlink

2024-05-08 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=68983

Bug ID: 68983
   Summary: POI can't create poifiles sub dir if temp dir is a
symlink
   Product: POI
   Version: unspecified
  Hardware: PC
OS: Linux
Status: NEW
  Severity: critical
  Priority: P2
 Component: POI Overall
  Assignee: dev@poi.apache.org
  Reporter: jzel...@jzeller.eu
  Target Milestone: ---

POI 5.2.5 changed the implementation of
DefaultTempFileCreationStrategy.createTempFile() from standard IO to NIO:

5.2.3:
final boolean dirExists = (directory.exists() || directory.mkdirs());

5.2.5:
dir = Files.createDirectories(dirPath).toFile();

This leads to an NoSuchFileException if tmpdir is a symlink to a writable,
valid directory:

Caused by: java.nio.file.NoSuchFileException:
/my/tmp/poifiles/poi-sxssf-sheet906981841800128924.xml
at
java.base/sun.nio.fs.UnixException.translateToIOException(UnixException.java:92)
at
java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:111)
at
java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:116)
at
java.base/sun.nio.fs.UnixFileSystemProvider.newByteChannel(UnixFileSystemProvider.java:219)
at java.base/java.nio.file.Files.newByteChannel(Files.java:371)
at java.base/java.nio.file.Files.createFile(Files.java:648)
at java.base/java.nio.file.TempFileHelper.create(TempFileHelper.java:137)
at
java.base/java.nio.file.TempFileHelper.createTempFile(TempFileHelper.java:160)
at java.base/java.nio.file.Files.createTempFile(Files.java:868)
at
org.apache.poi.util.DefaultTempFileCreationStrategy.createTempFile(DefaultTempFileCreationStrategy.java:102)
at org.apache.poi.util.TempFile.createTempFile(TempFile.java:67)
at
org.apache.poi.xssf.streaming.SheetDataWriter.createTempFile(SheetDataWriter.java:100)
at
org.apache.poi.xssf.streaming.SheetDataWriter.(SheetDataWriter.java:74)
at
org.apache.poi.xssf.streaming.SheetDataWriter.(SheetDataWriter.java:84)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheetDataWriter(SXSSFWorkbook.java:387)
at org.apache.poi.xssf.streaming.SXSSFSheet.(SXSSFSheet.java:103)
at
org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:694)


We needed to rollback to 5.2.3 in production to get POI working again.

-- 
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