| /* ==================================================================== |
| 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.ss.util; |
| |
| import java.io.IOException; |
| import java.util.ArrayList; |
| import java.util.List; |
| import java.util.Map; |
| import java.util.function.Supplier; |
| |
| import org.apache.poi.common.usermodel.GenericRecord; |
| import org.apache.poi.hssf.record.RecordInputStream; |
| import org.apache.poi.util.LittleEndianByteArrayOutputStream; |
| import org.apache.poi.util.LittleEndianOutput; |
| |
| /** |
| * Implementation of the cell range address lists,like is described |
| * in OpenOffice.org's Excel Documentation: excelfileformat.pdf sec 2.5.14 - |
| * 'Cell Range Address List' |
| * |
| * In BIFF8 there is a common way to store absolute cell range address lists in |
| * several records (not formulas). A cell range address list consists of a field |
| * with the number of ranges and the list of the range addresses. Each cell |
| * range address (called an ADDR structure) contains 4 16-bit-values. |
| */ |
| public class CellRangeAddressList implements GenericRecord { |
| |
| /** |
| * List of {@code CellRangeAddress}es. Each structure represents a cell range |
| */ |
| protected final List<CellRangeAddress> _list = new ArrayList<>(); |
| |
| public CellRangeAddressList() { |
| } |
| /** |
| * Convenience constructor for creating a {@code CellRangeAddressList} with a single |
| * {@code CellRangeAddress}. Other {@code CellRangeAddress}es may be added later. |
| */ |
| public CellRangeAddressList(int firstRow, int lastRow, int firstCol, int lastCol) { |
| addCellRangeAddress(firstRow, firstCol, lastRow, lastCol); |
| } |
| /** |
| * @param in the RecordInputstream to read the record from |
| */ |
| public CellRangeAddressList(RecordInputStream in) { |
| int nItems = in.readUShort(); |
| |
| for (int k = 0; k < nItems; k++) { |
| _list.add(new CellRangeAddress(in)); |
| } |
| } |
| /** |
| * Get the number of following ADDR structures. The number of this |
| * structures is automatically set when reading an Excel file and/or |
| * increased when you manually add a new ADDR structure . This is the reason |
| * there isn't a set method for this field . |
| * |
| * @return number of ADDR structures |
| */ |
| public int countRanges() { |
| return _list.size(); |
| } |
| |
| /** |
| * Add a cell range structure. |
| * |
| * @param firstRow - the upper left hand corner's row |
| * @param firstCol - the upper left hand corner's col |
| * @param lastRow - the lower right hand corner's row |
| * @param lastCol - the lower right hand corner's col |
| */ |
| public void addCellRangeAddress(int firstRow, int firstCol, int lastRow, int lastCol) { |
| CellRangeAddress region = new CellRangeAddress(firstRow, lastRow, firstCol, lastCol); |
| addCellRangeAddress(region); |
| } |
| public void addCellRangeAddress(CellRangeAddress cra) { |
| _list.add(cra); |
| } |
| public CellRangeAddress remove(int rangeIndex) { |
| if (_list.isEmpty()) { |
| throw new RuntimeException("List is empty"); |
| } |
| if (rangeIndex < 0 || rangeIndex >= _list.size()) { |
| throw new RuntimeException("Range index (" + rangeIndex |
| + ") is outside allowable range (0.." + (_list.size()-1) + ")"); |
| } |
| return _list.remove(rangeIndex); |
| } |
| |
| /** |
| * @return {@code CellRangeAddress} at the given index |
| */ |
| public CellRangeAddress getCellRangeAddress(int index) { |
| return _list.get(index); |
| } |
| |
| public int getSize() { |
| return getEncodedSize(_list.size()); |
| } |
| /** |
| * @return the total size of for the specified number of ranges, |
| * including the initial 2 byte range count |
| */ |
| public static int getEncodedSize(int numberOfRanges) { |
| return 2 + CellRangeAddress.getEncodedSize(numberOfRanges); |
| } |
| |
| public int serialize(int offset, byte[] data) { |
| int totalSize = getSize(); |
| try (LittleEndianByteArrayOutputStream lebaos = |
| new LittleEndianByteArrayOutputStream(data, offset, totalSize)) { |
| serialize(lebaos); |
| } |
| catch (IOException ioe) { |
| // should never happen in practice |
| throw new IllegalStateException(ioe); |
| } |
| return totalSize; |
| } |
| |
| public void serialize(LittleEndianOutput out) { |
| int nItems = _list.size(); |
| out.writeShort(nItems); |
| for (CellRangeAddress region : _list) { |
| region.serialize(out); |
| } |
| } |
| |
| public CellRangeAddressList copy() { |
| CellRangeAddressList result = new CellRangeAddressList(); |
| for (CellRangeAddress region : _list) { |
| result.addCellRangeAddress(region.copy()); |
| } |
| return result; |
| } |
| public CellRangeAddress[] getCellRangeAddresses() { |
| CellRangeAddress[] result = new CellRangeAddress[_list.size()]; |
| _list.toArray(result); |
| return result; |
| } |
| |
| @Override |
| public Map<String, Supplier<?>> getGenericProperties() { |
| return null; |
| } |
| |
| @Override |
| public List<CellRangeAddress> getGenericChildren() { |
| return _list; |
| } |
| } |