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 stop if true boolean settings in Conditional formatting #2233

Closed
paweenwat-man opened this issue Apr 1, 2023 · 2 comments · May be fixed by #2736
Closed

Add stop if true boolean settings in Conditional formatting #2233

paweenwat-man opened this issue Apr 1, 2023 · 2 comments · May be fixed by #2736

Comments

@paweenwat-man
Copy link

I see the Python Excel library has this option, but I needed to use to get the same result as my Python code do in my client side.

Example

worksheet.addConditionalFormatting({
  ref: `${startColumnLetter}${this.worksheet.rowCount}:${endColumnLetter}${this.worksheet.rowCount}`,
  rules: [
    {
      type: 'expression',
      formulae: [`$E${this.worksheet.rowCount} < ${this.missDistance * 1000}`],
      style: {
        font: { color: { argb: 'FFFFFFFF' } },
        fill: { type: 'pattern', pattern: 'solid', bgColor: { argb: 'FFFF0000' } },
      },
      stopIfTrue: true,
    },
    {
      type: 'expression',
      formulae: [`$D${this.worksheet.rowCount} > ${this.probability}`],
      style: {
        font: { color: { argb: 'FF000000' } },
        fill: { type: 'pattern', pattern: 'solid', bgColor: { argb: 'FFFFD966' } },
      },
      stopIfTrue: true,
    }
  ]
})
@Blackhol3
Copy link

Why has this issue been marked as completed? stopIfTrue is still not available.

@paweenwat-man
Copy link
Author

I don't know, because I've been inactive too long. First, I used ExcelJS to export the data from the client side, but my server is running with Python, so I could implement API to export the data from the server using openpyxl instead.

The problem still exists on the server running with Node.js

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants