Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
Assuming Check Box Form Controls in ColumnD, yes in OpenOffice Calc 4.1.4, though for some the process may be too tedious and entering say an x instead may be preferred. Unlike in Google Sheets for...
Answer
#4: Post undeleted
by
Alexei
·
2021-05-26T18:12:39Z (almost 3 years ago)
#3: Post deleted
by
pnuts
·
2021-05-24T06:40:46Z (almost 3 years ago)
#2: Post edited
by
pnuts
·
2020-10-17T17:57:37Z (over 3 years ago)
- Assuming Check Box Form Controls in ColumnD, yes in OpenOffice Calc 4.1.4, though for some the process may be too tedious and entering say an `x` instead may be preferred.
Unlike in Google Sheets for example, where a Tick box has a FALSE/TRUE value associated with it automatically, in Calc the association has to be made by the user. Select View > Toolbars > Form Design and ensure Design Mode is turned on (highlighted background) then select a Check Box and Control… > Data and for `Linked cell` enter the reference for the cell in which the Check Box resides. This should enter `TRUE`<sup>†</sup> in that cell when that Check Box is ticked Repeat for all other Check Boxes, turn off Design Mode and apply CF in the normal way.- <sup>†</sup> The `TRUE` (or `FALSE`) can be hidden by choosing white as the default font colour and, in Conditional Formatting, the same font colour as the background colour selected there.
- Assuming Check Box Form Controls in ColumnD, yes in OpenOffice Calc 4.1.4, though for some the process may be too tedious and entering say an `x` instead may be preferred.
- Unlike in Google Sheets for example, where a Tick box has a FALSE/TRUE value associated with it automatically, in Calc the association has to be made by the user. Select View > Toolbars > Form Design and ensure Design Mode is turned on (highlighted background) then select a Check Box and Control… > Data and for `Linked cell` enter the reference for the cell in which the Check Box resides. This should enter `TRUE`<sup>†</sup> in that cell when that Check Box is ticked. Repeat for all other Check Boxes, turn off Design Mode and apply CF in the normal way.
- <sup>†</sup> The `TRUE` (or `FALSE`) can be hidden by choosing white as the default font colour and, in Conditional Formatting, the same font colour as the background colour selected there.
#1: Initial revision
by
pnuts
·
2020-10-17T17:49:36Z (over 3 years ago)
Assuming Check Box Form Controls in ColumnD, yes in OpenOffice Calc 4.1.4, though for some the process may be too tedious and entering say an `x` instead may be preferred. Unlike in Google Sheets for example, where a Tick box has a FALSE/TRUE value associated with it automatically, in Calc the association has to be made by the user. Select View > Toolbars > Form Design and ensure Design Mode is turned on (highlighted background) then select a Check Box and Control… > Data and for `Linked cell` enter the reference for the cell in which the Check Box resides. This should enter `TRUE`<sup>†</sup> in that cell when that Check Box is ticked Repeat for all other Check Boxes, turn off Design Mode and apply CF in the normal way. <sup>†</sup> The `TRUE` (or `FALSE`) can be hidden by choosing white as the default font colour and, in Conditional Formatting, the same font colour as the background colour selected there.