![]() ![]() Recalculate Calc formula to eliminate Err 502. Analyze the argument of the functions or functions (in the case of nested formula) and change the arguments. So the problem seems at least practically solved, althoug I remain quite baffled about how date operations have to be rightly managed in Calc. Select the Cell in Calc which contains the Err 502. Which gives the correct answer and is simple. The solution that I have finally found is: F1 =N($A$1) - DATE(2000 1 1) 6391 Has not worked neither has: E1 =DATEVALUE(CONCATENATE(CHAR(34) TEXT($A$1 "DD/MM/YYYY") CHAR(34)))-DATE(2000 1 1) automatic noise cancellation, which helps in an open-office setting. What I take for a correct rendition of the original formula D1 =DATEVALUE(CONCATENATE(CHAR(34) $A$1 CHAR(34)))-DATE(2000 1 1) In fact my Logitech G13, G27, Z200, C920, and G502 all have similar problems at. In my tests C1 does not display an error but a date as a result, only that it is an incorrect one. ![]() It originated when trying to evaluate the formulas in one cell such as B1: Cell content displayī1 =DATEVALUE($A$1) - DATE(2000 1 1) Err:502Īs A1 is an input cell for dates (in an astronomical spreadsheet) I did not understand in the beginning the reason for aplying to it the datevalue() function, which seemed redundant, but I tried in any case to make it work, as the apparently most direct solution (given that the goal was just to perform an arithmetical operation with dates) C1 =$A$1 - DATE(2000 1 1) #VALUEĭid not work in the document (which was imported from an Excel original). Thanks very much.īut unfortunately I have not been able to solve my initial problem just with the correct syntax. OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004) If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add Solved to the beginning of the Subject line. I am sorry for the mistakes in my previous message and you are surely right in your criticisms, Axel.
0 Comments
Leave a Reply. |