Created attachment 116657 [details] snip case 1 Working in LOC I noted with disappointment that Calc attributes or changes autonomously a preset cell format thereby altering the desired result and forcing repeatedly to reset the format of the affected cells. Look at the attachments for two cases I have documented.
Created attachment 116658 [details] snip case 2
Hi @gmarco, 1) I don't think they are issues, maybe you don't like it, but usually if I create a cell with reference to other cell with date it will be date. Creating a new style different than Standard for number and apply it to the new cell before insert the formula, the style is respected. 2) IF returns a zero in boolean format if the third parameter is omitted, it's how it works, add a zero as third parameter and you receive a non boolean zero as result. Please in the future use one bug by issue. If you like those working in another way, please fill one bug for any request as 'enhancement' in the importance.