io.keikai.model.impl.BookImpl.cloneBook() fails with DataValidation or conditional formatting

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major
    • None
    • Affects Version/s: 6.0.0
    • Component/s: None
    • None

      Steps to Reproduce

      Run keikai app
      Call:
      bookManager.readBook(new SimpleBookInfo("yourBookHere.xlsx")).cloneBook();

      Where the book contains a Validation or conditional formatting

      Current Result

      org.apache.poi.ss.formula.LazyAreaEval (if xlsx document contains data validation)
      or
      java.io.NotSerializableException: io.keikai.app.ui.AppCtrl$4 (if it doesn't)

      Expected Result

      clone doesn't cause serialization exceptions

      Debug Information

      ValidationImpl has non-serializable non-transient fields:
      private ValueEval _evalValue1EvalResult;
      private ValueEval _evalValue2EvalResult;

      BookImpl has non-serializable non-transient fields:
      private EventListenerAdaptor _listeners;
      private EventListenerAdaptor _queueListeners;
      private EvaluationContributor _evalContributor;

      Workaround

      • Use export to xlsx and reimport
      • copy an xlsx file

            Assignee:
            Unassigned
            Reporter:
            MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: