Noone can provide you with any guarantees. Apache POI is open source and free. It is a collaboration between many volunteers. The Microsoft file formats are too complex and varied for us to have coverage for all use cases. If your use case is similar to use cases of individuals and teams who have contributed code and tests to POI then there is a good chance that POI will work well for you. You may need to write some custom code on top of what POI provides.
On Tuesday 5 January 2021, 06:42:10 GMT, SD1 D <sdtem...@gmail.com> wrote: Thanks for the response. 1. We shall use only the prebuilt jar files of POI and use the APIs from these prebuild jar. However, we shall use Java 1.8_u102 to build our custom programs which refers POI prebuilt jar. Based on your response below, I understand that our custom jar file with POI based functions should work with Adopt OpenJDK 11.0.x (We will have JRE or JDK or both installed). We shall use the default XML based format of Excel 2019. 2. Also we already have some existing programs developed using POI 3.9 and those are working fine with Excel 2010. (Upgrading to newer POI version may take some time and meantime we may have to use POI 3.9 with Excel 2013 or 2019 files). We do not want to use any new features of Excel 2019, however, we shall just Open and Save our existing Excel 2010 template files to Excel 2019 without making any modifications and then open, save-as and use these template files using POI. Since there is no change in the Excel file, we are assuming that the existing functionality (build using POI 3.9) should work with existing template files saved with new version Excel 2019 also. Are these assumptions are correct? Thanks On 2020/12/31 15:44:42, "fannin...@apache.org" <fannin...@apache.org> wrote: > We would always recommend users use the latest release. POI 4.1.2. > https://poi.apache.org/download.html > > You should not need to recompile the code. We would recommend using pre-built > binaries or jars hosted on Maven Central. > > We would expect the code to run ok on Adopt OpenJDK 11.0.x - you will need to > have a JRE or JDK installed. > > If someone creates a file using Excel 2019 - the biggest concern would be if > they use Strict OOXML or Transitional OOXML formats - POI does not support > Strict OOXML format. > Excel 2019 may also have some features that we don't support. > > > > > > > On Thursday 31 December 2020, 14:50:33 GMT, SD1 D <sdtem...@gmail.com> wrote: > > > > > > Hello Members, > > Greetings ! > > I have some queries on compatibility: > > 1. We intend to compile \ build our POI 3.15 code with Oracle JDK 1.8 on a > development machine. However, the user machine shall have Adopt OpenJDK > 11.0.7 where these programs are intended to run. Is this combination > supported - can we run our programs with Adopt OpenJDK? Is Oracle JRE \ JDK > mandatory to be available on client machine to run the programs. > > 2. Is POI 3.9 and 3.15 compatible with MS Excel 2019? > > Thanks for your support. > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org