New to Libre Office. Imported an Excel workbook that contains radio buttons. In Excel the buttons when pressed set a value in a cell to 1, 2, or 3 depending upon which button was selected. Calc converted the first one to set the cell to True, and the second and third buttons set it to False. I cannot figure out how to change this. Can someone help?
Set the Format of the Cell to Number: Formatcode 0
Tried that, it was formatted as text, but now I can’t figure out how to set the controls so if the first button is punched it sets the cell contents to 1, etc.
I also tried going back to the original Excel wirkbook and formatting the cells with the control values as number, and re-opened them in Calc. Now I can’t get the buttons to select.
thank you! i’ll try this out.
v/r,
Claud Cameron
thank you very much for your help with this. I’ve been struggling with it for a while, it’s a little different than Excel.
I know you don’t have all day to fiddle with this, but now the problem seems to be setting the linked cell’s format to number (format code 0). the format reverts to text as soon as I use the button. I changed my if statement to if(C3=“1” instead of if(C3=1, which works, but why won’t the format for the cell stay as number?
v/r,
Claud Cameron