Post Reply 
Strange result unit conversion on spreadsheet
05-28-2015, 11:04 PM
Post: #1
Strange result unit conversion on spreadsheet
Hello, greetings from Spain.

I was doing some conversion formulas on a spreadsheet. But There are two unexpected behaviours.
First, sometimes when I open the sheet, some cells warn with "Overflow" error, but if you edit that cell and simply press OK it fixes with the desirable result.

The other issue is the cell D6. The units are a garbage (_kN*m^2*Zm^16). The formula is a product from one unit cell to other. And if I swap the product, it gives another kind of error 9,68E335_(m^18*kN). What the...??
It´s obvious there is a bug there, I´ve attached the spreadsheet to check it by you.

Hope you find the issue. Many thanks.


Attached File(s)
.zip  CONVERSIONES.hpappdir.zip (Size: 1.53 KB / Downloads: 10)
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Strange result unit conversion on spreadsheet - akmon - 05-28-2015 11:04 PM



User(s) browsing this thread: 1 Guest(s)