[Bug 66519] New: Read pagination and conversion issues

2023-03-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66519

Bug ID: 66519
   Summary: Read pagination and conversion issues
   Product: POI
   Version: 5.2.3-FINAL
  Hardware: PC
Status: NEW
  Severity: major
  Priority: P2
 Component: XWPF
  Assignee: dev@poi.apache.org
  Reporter: stevenli...@gmail.com
  Target Milestone: ---

Created attachment 38520
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=38520=edit
problematic document

Trying to read the word document attached below cannot read the pagination and
conversion documents correctly, the speed is extremely slow, and it is
suspected to be a problem caused by the merged cells of column data.

-- 
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 66518] New: ExcelToHtmlConverte conversion to hexadecimal color format is wrong

2023-03-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66518

Bug ID: 66518
   Summary: ExcelToHtmlConverte conversion to hexadecimal color
format is wrong
   Product: POI
   Version: 5.2.3-FINAL
  Hardware: PC
Status: NEW
  Severity: normal
  Priority: P2
 Component: HSSF
  Assignee: dev@poi.apache.org
  Reporter: 1107637...@qq.com
  Target Milestone: ---

org.apache.poi.hssf.converter.AbstractExcelUtils.getColor(HSSFColor)

#0e3466 will be converted to #e3466

The part of code:
for (short s : color.getTriplet()) {
if (s < 10) {
stringBuilder.append('0');
}
stringBuilder.append(Integer.toHexString(s));
}
}

And I think that:
's < 10' should be 's < 16'

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



[GitHub] [poi] dependabot[bot] commented on pull request #438: Bump net.bytebuddy:byte-buddy-agent from 1.14.0 to 1.14.1

2023-03-07 Thread via GitHub


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

   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



[GitHub] [poi] dependabot[bot] commented on pull request #437: Bump net.bytebuddy:byte-buddy from 1.14.0 to 1.14.1

2023-03-07 Thread via GitHub


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

   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



[GitHub] [poi] asfgit closed pull request #438: Bump net.bytebuddy:byte-buddy-agent from 1.14.0 to 1.14.1

2023-03-07 Thread via GitHub


asfgit closed pull request #438: Bump net.bytebuddy:byte-buddy-agent from 
1.14.0 to 1.14.1
URL: https://github.com/apache/poi/pull/438


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



[GitHub] [poi] asfgit closed pull request #437: Bump net.bytebuddy:byte-buddy from 1.14.0 to 1.14.1

2023-03-07 Thread via GitHub


asfgit closed pull request #437: Bump net.bytebuddy:byte-buddy from 1.14.0 to 
1.14.1
URL: https://github.com/apache/poi/pull/437


-- 
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 66515] New: Formula not updating after setCellFormula

2023-03-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66515

Bug ID: 66515
   Summary: Formula not updating after setCellFormula
   Product: POI
   Version: unspecified
  Hardware: PC
OS: Linux
Status: NEW
  Severity: normal
  Priority: P2
 Component: XSSF
  Assignee: dev@poi.apache.org
  Reporter: sz...@uni-bonn.de
  Target Milestone: ---

This is more a workaround report as a bug report.
In our corporate document I was not able to change a formula particular in a
particular cell/column.

saldoCell.setCellFormula("H1"); //this did not work

However it workes after I deleted the formula from cell:

saldoCell.setCellFormula(null);
saldoCell.setCellFormula("H1"); //this worked

I am not expert on Excell, but surely it can be helpful for someone in similar
situation. 
If you would like to have a closer look on this issue, I could provide you with
the file, but I can not make it public, I guess.

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



[GitHub] [poi] dependabot[bot] opened a new pull request, #438: Bump net.bytebuddy:byte-buddy-agent from 1.14.0 to 1.14.1

2023-03-07 Thread via GitHub


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

   Bumps [net.bytebuddy:byte-buddy-agent](https://github.com/raphw/byte-buddy) 
from 1.14.0 to 1.14.1.
   
   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
   
   
   
   Commits
   
   https://github.com/raphw/byte-buddy/commit/5ef0fa607620e43fbbbe6000740199a13cca5c88;>5ef0fa6
 [maven-release-plugin] prepare release byte-buddy-1.14.1
   https://github.com/raphw/byte-buddy/commit/bada1525a2678a27d486598c22e8ee74a81a9551;>bada152
 [release] Release new version
   https://github.com/raphw/byte-buddy/commit/334128e2f834d51d63818d1d895a0211ca0cb58b;>334128e
 Update Eclipse lifecycle mapping.
   https://github.com/raphw/byte-buddy/commit/876d66702e144db53502ea3e3f5eb3e6b11e84e8;>876d667
 Add additional scope for Maven plugin.
   https://github.com/raphw/byte-buddy/commit/665a090c733c37339788cc5a1c441bd47fb77ef0;>665a090
 Add checksums.
   https://github.com/raphw/byte-buddy/commit/537c61344e86dd7cdc80c886adf8773b4290c0cf;>537c613
 Increment internal byte buddy and add release notes.
   https://github.com/raphw/byte-buddy/commit/8c6f8619a0e2e582e01e524fc551f1cc9f4cf4be;>8c6f861
 [maven-release-plugin] prepare for next development iteration
   See full diff in https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.0...byte-buddy-1.14.1;>compare
 view
   
   
   
   
   
   [![Dependabot compatibility 
score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=net.bytebuddy:byte-buddy-agent=gradle=1.14.0=1.14.1)](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 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 you reopen the PR or 
upgrade to it yourself)
   
   
   


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



[GitHub] [poi] dependabot[bot] opened a new pull request, #437: Bump net.bytebuddy:byte-buddy from 1.14.0 to 1.14.1

2023-03-07 Thread via GitHub


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

   Bumps [net.bytebuddy:byte-buddy](https://github.com/raphw/byte-buddy) from 
1.14.0 to 1.14.1.
   
   Changelog
   Sourced from https://github.com/raphw/byte-buddy/blob/master/release-notes.md;>net.bytebuddy:byte-buddy's
 changelog.
   
   Byte Buddy release notes
   
   
   
   Commits
   
   https://github.com/raphw/byte-buddy/commit/5ef0fa607620e43fbbbe6000740199a13cca5c88;>5ef0fa6
 [maven-release-plugin] prepare release byte-buddy-1.14.1
   https://github.com/raphw/byte-buddy/commit/bada1525a2678a27d486598c22e8ee74a81a9551;>bada152
 [release] Release new version
   https://github.com/raphw/byte-buddy/commit/334128e2f834d51d63818d1d895a0211ca0cb58b;>334128e
 Update Eclipse lifecycle mapping.
   https://github.com/raphw/byte-buddy/commit/876d66702e144db53502ea3e3f5eb3e6b11e84e8;>876d667
 Add additional scope for Maven plugin.
   https://github.com/raphw/byte-buddy/commit/665a090c733c37339788cc5a1c441bd47fb77ef0;>665a090
 Add checksums.
   https://github.com/raphw/byte-buddy/commit/537c61344e86dd7cdc80c886adf8773b4290c0cf;>537c613
 Increment internal byte buddy and add release notes.
   https://github.com/raphw/byte-buddy/commit/8c6f8619a0e2e582e01e524fc551f1cc9f4cf4be;>8c6f861
 [maven-release-plugin] prepare for next development iteration
   See full diff in https://github.com/raphw/byte-buddy/compare/byte-buddy-1.14.0...byte-buddy-1.14.1;>compare
 view
   
   
   
   
   
   [![Dependabot compatibility 
score](https://dependabot-badges.githubapp.com/badges/compatibility_score?dependency-name=net.bytebuddy:byte-buddy=gradle=1.14.0=1.14.1)](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 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 you reopen the PR or 
upgrade to it yourself)
   
   
   


-- 
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 50795] Moving cell comment crashes Excel file

2023-03-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=50795

--- Comment #8 from PJ Fanning  ---
https://github.com/pjfanning/poi-shared-strings has an alternative
implementation of the POI CommentsTable. You could try using that to see it
helps.

-- 
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: [DISCUSS] dropping support for bin distribution?

2023-03-07 Thread PJ Fanning
If there are no objections, I'll move towards removing the binary distribution 
from the build and related release docs.

I've logged https://bz.apache.org/bugzilla/show_bug.cgi?id=66514 and will track 
any commits there so they can be reverted if we choose to ever bring back the 
binary distributions.






On Saturday 25 February 2023 at 16:51:40 GMT+1, Marius Volkhart 
 wrote: 





+1 for removing them. Maven downloads, even if not using a Maven-aware build 
tool, feels like a very reasonable option.

Cheers,
Marius 

> On Feb 25, 2023, at 09:37, PJ Fanning  wrote:
> 
> Hi everyone,
> 
> The ASF only requires that we do src distributions for releases. We also 
> publish our jars to Maven Central. Most of our users get the POI jars via 
> Maven Central.
> 
> The poi-bin zip and tgz files are just the jars and some of the dependency 
> jars that they need packaged up. Most bin zips and tgzs include scripts to 
> run applications or examples. I've even used our xmlbeans-bin zip in the past 
> to use the scomp.sh.
> 
> The reason I ask is that I think we need to update the license details if we 
> keep the poi-bin zip/tgzs. See 
> https://lists.apache.org/thread/v74bft4f66of901hok1ylh49b85lo7cm
> 
> My feeling is that if we don't need to provide these poi-bin zip/tgz files, 
> then we could get rid of it and simplify the release. To reiterate, the Maven 
> Central publish is useful and I am not suggesting removing this part of the 
> release.
> 
> Regards,
> PJ
> 
> 
> -
> 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


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



[Bug 66514] New: remove poi-bin zip/tgz from the build

2023-03-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=66514

Bug ID: 66514
   Summary: remove poi-bin zip/tgz from the build
   Product: POI
   Version: 5.2.3-FINAL
  Hardware: All
OS: All
Status: NEW
  Severity: normal
  Priority: P2
 Component: POI Overall
  Assignee: dev@poi.apache.org
  Reporter: fannin...@yahoo.com
  Target Milestone: ---

Only the 'poi-src' zip/tgz files are required as part of the ASF release
processes.

The 'poi-bin' zip/tgz files don't appear to widely used and we will continue to
release jars to Maven Central.

-- 
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: AW: POI PMC roll call

2023-03-07 Thread PJ Fanning
Thanks everyone. It looks like we're pretty well set for the time being. 
Hopefully, we'll see some activity from contributors outside the existing POI 
team and will be able to invite them to join as POI committers, in time.






On Saturday 4 March 2023 at 23:36:45 GMT+1, a...@dua3.com  
wrote: 





Hi,
I don’t find much time to contribute. I look into the dev list from time to 
time and occasionally respond or comment on issues, but it has been some time 
since I last contributed any code. Reason is that my current dayjob does not 
involve POI anymore and in the remaining time I am preparing to start a small 
company which has now become my “nightjob”. So I might occasionally make a 
small contribution, and there might be a moment when I will find more time for 
POI again, but I have no idea when that will be.
Regards,
Axel



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



[Bug 50795] Moving cell comment crashes Excel file

2023-03-07 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=50795

--- Comment #7 from javifinar...@hotmail.com ---
For the record, I moved from this bug. Even it is a bottleneck, the worst
bottleneck comes from writing comments, because they are stored all on memory
(lots of ram needed) and a xml copy method that invoked lots of time is
inneficient. I haven't been able to found discussions regarding moving cell
comments to streaming

For the record, we are talking about 500 000 comments...

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