[Bug 69147] TEXT Function Regression

2024-06-22 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=69147 PJ Fanning changed: What|Removed |Added Resolution|--- |FIXED Status|NEW

[Bug 69147] TEXT Function Regression

2024-06-22 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=69147 Matafagafo changed: What|Removed |Added CC||matafag...@yahoo.com -- You are receivin

[Bug 69147] TEXT Function Regression

2024-06-21 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=69147 --- Comment #3 from aarbor...@gmail.com --- Agreed on using cached values when possible, however in the use case this was discovered in we are creating the formulas and evaluating them in memory so there's no cached value to depend on. During t

[Bug 69147] TEXT Function Regression

2024-06-21 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=69147 PJ Fanning changed: What|Removed |Added Depends on||67475 --- Comment #2 from PJ Fanning ---

[Bug 69147] TEXT Function Regression

2024-06-21 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=69147 --- Comment #1 from PJ Fanning --- I added r1918499 which shows that if the cell has the date in number format, that the test seems to work. Dates are usually formatted as numbers in the underlying xlsx files - although this may have changed in