1.7.5 setValue() switches to only setting value of todays date serial and formatting as date

Topics: Developer Forum
Jan 12, 2011 at 8:58 AM

I have just fixed a problem report by swiching back to version 1.7.3.

One of the sheets would have tab 3, cells E1 and F1 would have todays date showing.

The cell formula is a integer (today's date serial value) formatted as a date. (40555 = '12/01/2011').

I tested by setting first sheet sheet cell A1 to 'ZZZ' as the last action before invoking the writer and closing down, with the same result.

I have no idea as to when the change in behaviour would take place as the workbook is full of correct info.

The book has 15 tabs (2 with text, 13 with 11 rows of data, 1 row of heading).

 

Any ideas ?

Jan 13, 2011 at 9:10 AM

PHP Version 5.2.13

Coordinator
Jan 13, 2011 at 9:36 PM
Edited Jan 13, 2011 at 9:37 PM

I'm not really sure I understand the problem. Do these cells actually contain a formula? or an integer value? Would it be possible to strip down the workbook to just a single sheet with these cells, or a block of code that demonstrates the problem, so that I could see for myself what you mean?