Apache OpenOffice (AOO) Bugzilla – Issue 117790
Inconsistency between OOo and EXCEL - INT function
Last modified: 2013-08-07 15:13:10 UTC
* Per OOo documentation, INT only operates on numbers. Text-that-looks-like-numbers returns a value of '0'. * EXCEL happily takes a text field that looks like a number, and processes it as a number. --- I just imported a long-used business spreadsheet that parses its 'Job Numbers' field for the imbedded job-priority. [=RIGHT(jobno,1)] --- That priority is then used as the index value for an HLOOKUP of Labor and Travel pay rates. --- Until I spotted the HUGE DIFFERENCE, EVERYONE was getting paid PRIORITY-0 (Emergency)rates, :-) --- Easy fix (once I figured out what wasn't working the same) - global substitution of "VALUE" for "INT" --- and all the bonuses were taken back :-(. --- I'm glad this inconsistency generated such a huge, and obvious change in computed pay values. I spotted almost immediately. If this had come up in a more obscure section, the consequences could have been horrific.
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.
INT gives #VALUE! when processing number in cell formatted as text. Excel 2007 works the same whether cell format is number or text. Rev. 1503704 Win 7