ASF Bugzilla – Attachment 1590 Details for
Bug 8114
[PATCH] Named Ranges
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
[patch]
org\apache\poi\hssf\record\formula
Ref3DPtg.java (text/plain), 6.12 KB, created by
Libin Roman
on 2002-04-15 15:57:30 UTC
(
hide
)
Description:
org\apache\poi\hssf\record\formula
Filename:
MIME Type:
Creator:
Libin Roman
Created:
2002-04-15 15:57:30 UTC
Size:
6.12 KB
patch
obsolete
> >/* ==================================================================== > * The Apache Software License, Version 1.1 > * > * Copyright (c) 2002 The Apache Software Foundation. All rights > * reserved. > * > * Redistribution and use in source and binary forms, with or without > * modification, are permitted provided that the following conditions > * are met: > * > * 1. Redistributions of source code must retain the above copyright > * notice, this list of conditions and the following disclaimer. > * > * 2. Redistributions in binary form must reproduce the above copyright > * notice, this list of conditions and the following disclaimer in > * the documentation and/or other materials provided with the > * distribution. > * > * 3. The end-user documentation included with the redistribution, > * if any, must include the following acknowledgment: > * "This product includes software developed by the > * Apache Software Foundation (http://www.apache.org/)." > * Alternately, this acknowledgment may appear in the software itself, > * if and wherever such third-party acknowledgments normally appear. > * > * 4. The names "Apache" and "Apache Software Foundation" and > * "Apache POI" must not be used to endorse or promote products > * derived from this software without prior written permission. For > * written permission, please contact apache@apache.org. > * > * 5. Products derived from this software may not be called "Apache", > * "Apache POI", nor may "Apache" appear in their name, without > * prior written permission of the Apache Software Foundation. > * > * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED > * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES > * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE > * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR > * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, > * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT > * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF > * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND > * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, > * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT > * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF > * SUCH DAMAGE. > * ==================================================================== > * > * This software consists of voluntary contributions made by many > * individuals on behalf of the Apache Software Foundation. For more > * information on the Apache Software Foundation, please see > * <http://www.apache.org/>. > */ > >package org.apache.poi.hssf.record.formula; > >import org.apache.poi.util.LittleEndian; >import org.apache.poi.hssf.util.RangeAddress; > >/** > * Title: Reference 3D Ptg <P> > * Description: Defined a cell in extern sheet. <P> > * REFERENCE: <P> > * @author Libin Roman (Vista Portal LDT. Developer) > * @version 1.0-pre > */ > >public class Ref3DPtg extends Ptg { > public final static short sid = 0x3a; > private final static int SIZE = 7; // 6 + 1 for Ptg > private short field_1_index_extern_sheet; > private short field_2_row; > private short field_3_column; > > /** Creates new AreaPtg */ > > public Ref3DPtg() { > } > > public Ref3DPtg(byte[] data, int offset) { > offset++; > field_1_index_extern_sheet = LittleEndian.getShort(data, 0 + offset); > field_2_row = LittleEndian.getShort(data, 2 + offset); > field_3_column = LittleEndian.getShort(data, 4 + offset); > } > > public String toString() { > StringBuffer buffer = new StringBuffer(); > > buffer.append("Ref3dPrg\n"); > buffer.append("Index to Extern Sheet = " + getExternSheetIndex()).append("\n"); > buffer.append("Row = " + getRow()).append("\n"); > buffer.append("Col = " + getColumn()).append("\n"); > buffer.append("ColRowRel= " > + isColRowRelative()).append("\n"); > buffer.append("ColRel = " + isColRelative()).append("\n"); > return buffer.toString(); > } > > public void writeBytes(byte [] array, int offset) { > array[ 0 + offset ] = sid; > LittleEndian.putShort(array, 1 + offset , getExternSheetIndex()); > LittleEndian.putShort(array, 3 + offset , getRow()); > LittleEndian.putShort(array, 5 + offset , getColumnRaw()); > } > > public int getSize() { > return SIZE; > } > > public short getExternSheetIndex(){ > return field_1_index_extern_sheet; > } > > public void setExternSheetIndex(short index){ > field_1_index_extern_sheet = index; > } > > public short getRow() { > return field_2_row; > } > > public void setRow(short row) { > field_2_row = row; > } > > public short getColumn() { > return ( short ) (field_3_column & 0xFF); > } > > public short getColumnRaw() { > return field_3_column; > } > > public boolean isColRowRelative() { > return (((getColumnRaw()) & 0x8000) == 0x8000); > } > > public boolean isColRelative() { > return (((getColumnRaw()) & 0x4000) == 0x4000); > } > > public void setColumn(short column) { > field_3_column &= 0xFF00; > field_3_column |= column & 0xFF; > } > > public void setColumnRaw(short column) { > field_3_column = column; > } > > public String getArea(){ > RangeAddress ra = new RangeAddress(""); > > String result = (ra.numTo26Sys(getColumn()) + (getRow() + 1)); > > return result; > } > > public void setArea(String ref){ > RangeAddress ra = new RangeAddress(ref); > > String from = ra.getFromCell(); > > setColumn((short) (ra.getXPosition(from) -1)); > setRow((short) (ra.getYPosition(from) -1)); > > } > > public String toFormulaString() { > String result = getArea(); > > return result; > } > >}
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 8114
:
1581
|
1582
|
1583
|
1584
|
1585
|
1586
|
1587
|
1588
|
1589
| 1590 |
1591
|
1592
|
1597
|
1610
|
1647
|
1649
|
1650
|
1662
|
1663