Show HN: I made a spreadsheet where formulas also update backwards

Re:Show HN: I made a spreadsheet where formulas also update ... by ximm on Saturday December 13, 2025 @02:06AM (#46252671)

100% this. When I reached the end of that page I felt pranked because the obvious question was never answered. How are these cases resolved? Is it possible to fix some inputs and only update others? What if I sometimes want to change input A, and other times I want to update input B? All this should be explained as early as possible.

[ Parent | on HN ]

Re:Show HN: I made a spreadsheet where formulas also update ... by fouronnes3 on Saturday December 13, 2025 @02:21AM (#46252750)

You can do it and it is explained, actually. Use # as a prefix to indicate a constant, e.g.: #50 will be a constant and not a variable.

In the future I'd like to support more user input constraints, in particular domain constraints for variables. So you could tell the solver that this cell must remain in some interval, and it would respect that interval instead of assigning any real value.

[ Parent | on HN ]

Re:Show HN: I made a spreadsheet where formulas also update ... by bmacho on Saturday December 13, 2025 @03:54AM (#46253152)

is your example correct? 50 should be a constant without prefixing it and not a variable

[ Parent | on HN ]

Re:Show HN: I made a spreadsheet where formulas also update ... by nkrisc on Saturday December 13, 2025 @11:24AM (#46255696)

IMO constant should be the default and variables should be annotated.

[ Parent | on HN ]