+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Strange result unit conversion on spreadsheet (/thread-4010.html)
Strange result unit conversion on spreadsheet - akmon - 05-28-2015 11:04 PM
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.
RE: Strange result unit conversion on spreadsheet - akmon - 06-23-2015 11:02 PM
Thank you Tim for this new unexpected firmware.
When I saw some of the fixes is: 7. Resolved issue with unit saving in spreadsheet
I thought the problem of my spreadsheet was fixed. But I´ve checked it and the results of D6 (C5*D4) is a strange result: 9,68E335_(m^18*k(kg*m/s^2). Take a look a the file attached on the first post. Thank you.
RE: Strange result unit conversion on spreadsheet - Tim Wessman - 06-23-2015 11:29 PM
We did use it. :-)
The issue was with the data stored for a unit object. Edit, press OK, it will re-evaluate, and it will be good from now on. Nothing that could be done to automatically correct the stored data automatically though unfortunately.
RE: Strange result unit conversion on spreadsheet - akmon - 06-24-2015 10:34 AM
The issue was partially fixed. Thank you anyway for using my sheet.
Now I´m trying to do sme king of "trick", I want to use a command similar to old UVAL from HP 49 series, to get only the numerical result and then add a "string" with the correct units. Which is the equivalent command of UVAL? Thank you again.