Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-469

Implement automin and automax for conditional formatting

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Done
    • Normal
    • 5.9.0
    • None
    • None
    • Security Level: Jimmy
    • None

    Description

      User Story

      Excel 2010+ supports conditional formatting using automin and automax boundaries. See details.

       

      Keikai currently doesn't implement automin and automax, cause NPE on spreadsheet using automin or automax in conditional formatting.

      See attached spreadsheet.

      Acceptance Criteria

      • Implement conditional formatting, or handle the automin automax conditional formatting values to avoid NPE
      • If we can't implement this feature, please handle null pointer exception gracefully

      Details

      https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.office2010.excel.conditionalformattingvalueobjecttypevalues?view=openxml-2.8.1

       

      https://www.contextures.com/excel-conditional-formatting-data-bars.html

       

      Attachments

        Activity

          People

            jumperchen jumperchen
            MDuchemin MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: