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. |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
Strange result unit conversion on spreadsheet - akmon - 05-28-2015 11:04 PM
RE: Strange result unit conversion on spreadsheet - akmon - 06-23-2015, 11:02 PM
RE: Strange result unit conversion on spreadsheet - Tim Wessman - 06-23-2015, 11:29 PM
RE: Strange result unit conversion on spreadsheet - akmon - 06-24-2015, 10:34 AM
|
User(s) browsing this thread: 2 Guest(s)