[Solved] Looks like a comment but it isn't

[FJCC]

I came across this on the Spanish forum. In the attached document, click on any cell in the range G7:I12 and a box with text will appear that looks much like a comment. However, it is not a comment. You can separately insert a comment in any one of those cells. What are those things?

[RoryOF]

In Content.xml it has this code

Code: Select all

 <table:content-validation table:name="val2" table:base-cell-address="Hoja1.G7">
          <table:help-message table:title="IMPORTANTE" table:display="true">
            <text:p>La unión de las celdas CONVENIO, FECHA DE REGISTRO Y EXPEDIENTE, no deben tener duplicidad.</text:p>
          </table:help-message>
          <table:error-message table:message-type="stop" table:title="NÚMERO DE EXPEDIENTE DUPLICADO" table:display="true">
            <text:p>Compruebe que los datos insertados en las celdas CONVENIO, FECHA DE REGISTRO Y EXPEDIENTE no están duplicados anteriormente.</text:p>
          </table:error-message>
        </table:content-validation>

so, content validation? whatever that is.

[Villeroy]

menu:Data>Validity... [Input Help]

[FJCC]

Of course! The menu item is Data -> Validity. I had never used that without also actually limiting the acceptable values but it can be done.

[MrProgrammer]

menu:Data>Validity... [Input Help]

This ingenious idea was suggested by Zizi64 in Adding small note behind numeric in Spreadsheet. Personally, I add comments using =IF(DateOfComment;CellValue;CellComment) such as =IF("2020-10-16";1234.56;"Sold 32 shares at $38.58"). Any date in the last 100 years evaluates as TRUE, so the formula returns the specified value and the comment is ignored.