![]() ![]() ![]() However, manual entry of a value from the keyboard is also permitted. For ease of input, it is desirable to use a suitable control for selecting values with the mouse. The minimum and maximum limits for this value are indicated in two cells (in the same row) to the right of the input cell. In a cell, you need to enter numerical values with a step of 0.01. Let's shortly reformulate the task based on your description of the proposed user interface. Is there a way to specify cells to use for low and high limits in a scrollbar or another control that will let me do what I want? I basically want a control that will let me step between the low range and high range (specified in cells, not as direct numbers) in an increment I set. ![]() I'm okay with using a different kind of control. It won't let me specify cells as the low and high limits. I know I can specify the low and high values for that scrollbar, but only by specifying actual numbers. I have found how to make a scrollbar as a form control in a spreadsheet and link the value to a cell. If I changed the surface type to "Gravel," then the slider/scroll/spinner/whatever would pick between a low of 0.50 and a high of 0.70. If possible, it would increment in intervals of. For instance, here, the slider/scroll/spinner would have a lower limit of 0.5 and a higher limit of 0.7. Next, to make things easy, I want to have an input field called "Surface Coefficient." I want to use something like a spinner or slider so we can quickly pick a value between the high and low numbers in the 4th and 5th columns in that row. I picked Gravel, so it gives me the high and low values I can use for coefficients by reading that data from my table. ![]() From there, I use VLOOKUP to pick the low and high coefficient to go into the next two cells. On the first sheet, I use the Data->Validity->Cell Range to present a list of the surface types so we can pick the kind of surface we're working with. This is in the 2nd sheet, which is for my data and other "ugly" things that an end user doesn't need to see. In LibreOffice Calc, I am doing calculations for erosion and flood control. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |