Apache OpenOffice (AOO) Bugzilla – Issue 69158
number formatted as text on import and OOo doesn't calculate with text - thus calculation fails
Last modified: 2006-09-05 10:20:27 UTC
Just found out that when I open my local companies computer price I cant see the prices for some reason. They are all 0.0. When I use Excel though, I can view them perfectly. Just wanted you guys to know..thats all;) Keep up the good work! http://www.neoservice.ua/fileadmin/prices/rprice.rar
confirming. Please try to use a more telling summary next time and please attach the file directly to the issue. The problem is that cell E4 gets imported as text. Remove the ' from the 5,3 and you'll get the same values as in Excel.
and try to use the matching component the next time - reassigning
double to Issue 5658 *** This issue has been marked as a duplicate of 5658 ***
closed double You may use Value Highlighting (CTRL+F8) to check for such problems. Black is text, blue are numbers and green are formula results. Frank