Home
last modified time | relevance | path

Searched refs:oCell (Results 1 – 25 of 39) sorted by relevance

12

/dports/textproc/p5-Spreadsheet-XLSX/Spreadsheet-XLSX-0.15/lib/Spreadsheet/XLSX/
H A DFmt2007.pm91 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 DFmtDefault.pm103 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 DFmtDefault.pm103 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 DExcel.pm99 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 DScCellFieldObj.java135 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 DScAnnotationShapeObj.java138 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 DScCellFieldObj.java135 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 DScAnnotationShapeObj.java138 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 DWorksheet.pm38 my ( $oSelf, $iR, $iC, $sVal, $oCell, $sCode ) = @_;
41 ->AddCell( $oSelf->{_SheetNo}, $iR, $iC, $sVal, $oCell, $sCode );
H A DWorkbook.pm387 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 DWorksheet.pm38 my ( $oSelf, $iR, $iC, $sVal, $oCell, $sCode ) = @_;
41 ->AddCell( $oSelf->{_SheetNo}, $iR, $iC, $sVal, $oCell, $sCode );
H A DWorkbook.pm387 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 DIlya.pl10 my($self, $oBook, $iSheet, $iRow, $iCol, $oCell) = @_;
11 print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
H A DdmpExH.pl11 my ($oBook, $iSheet, $iRow, $iCol, $oCell) = @_;
23 print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
H A DdmpExHJ.pl12 my ($oBook, $iSheet, $iRow, $iCol, $oCell) = @_;
24 print "( $iRow , $iCol ) =>", $oCell->Value, "\n";
/dports/editors/lazarus-devel/lazarus-6df7e8756882f7d7f28f662011ee72f21746c580/components/fpvectorial/
H A Ddocxvectorialwriter.pas870 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 Dodtvectorialwriter.pas1500 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 Ddocxvectorialwriter.pas870 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 Dodtvectorialwriter.pas1457 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 Ddocxvectorialwriter.pas870 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 Dodtvectorialwriter.pas1457 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 Ddocxvectorialwriter.pas870 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 Dodtvectorialwriter.pas1500 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 DSwXTableCellText.java122 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 DSwXTableCellText.java122 XCell oCell = oTable.getCellByName("A1"); in createTestEnvironment() local
123 XSimpleText oCellText = UnoRuntime.queryInterface(XSimpleText.class, oCell); in createTestEnvironment()

12