I’m having a problem with getting data from cells with formulas.
Specifically, I use this source to get data from a cell with a formula. However, if the excel file has not been enabled for manual editing and macros, the result of that formula has not been processed, so even though the cellType has been checked as formula String, the value is is still null.
enter image description here
When I enable editing and macros manually and save, I get the value of that cell formula normally.

21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.89
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: May 3 2024 20:22:11 UTC
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.89.0
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 11
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: x86
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:Program Files (x86)Javajre-1.8
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_411-b09
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:Apacheapache-tomcat-9.0.89
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:Apacheapache-tomcat-9.0.89
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:Apacheapache-tomcat-9.0.89conflogging.properties
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:Apacheapache-tomcat-9.0.89
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:Apacheapache-tomcat-9.0.89
21-May-2024 13:30:03.012 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:Apacheapache-tomcat-9.0.89temp
21-May-2024 13:30:03.012 WARNING [main] org.apache.catalina.core.AprLifecycleListener.init The Apache Tomcat Native library failed to load. The error reported was [C:Apacheapache-tomcat-9.0.89bintcnative-1.dll: Can’t load AMD 64-bit .dll on a IA 32-bit platform]
java.lang.UnsatisfiedLinkError: C:Apacheapache-tomcat-9.0.89bintcnative-1.dll: Can’t load AMD 64-bit .dll on a IA 32-bit platform
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
at java.lang.ClassLoader.loadLibrary0(Unknown Source)
at java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.lang.Runtime.load0(Unknown Source)
at java.lang.System.load(Unknown Source)
at org.apache.tomcat.jni.Library.(Library.java:49)
at org.apache.tomcat.jni.Library.initialize(Library.java:260)
at org.apache.catalina.core.AprLifecycleListener.init(AprLifecycleListener.java:190)
at org.apache.catalina.core.AprLifecycleListener.lifecycleEvent(AprLifecycleListener.java:131)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:114)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)
at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:126)
at org.apache.catalina.startup.Catalina.load(Catalina.java:686)
at org.apache.catalina.startup.Catalina.load(Catalina.java:709)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:302)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:472)
21-May-2024 13:30:03.168 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler [“http-nio-8080”]
21-May-2024 13:30:03.183 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [270] milliseconds
21-May-2024 13:30:03.199 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
21-May-2024 13:30:03.199 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.89]
21-May-2024 13:30:03.199 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:Apacheapache-tomcat-9.0.89webappsdocs]
21-May-2024 13:30:03.434 WARNING [main] org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [110] milliseconds.
21-May-2024 13:30:03.449 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:Apacheapache-tomcat-9.0.89webappsdocs] has finished in [250] ms
21-May-2024 13:30:03.449 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:Apacheapache-tomcat-9.0.89webappsexamples]
21-May-2024 13:30:03.653 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:Apacheapache-tomcat-9.0.89webappsexamples] has finished in [204] ms
21-May-2024 13:30:03.653 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:Apacheapache-tomcat-9.0.89webappshost-manager]
21-May-2024 13:30:03.668 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:Apacheapache-tomcat-9.0.89webappshost-manager] has finished in [15] ms
21-May-2024 13:30:03.668 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:Apacheapache-tomcat-9.0.89webappsmanager]
21-May-2024 13:30:03.684 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:Apacheapache-tomcat-9.0.89webappsmanager] has finished in [16] ms
21-May-2024 13:30:03.684 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:Apacheapache-tomcat-9.0.89webappsROOT]
21-May-2024 13:30:03.684 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:Apacheapache-tomcat-9.0.89webappsROOT] has finished in [0] ms
21-May-2024 13:30:03.699 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [“http-nio-8080”]
21-May-2024 13:30:03.699 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [522] milliseconds