Package org.apache.poi.hssf.record

Examples of org.apache.poi.hssf.record.WSBoolRecord

637
638
639
640
641
642
643
644
645
646
     * @param b  whether to show auto page breaks
     */

    public void setAutobreaks(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setAutobreaks(b);
    }
View Full Code Here
650
651
652
653
654
655
656
657
658
659
     * @param b  isDialog or not
     */

    public void setDialog(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setDialog(b);
    }
View Full Code Here
664
665
666
667
668
669
670
671
672
673
     * @param b  guts or no guts (or glory)
     */

    public void setDisplayGuts(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setDisplayGuts(b);
    }
View Full Code Here
677
678
679
680
681
682
683
684
685
686
     * @param b  fit or not
     */

    public void setFitToPage(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setFitToPage(b);
    }
View Full Code Here
690
691
692
693
694
695
696
697
698
699
     * @param b  below or not
     */

    public void setRowSumsBelow(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setRowSumsBelow(b);
    }
View Full Code Here
703
704
705
706
707
708
709
710
711
712
     * @param b  right or not
     */

    public void setRowSumsRight(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setRowSumsRight(b);
    }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
    public void testWSBool()
    {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet s = wb.createSheet();
        Sheet sheet = s.getSheet();
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        // Check defaults
        assertEquals(true, record.getAlternateExpression());
        assertEquals(true, record.getAlternateFormula());
        assertEquals(false, record.getAutobreaks());
        assertEquals(false, record.getDialog());
        assertEquals(false, record.getDisplayGuts());
        assertEquals(true, record.getFitToPage());
        assertEquals(false, record.getRowSumsBelow());
        assertEquals(false, record.getRowSumsRight());

        // Alter
        s.setAlternativeExpression(false);
        s.setAlternativeFormula(false);
        s.setAutobreaks(true);
        s.setDialog(true);
        s.setDisplayGuts(true);
        s.setFitToPage(false);
        s.setRowSumsBelow(true);
        s.setRowSumsRight(true);

        // Check
        assertEquals(false, record.getAlternateExpression());
        assertEquals(false, record.getAlternateFormula());
        assertEquals(true, record.getAutobreaks());
        assertEquals(true, record.getDialog());
        assertEquals(true, record.getDisplayGuts());
        assertEquals(false, record.getFitToPage());
        assertEquals(true, record.getRowSumsBelow());
        assertEquals(true, record.getRowSumsRight());
        assertEquals(false, s.getAlternateExpression());
        assertEquals(false, s.getAlternateFormula());
        assertEquals(true, s.getAutobreaks());
        assertEquals(true, s.getDialog());
        assertEquals(true, s.getDisplayGuts());
View Full Code Here
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
   */
  public void testWSBool() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet s = wb.createSheet();
    Sheet sheet = s.getSheet();
    WSBoolRecord record =
        (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

    // Check defaults
    assertEquals(true, record.getAlternateExpression());
    assertEquals(true, record.getAlternateFormula());
    assertEquals(false, record.getAutobreaks());
    assertEquals(false, record.getDialog());
    assertEquals(false, record.getDisplayGuts());
    assertEquals(true, record.getFitToPage());
    assertEquals(false, record.getRowSumsBelow());
    assertEquals(false, record.getRowSumsRight());

    // Alter
    s.setAlternativeExpression(false);
    s.setAlternativeFormula(false);
    s.setAutobreaks(true);
    s.setDialog(true);
    s.setDisplayGuts(true);
    s.setFitToPage(false);
    s.setRowSumsBelow(true);
    s.setRowSumsRight(true);

    // Check
    assertEquals(false, record.getAlternateExpression());
    assertEquals(false, record.getAlternateFormula());
    assertEquals(true, record.getAutobreaks());
    assertEquals(true, record.getDialog());
    assertEquals(true, record.getDisplayGuts());
    assertEquals(false, record.getFitToPage());
    assertEquals(true, record.getRowSumsBelow());
    assertEquals(true, record.getRowSumsRight());
    assertEquals(false, s.getAlternateExpression());
    assertEquals(false, s.getAlternateFormula());
    assertEquals(true, s.getAutobreaks());
    assertEquals(true, s.getDialog());
    assertEquals(true, s.getDisplayGuts());
View Full Code Here
611
612
613
614
615
616
617
618
619
620
     * @param b  alternative expression evaluation or not
     */

    public void setAlternativeExpression(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setAlternateExpression(b);
    }
View Full Code Here
624
625
626
627
628
629
630
631
632
633
     * @param b  alternative formulas or not
     */

    public void setAlternativeFormula(boolean b)
    {
        WSBoolRecord record =
                (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid);

        record.setAlternateFormula(b);
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.hssf.record.WSBoolRecord

  • org.apache.poi.hssf.model.InternalSheet
  • org.apache.poi.hssf.model.Sheet
  • org.apache.poi.hssf.usermodel.HSSFSheet
  • org.apache.poi.hssf.usermodel.TestHSSFSheet
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.