/dports/textproc/p5-Spreadsheet-XLSX/Spreadsheet-XLSX-0.15/lib/Spreadsheet/XLSX/ |
H A D | Fmt2007.pm | 91 my ($oThis, $oCell, $oBook) = @_; 98 if ($oCell->{Type} eq 'Numeric') { 99 if ($oCell->{Format}) { 100 $sFmtStr = $oCell->{Format}; 101 } elsif (int($oCell->{Val}) != $oCell->{Val}) { 106 } elsif ($oCell->{Type} eq 'Date') { 107 if ($oCell->{Format}) { 125 my ($oThis, $oCell, $oBook) = @_; 129 if ($oCell->{Type} eq 'Text') { 130 …$Dt = ((defined $oCell->{Val}) && ($oCell->{Val} ne '')) ? $oThis->TextFmt($oCell->{Val}, $oCell->… [all …]
|
/dports/devel/R-cran-gdata/gdata/inst/perl/Spreadsheet/ParseExcel/ |
H A D | FmtDefault.pm | 103 my ( $oThis, $oCell, $oBook ) = @_; 120 if ( $oCell->{Type} eq 'Numeric' ) { 121 if ( int( $oCell->{Val} ) != $oCell->{Val} ) { 128 elsif ( $oCell->{Type} eq 'Date' ) { 129 if ( int( $oCell->{Val} ) <= 0 ) { 147 my ( $oThis, $oCell, $oBook ) = @_; 151 if ( $oCell->{Type} eq 'Text' ) { 153 ( ( defined $oCell->{Val} ) && ( $oCell->{Val} ne '' ) ) 154 ? $oThis->TextFmt( $oCell->{Val}, $oCell->{Code} ) 160 $Dt = $oCell->{Val}; [all …]
|
/dports/textproc/p5-Spreadsheet-ParseExcel/Spreadsheet-ParseExcel-0.65/lib/Spreadsheet/ParseExcel/ |
H A D | FmtDefault.pm | 103 my ( $oThis, $oCell, $oBook ) = @_; 116 if ( $oCell->{Type} eq 'Numeric' ) { 117 if ( int( $oCell->{Val} ) != $oCell->{Val} ) { 124 elsif ( $oCell->{Type} eq 'Date' ) { 125 if ( int( $oCell->{Val} ) <= 0 ) { 143 my ( $oThis, $oCell, $oBook ) = @_; 147 if ( $oCell->{Type} eq 'Text' ) { 149 ( ( defined $oCell->{Val} ) && ( $oCell->{Val} ne '' ) ) 150 ? $oThis->TextFmt( $oCell->{Val}, $oCell->{Code} ) 156 $Dt = $oCell->{Val}; [all …]
|
/dports/textproc/p5-XML-SAXDriver-Excel/XML-SAXDriver-Excel-0.06/ |
H A D | Excel.pm | 99 my ($self, $oBook, $iSheet, $iRow, $iCol, $oCell) = @_; 127 push(@{$self->{_row}}, $oCell->Value()); 135 push(@{$self->{_row}}, $oCell->Value());# if $flag == 0; 156 …my ($self, $oBook, $iSheet, $iRow, $iCol, $oCell) = @_; ### Remember self is passed through the S… 164 my $temp_row = $oCell->Value();
|
/dports/editors/libreoffice/libreoffice-7.2.6.2/qadevOOo/tests/java/mod/_sc/ |
H A D | ScCellFieldObj.java | 135 XCell oCell = oSheet.getCellByPosition(2,3); in createTestEnvironment() local 136 oText = UnoRuntime.queryInterface(XText.class, oCell); in createTestEnvironment() 143 oCell = oSheet.getCellByPosition(1,4); in createTestEnvironment() 144 oText = UnoRuntime.queryInterface(XText.class, oCell); in createTestEnvironment()
|
H A D | ScAnnotationShapeObj.java | 138 XCell oCell = null; in createTestEnvironment() local 147 oCell = in createTestEnvironment() 152 oCell); in createTestEnvironment()
|
/dports/editors/libreoffice6/libreoffice-6.4.7.2/qadevOOo/tests/java/mod/_sc/ |
H A D | ScCellFieldObj.java | 135 XCell oCell = oSheet.getCellByPosition(2,3); in createTestEnvironment() local 136 oText = UnoRuntime.queryInterface(XText.class, oCell); in createTestEnvironment() 143 oCell = oSheet.getCellByPosition(1,4); in createTestEnvironment() 144 oText = UnoRuntime.queryInterface(XText.class, oCell); in createTestEnvironment()
|
H A D | ScAnnotationShapeObj.java | 138 XCell oCell = null; in createTestEnvironment() local 147 oCell = in createTestEnvironment() 152 oCell); in createTestEnvironment()
|
/dports/devel/R-cran-gdata/gdata/inst/perl/Spreadsheet/ParseExcel/SaveParser/ |
H A D | Worksheet.pm | 38 my ( $oSelf, $iR, $iC, $sVal, $oCell, $sCode ) = @_; 41 ->AddCell( $oSelf->{_SheetNo}, $iR, $iC, $sVal, $oCell, $sCode );
|
H A D | Workbook.pm | 387 my ( $oBook, $iSheet, $iR, $iC, $sVal, $oCell, $sCode ) = @_; 389 $oCell ||= $oBook->{Worksheet}[$iSheet] 392 ( UNIVERSAL::isa( $oCell, 'Spreadsheet::ParseExcel::Cell' ) ) 393 ? $oCell->{FormatNo} 394 : ( ref($oCell) ) ? 0 395 : $oCell + 0;
|
/dports/textproc/p5-Spreadsheet-ParseExcel/Spreadsheet-ParseExcel-0.65/lib/Spreadsheet/ParseExcel/SaveParser/ |
H A D | Worksheet.pm | 38 my ( $oSelf, $iR, $iC, $sVal, $oCell, $sCode ) = @_; 41 ->AddCell( $oSelf->{_SheetNo}, $iR, $iC, $sVal, $oCell, $sCode );
|
H A D | Workbook.pm | 387 my ( $oBook, $iSheet, $iR, $iC, $sVal, $oCell, $sCode ) = @_; 389 $oCell ||= $oBook->{Worksheet}[$iSheet] 392 ( UNIVERSAL::isa( $oCell, 'Spreadsheet::ParseExcel::Cell' ) ) 393 ? $oCell->{FormatNo} 394 : ( ref($oCell) ) ? 0 395 : $oCell + 0;
|
/dports/textproc/p5-Spreadsheet-ParseExcel/Spreadsheet-ParseExcel-0.65/sample/ |
H A D | Ilya.pl | 10 my($self, $oBook, $iSheet, $iRow, $iCol, $oCell) = @_; 11 print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
|
H A D | dmpExH.pl | 11 my ($oBook, $iSheet, $iRow, $iCol, $oCell) = @_; 23 print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
|
H A D | dmpExHJ.pl | 12 my ($oBook, $iSheet, $iRow, $iCol, $oCell) = @_; 24 print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
|
/dports/editors/lazarus-devel/lazarus-6df7e8756882f7d7f28f662011ee72f21746c580/components/fpvectorial/ |
H A D | docxvectorialwriter.pas | 870 oCell: TvTableCell; 949 oCell := oRow.GetCell(j); 958 AddTableBorderProperty('w:left', oCell.Borders.Left); 959 AddTableBorderProperty('w:right', oCell.Borders.Right); 960 AddTableBorderProperty('w:top', oCell.Borders.Top); 961 AddTableBorderProperty('w:bottom', oCell.Borders.Bottom); 968 If oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 970 [FPColorToRGBHexString(oCell.BackgroundColor)])) 976 If oCell.PreferredWidth.Value <> 0 Then 977 oDocXML.Add(Format('<w:tcW %s />', [DimAttribs(oCell.PreferredWidth)])) [all …]
|
H A D | odtvectorialwriter.pas | 1500 oCell: TvTableCell; 1619 oCell := oRow.GetCell(iCell); 1635 If oCell.VerticalAlignment<>vaTop Then 1636 sTemp := sTemp + ' style:vertical-align="'+LU_V_ALIGN[oCell.VerticalAlignment]+'"'; 1638 if oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 1641 sTemp := sTemp + ' ' + BordersToString(ATable.Borders, oCell.Borders, 1647 If oCell.SpannedCols>1 Then 1648 sTemp2 := 'table:number-columns-spanned="'+IntToStr(oCell.SpannedCols)+'" '; 1666 for k := 0 to oCell.GetEntitiesCount()-1 do 1668 lCurEntity := oCell.GetEntity(k); [all …]
|
/dports/editors/lazarus-qt5/lazarus/components/fpvectorial/ |
H A D | docxvectorialwriter.pas | 870 oCell: TvTableCell; 949 oCell := oRow.GetCell(j); 958 AddTableBorderProperty('w:left', oCell.Borders.Left); 959 AddTableBorderProperty('w:right', oCell.Borders.Right); 960 AddTableBorderProperty('w:top', oCell.Borders.Top); 961 AddTableBorderProperty('w:bottom', oCell.Borders.Bottom); 968 If oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 970 [FPColorToRGBHexString(oCell.BackgroundColor)])) 976 If oCell.PreferredWidth.Value <> 0 Then 977 oDocXML.Add(Format('<w:tcW %s />', [DimAttribs(oCell.PreferredWidth)])) [all …]
|
H A D | odtvectorialwriter.pas | 1457 oCell: TvTableCell; 1576 oCell := oRow.GetCell(iCell); 1592 If oCell.VerticalAlignment<>vaTop Then 1593 sTemp := sTemp + ' style:vertical-align="'+LU_V_ALIGN[oCell.VerticalAlignment]+'"'; 1595 if oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 1598 sTemp := sTemp + ' ' + BordersToString(ATable.Borders, oCell.Borders, 1604 If oCell.SpannedCols>1 Then 1605 sTemp2 := 'table:number-columns-spanned="'+IntToStr(oCell.SpannedCols)+'" '; 1623 for k := 0 to oCell.GetEntitiesCount()-1 do 1625 lCurEntity := oCell.GetEntity(k); [all …]
|
/dports/editors/lazarus/lazarus/components/fpvectorial/ |
H A D | docxvectorialwriter.pas | 870 oCell: TvTableCell; 949 oCell := oRow.GetCell(j); 958 AddTableBorderProperty('w:left', oCell.Borders.Left); 959 AddTableBorderProperty('w:right', oCell.Borders.Right); 960 AddTableBorderProperty('w:top', oCell.Borders.Top); 961 AddTableBorderProperty('w:bottom', oCell.Borders.Bottom); 968 If oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 970 [FPColorToRGBHexString(oCell.BackgroundColor)])) 976 If oCell.PreferredWidth.Value <> 0 Then 977 oDocXML.Add(Format('<w:tcW %s />', [DimAttribs(oCell.PreferredWidth)])) [all …]
|
H A D | odtvectorialwriter.pas | 1457 oCell: TvTableCell; 1576 oCell := oRow.GetCell(iCell); 1592 If oCell.VerticalAlignment<>vaTop Then 1593 sTemp := sTemp + ' style:vertical-align="'+LU_V_ALIGN[oCell.VerticalAlignment]+'"'; 1595 if oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 1598 sTemp := sTemp + ' ' + BordersToString(ATable.Borders, oCell.Borders, 1604 If oCell.SpannedCols>1 Then 1605 sTemp2 := 'table:number-columns-spanned="'+IntToStr(oCell.SpannedCols)+'" '; 1623 for k := 0 to oCell.GetEntitiesCount()-1 do 1625 lCurEntity := oCell.GetEntity(k); [all …]
|
/dports/editors/lazarus-qt5-devel/lazarus-6df7e8756882f7d7f28f662011ee72f21746c580/components/fpvectorial/ |
H A D | docxvectorialwriter.pas | 870 oCell: TvTableCell; 949 oCell := oRow.GetCell(j); 958 AddTableBorderProperty('w:left', oCell.Borders.Left); 959 AddTableBorderProperty('w:right', oCell.Borders.Right); 960 AddTableBorderProperty('w:top', oCell.Borders.Top); 961 AddTableBorderProperty('w:bottom', oCell.Borders.Bottom); 968 If oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 970 [FPColorToRGBHexString(oCell.BackgroundColor)])) 976 If oCell.PreferredWidth.Value <> 0 Then 977 oDocXML.Add(Format('<w:tcW %s />', [DimAttribs(oCell.PreferredWidth)])) [all …]
|
H A D | odtvectorialwriter.pas | 1500 oCell: TvTableCell; 1619 oCell := oRow.GetCell(iCell); 1635 If oCell.VerticalAlignment<>vaTop Then 1636 sTemp := sTemp + ' style:vertical-align="'+LU_V_ALIGN[oCell.VerticalAlignment]+'"'; 1638 if oCell.BackgroundColor <> FPColor(0, 0, 0, 0) Then 1641 sTemp := sTemp + ' ' + BordersToString(ATable.Borders, oCell.Borders, 1647 If oCell.SpannedCols>1 Then 1648 sTemp2 := 'table:number-columns-spanned="'+IntToStr(oCell.SpannedCols)+'" '; 1666 for k := 0 to oCell.GetEntitiesCount()-1 do 1668 lCurEntity := oCell.GetEntity(k); [all …]
|
/dports/editors/libreoffice/libreoffice-7.2.6.2/qadevOOo/tests/java/mod/_sw/ |
H A D | SwXTableCellText.java | 122 XCell oCell = oTable.getCellByName("A1"); in createTestEnvironment() local 123 XSimpleText oCellText = UnoRuntime.queryInterface(XSimpleText.class, oCell); in createTestEnvironment()
|
/dports/editors/libreoffice6/libreoffice-6.4.7.2/qadevOOo/tests/java/mod/_sw/ |
H A D | SwXTableCellText.java | 122 XCell oCell = oTable.getCellByName("A1"); in createTestEnvironment() local 123 XSimpleText oCellText = UnoRuntime.queryInterface(XSimpleText.class, oCell); in createTestEnvironment()
|