Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add cell content validation #224

Open
jferard opened this issue May 1, 2021 · 0 comments
Open

Add cell content validation #224

jferard opened this issue May 1, 2021 · 0 comments
Assignees
Labels
Milestone

Comments

@jferard
Copy link
Owner

jferard commented May 1, 2021

I convert this message from @AliKantouar into a more generic issue.
The menu Data > Validity... allows to check the validty of a user entry (that is, in this context, after the document was generated by FastODS). The relevant item in OpenDocument specification are:

  • 9.4.4 table:content-validations
  • 19.596 table:condition
  • 19.601table:content-validation-name

And a few other items.

An example:

<table:content-validations>
    <table:content-validation table:name="val1" table:condition="of:cell-content-is-in-list(&quot;A&quot;;&quot;B&quot;;&quot;C&quot;)" table:allow-empty-cell="true" table:display-list="unsorted" table:base-cell-address="Sheet1.F7">
         <table:error-message table:message-type="stop" table:display="true"/>
    </table:content-validation>
</table:content-validations>

And in the table row:

<table:table-cell table:content-validation-name="val1"/>

Design sketch:

  • one or a few class to generate conditions
  • add table-content:validations to office:spreadsheet
  • place the validation attribute in the "cold" cell.

The condition generation will be the hardest part of the job...

@jferard jferard added this to the 0.8.0 milestone May 1, 2021
@jferard jferard self-assigned this May 1, 2021
jferard added a commit that referenced this issue May 2, 2021
@jferard jferard modified the milestones: 0.8.0, 0.8.1 Dec 23, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant