com.github.pjfanning.xlsx.impl.WrappedComment Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of excel-streaming-reader Show documentation
Streaming Excel reader
The newest version!
package com.github.pjfanning.xlsx.impl;

import org.apache.poi.ss.usermodel.ClientAnchor;
import org.apache.poi.ss.usermodel.Comment;
import org.apache.poi.ss.usermodel.RichTextString;
import org.apache.poi.ss.util.CellAddress;
import org.apache.poi.xssf.usermodel.XSSFComment;
import org.apache.poi.xssf.usermodel.XSSFRichTextString;

public class WrappedComment implements Comment {

  private final XSSFComment xssfComment;

  WrappedComment(XSSFComment xssfComment) {
    this.xssfComment = xssfComment;
  }

  @Override
  public boolean isVisible() {
    return xssfComment.isVisible();
  }

  @Override
  public CellAddress getAddress() {
    return xssfComment.getAddress();
  }

  @Override
  public int getRow() {
    return xssfComment.getRow();
  }

  @Override
  public int getColumn() {
    return xssfComment.getColumn();
  }

  @Override
  public String getAuthor() {
    return xssfComment.getAuthor();
  }

  @Override
  public ClientAnchor getClientAnchor() {
    return xssfComment.getClientAnchor();
  }

  @Override
  public XSSFRichTextString getString() {
    XSSFRichTextString rts = xssfComment.getString();
    String text = rts.getString();
    if(text.contains("Your version of Excel allows you to read this threaded comment")) {
      String splitText = "Comment:";
      int pos = text.lastIndexOf(splitText);
      if (pos != -1) {
        return new XSSFRichTextString(ltrim(text.substring(pos + splitText.length())));
      }
    }
    return rts;
  }

  @Override
  public void setAddress(CellAddress addr) {
    xssfComment.setAddress(addr);
  }

  @Override
  public void setVisible(boolean visible) {
    xssfComment.setVisible(visible);
  }

  @Override
  public void setAddress(int row, int col) {
    xssfComment.setAddress(row, col);
  }

  @Override
  public void setRow(int row) {
    xssfComment.setRow(row);
  }

  @Override
  public void setColumn(int col) {
    xssfComment.setColumn(col);
  }

  @Override
  public void setAuthor(String author) {
    xssfComment.setAuthor(author);
  }

  @Override
  public void setString(RichTextString string) {
    xssfComment.setString(string);
  }

  private String ltrim(String s) {
    int i = 0;
    while (i < s.length() && Character.isWhitespace(s.charAt(i))) {
      i++;
    }
    return s.substring(i);
  }

  @Override
  public boolean equals(Object other) {
    return xssfComment.equals(other);
  }

  @Override
  public int hashCode() {
    return xssfComment.hashCode();
  }
}