+- 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: is this a bug or intentional (/thread-4942.html)
is this a bug or intentional - roadrunner - 10-13-2015 05:08 PM
I did the following in the spreadsheet app:
1. Named column A1 “DATE”; *edited* named column A, not column A1
2. Selected cell A1 and typed in 2015.1015;
3. Selected cell B1 and typed in =DATEADD(A1,5);
4. Tapped CAS and OK (I got the expected 2015.1020);
5. With cell B1 selected I pressed shift-copy;
6. With cell C1 selected I pressed shift-paste, then selected 1 from the list and then formula.
Instead of the expected 2015.1025 I got =B1ADD(B1,5)
FYI: software version 8151, hardware version C
-Road
RE: is this a bug or intentional - Tim Wessman - 10-13-2015 06:04 PM
Nope, definitely not intentional. I'm guessing the cell replacement which allows the paste to rewrite formulas and have them work properly on pasting isn't checking against known function names once the "named" cell is found.
Thanks!