Java tutorial
/* ==================================================================== Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. ==================================================================== */ package org.apache.poi.hssf.record; import org.apache.poi.util.LittleEndianOutput; import org.apache.poi.util.StringUtil; /** * NOTE: Comment Associated with a Cell (0x001C) */ public final class NoteRecord extends StandardRecord implements Cloneable { public final static short sid = 0x001C; public static final NoteRecord[] EMPTY_ARRAY = {}; /** * Flag indicating that the comment is hidden (default) */ public final static short NOTE_HIDDEN = 0x0; /** * Flag indicating that the comment is visible */ public final static short NOTE_VISIBLE = 0x2; private static final Byte DEFAULT_PADDING = Byte.valueOf((byte) 0); private int field_1_row; private int field_2_col; private short field_3_flags; private int field_4_shapeid; private boolean field_5_hasMultibyte; private String field_6_author; /** * Saves padding byte value to reduce delta during round-trip serialization.<br> * * The documentation is not clear about how padding should work. In any case * Excel(2007) does something different. */ private Byte field_7_padding; /** * Construct a new <code>NoteRecord</code> and * fill its data with the default values */ public NoteRecord() { field_6_author = ""; field_3_flags = 0; field_7_padding = DEFAULT_PADDING; // seems to be always present regardless of author text } /** * @return id of this record. */ public short getSid() { return sid; } /** * Read the record data from the supplied <code>RecordInputStream</code> * * @param in the RecordInputStream to read from */ public NoteRecord(RecordInputStream in) { field_1_row = in.readUShort(); field_2_col = in.readShort(); field_3_flags = in.readShort(); field_4_shapeid = in.readUShort(); int length = in.readShort(); field_5_hasMultibyte = in.readByte() != 0x00; if (field_5_hasMultibyte) { field_6_author = StringUtil.readUnicodeLE(in, length); } else { field_6_author = StringUtil.readCompressedUnicode(in, length); } if (in.available() == 1) { field_7_padding = Byte.valueOf(in.readByte()); } else if (in.available() == 2 && length == 0) { // If there's no author, may be double padded field_7_padding = Byte.valueOf(in.readByte()); in.readByte(); } } public void serialize(LittleEndianOutput out) { out.writeShort(field_1_row); out.writeShort(field_2_col); out.writeShort(field_3_flags); out.writeShort(field_4_shapeid); out.writeShort(field_6_author.length()); out.writeByte(field_5_hasMultibyte ? 0x01 : 0x00); if (field_5_hasMultibyte) { StringUtil.putUnicodeLE(field_6_author, out); } else { StringUtil.putCompressedUnicode(field_6_author, out); } if (field_7_padding != null) { out.writeByte(field_7_padding.intValue()); } } protected int getDataSize() { return 11 // 5 shorts + 1 byte + field_6_author.length() * (field_5_hasMultibyte ? 2 : 1) + (field_7_padding == null ? 0 : 1); } /** * Convert this record to string. * Used by BiffViewer and other utilities. */ public String toString() { StringBuffer buffer = new StringBuffer(); buffer.append("[NOTE]\n"); buffer.append(" .row = ").append(field_1_row).append("\n"); buffer.append(" .col = ").append(field_2_col).append("\n"); buffer.append(" .flags = ").append(field_3_flags).append("\n"); buffer.append(" .shapeid= ").append(field_4_shapeid).append("\n"); buffer.append(" .author = ").append(field_6_author).append("\n"); buffer.append("[/NOTE]\n"); return buffer.toString(); } /** * Return the row that contains the comment * * @return the row that contains the comment */ public int getRow() { return field_1_row; } /** * Specify the row that contains the comment * * @param row the row that contains the comment */ public void setRow(int row) { field_1_row = row; } /** * Return the column that contains the comment * * @return the column that contains the comment */ public int getColumn() { return field_2_col; } /** * Specify the column that contains the comment * * @param col the column that contains the comment */ public void setColumn(int col) { field_2_col = col; } /** * Options flags. * * @return the options flag * @see #NOTE_VISIBLE * @see #NOTE_HIDDEN */ public short getFlags() { return field_3_flags; } /** * Options flag * * @param flags the options flag * @see #NOTE_VISIBLE * @see #NOTE_HIDDEN */ public void setFlags(short flags) { field_3_flags = flags; } /** * For unit testing only! * * @return true, if author element uses multi byte */ protected boolean authorIsMultibyte() { return field_5_hasMultibyte; } /** * Object id for OBJ record that contains the comment * * @return the Object id for OBJ record that contains the comment */ public int getShapeId() { return field_4_shapeid; } /** * Object id for OBJ record that contains the comment * * @param id the Object id for OBJ record that contains the comment */ public void setShapeId(int id) { field_4_shapeid = id; } /** * Name of the original comment author * * @return the name of the original author of the comment */ public String getAuthor() { return field_6_author; } /** * Name of the original comment author * * @param author the name of the original author of the comment */ public void setAuthor(String author) { field_6_author = author; field_5_hasMultibyte = StringUtil.hasMultibyte(author); } @Override public NoteRecord clone() { NoteRecord rec = new NoteRecord(); rec.field_1_row = field_1_row; rec.field_2_col = field_2_col; rec.field_3_flags = field_3_flags; rec.field_4_shapeid = field_4_shapeid; rec.field_6_author = field_6_author; return rec; } }