In Writer I would like to calculate the last day of the current month. I used something that works perfectly in Calc, being: =EOMONTH(TODAY();0) This gives me a number and with the cell formatted as a date it shows the wanted result : 30/11/18 in this case. However, I use the exact same formula in Writer it gives back an error " * Expression is faulty * " It would make sense to be able to work with dates in a software designed to write letters (among others of course)
In writer you can use insert field, there you can select a fixed date or you can look in the 'More Fields' dialog There you can choose a fixed date or 'daily' date (idem as today() in calc) No need for a formula If your not agree with the WFM solution then you can reopen as unconfirmed Best regards
Sorry, but TODAY() is definitely not the same as EOMONTH(TODAY();0), is it? With the field option, I would need to write the document on the last day of the month for instance to get the wanted date. And if I want to use EOMONTH(TODAY();6), I would have to write it in 6 months.
Tables in writer only contain a few formulas, for more advanced formulas you should use Calc. Later, you can embedded the document in the writer document. Closing as RESOLVED WONTFIX
(In reply to Xisco Faulí from comment #3) > Tables in writer only contain a few formulas, for more advanced formulas you > should use Calc. Later, you can embedded the document in the writer document. > Closing as RESOLVED WONTFIX Xisco, it's an enhancement. I suggest to reopen it
(In reply to Roman Kuznetsov from comment #4) > (In reply to Xisco Faulí from comment #3) > > Tables in writer only contain a few formulas, for more advanced formulas you > > should use Calc. Later, you can embedded the document in the writer document. > > Closing as RESOLVED WONTFIX > > Xisco, it's an enhancement. I suggest to reopen it I know it's an enhancement, the problem is if we add support for this formula in writer, others might want to have other formulas supported as well, and in the end, we add support for all of them in Writer, which is not what Writer is aimed for... My take, WONTFIX
(In reply to Xisco Faulí from comment #5) > (In reply to Roman Kuznetsov from comment #4) > > (In reply to Xisco Faulí from comment #3) > > > Tables in writer only contain a few formulas, for more advanced formulas you > > > should use Calc. Later, you can embedded the document in the writer document. > > > Closing as RESOLVED WONTFIX > > > > Xisco, it's an enhancement. I suggest to reopen it > > I know it's an enhancement, the problem is if we add support for this > formula in writer, others might want to have other formulas supported as > well, and in the end, we add support for all of them in Writer, which is not > what Writer is aimed for... My take, WONTFIX No further comments written. Closing as RESOLVED WONTFIX