how to show pdf file in asp.net c#: How to search a pdf document for text Library software class asp.net winforms wpf ajax VbaStarBasicXref2-part1896

Examples of Porting Visual Basic for Applications to StarBasic

Print the address of a cell or range of cells on the ActiveSheet

VBA Sub MyProc

'Following will display $B$3

msgbox Range("B3").Address

'Following will display $B$3:$D$5

msgbox Range("B3:D5").Address

'Cell B5 is named "MyCell", following will display $B$5

msgbox Range("MyCell").Address

End Sub

''This code fragment makes use of a user defined function

'''CellRangeAddressString() documented in Appendix B.

Sub MyProc

Dim oSheet as Object

oSheet = ThisComponent.CurrentController.ActiveSheet

'Following will display $B$3

msgbox CellRangeAddressString( _

oSheet.getCellRangeByName("B3"))

'Following will display $B$3:$D$5

msgbox CellRangeAddressString( _

oSheet.getCellRangeByName("B3:D5"))

'Cell B5 is named "MyCell", following will display $B$5

msgbox CellRangeAddressString( _

oSheet.getCellRangeByName("MyCell")

'following will display $D$7

msgbox CellRangeAddressString( _

oSheet.getCellByPosition(3,6))

End Sub

Usage Note: After some time spent researching and experimentation, the approach of

using the Calc sheet function "ADDRESS()" was selected. It may be possible that a

method or property exists in the UNO object model to obtain a string representation of

the address of a cell or range of cells but it is not clear as of this writing.

Porting Excel/VBA to Calc/StarBasic

How to search a pdf document for text - search text inside PDF file in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF

Learn how to search text in PDF document and obtain text content and location information

search pdf files for text programmatically; select text in pdf reader

How to search a pdf document for text - VB.NET PDF Text Search Library: search text inside PDF file in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF

Learn How to Search Text in PDF Document and Obtain Text Content and Location Information in VB.NET application

how to search a pdf document for text; find text in pdf image

Examples of Porting Visual Basic for Applications to StarBasic

Find the cell at the end of a row or column of data in a worksheet [sheet]. Assume all the

cells in range B3:E15 contains data. This does not depend on knowing the actual number

of rows or columns in the data range.

VBA Sub MyProc

'go to upper left corner of range

Range("B3").Select

'Find the last cell in the current row of data

'This takes the cursor to cell E3

Selection.end(xlToRight).Select

'Find the last cell in the column

'this takes the cursor to cell E15

Selection.end(xlDown).Selection

'Find the first cell in the current row

'this takes the cursor to cell B15

Selection.end(xlToLeft).Select

'Find first cell in the current column

'this takes the cursor to cell B3

Selection.end(xlUp).Select

End Sub

Porting Excel/VBA to Calc/StarBasic

C# Word - Search and Find Text in Word

C# Word - Search and Find Text in Word. Learn How to Search Text in PDF Document and Obtain Text Content and Location Information. Overview.

search pdf files for text; make pdf text searchable

C# PowerPoint - Search and Find Text in PowerPoint

C# PowerPoint - Search and Find Text in PowerPoint. Learn How to Search Text in PDF Document and Obtain Text Content and Location Information. Overview.

converting pdf to searchable text format; text searchable pdf file

Examples of Porting Visual Basic for Applications to StarBasic

'''This code fragment makes use of a user defined function

'''MoveCursorToEnd() documented in Appendix B.

Sub MyProc

Dim oSheet as Object, oCell as Object

'''get some useful objects

oSheet = ThisComponent.CurrentController.ActiveSheet

'''go to upper slef corner of range

oCell = oSheet.getCellRangeByName("B3")

ThisComponent.CurrentController.select(oCell)

'Find the last cell in the current row

'this takes cursor to cell E3

oCell = MoveCursorToEnd(oCell,"xlToRight")

ThisComponent.CurrentController.select(oCell)

'Find last (bottom) cell in the current column

'This takes cursor to cell E15

oCell = MoveCursorToEnd(oCell,"xlDown")

ThisComponent.CurrentController.select(oCell)

'Find first cell in the current row

'This takes cursor to cell B15

oCell = MoveCursorToEnd(oCell,"xlToLeft")

ThisComponent.CurrentController.select(oCell)

'Find first (top) cell in the current column

'This takes cursor to cell B3

oCell = MoveCursorToEnd(oCell,"xlUp")

ThisComponent.CurrentController.select(oCell)

End Sub

Clear the contents in the range of cells on the ActiveSheet. This does not affect any

formatting of the cells.

VBA

Range("B1:E5").ClearContents

ThisComponent.CurrentController.ActiveSheet.getCellByName

("B1:E5").clearContents( _

com.sun.star.sheet.CellFlags.VALUE _

+com.sun.star.sheet.CellFlags.STRING _

+com.sun.star.sheet.CellFlags.DATETIME)

Reference:

http://api.openoffice.org/docs/DevelopersGuide/Spreadsheet/Spreadsheet.htm#1+3+1+4+8+Operations

http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XSheetOperation.html#clearContents

and

http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/CellFlags.html

Porting Excel/VBA to Calc/StarBasic

C# PDF delete text Library: delete, remove text from PDF file in

The following C# coding example illustrates how to perform PDF text deleting function in your .NET project, according to search option. // Open a document.

how to select all text in pdf file; pdf searchable text converter

C# PDF replace text Library: replace text in PDF content in C#.net

The following C# coding example illustrates how to perform PDF text replacing function in your .NET project, according to search option. // Open a document.

pdf editor with search and replace text; select text in pdf

Examples of Porting Visual Basic for Applications to StarBasic

Clear a range of cells on the worksheet [sheet] "MySheet". This clears everything

associated with the cell including formatting.

VBA Worksheets("MySheet").Range("B1:E5").Clear

ThisComponent.Sheets.getByName("MySheet").getCellRangeByName

("B1:E5").clearContents( _

com.sun.star.sheet.CellFlags.VALUE _

+ com.sun.star.sheet.CellFlags.STRING _

+ com.sun.star.sheet.CellFlags.DATETIME _

+ com.sun.star.sheet.CellFlags.ANNOTATION _

+ com.sun.star.sheet.CellFlags.FORMULA _

+ com.sun.star.sheet.CellFlags.HARDATTR _

+ com.sun.star.sheet.CellFlags.STYLES _

+ com.sun.star.sheet.CellFlags.OBJECTS _

+ com.sun.star.sheet.CellFlags.EDITATTR)

Assign a user defined name "MyCells" to the cells B2:C3 via the Excel [Calc] user

interface

Excel

One of two methods:

1) Highlight cells B2:C3, select the tool bar options: Insert > Name > Define ,

enter name "MyCells" in pop-up window and press "Add" button.

2) Highlight cells B2:C3, then enter "MyCells" in the Name Field on the

active window.

Calc

One of two methods:

1) Highlight cells B2:C3, select the tool bar options: Insert > Names >

Define, enter name "MyCells" in pop-up window and press "Add" button.

2) Highlight cells B2:C3, press Ctrl-F3, enter name "MyCells" in pop-up

window and press "Add" button.

Assign a user defined name "MyCells" to the cells B2:C3 on "Sheet1" and the same name

to cells A1:B3 on "Sheet2" via the Excel [Calc] user interface

Excel

Select "Sheet1" and highlight cells B2:C3 then do one of the following:

1) Select the tool bar options: Insert > Name > Define , enter name

"Sheet1!MyCells" in pop-up window and press "Add" button.

2) Enter "Sheet1!MyCells" in the Name Field on the active window.

Select "Sheet2" and highlight cells A1:B3 then repeat either steps 1 or 2 from

above only this time use the name "Sheet2!MyCells".

Calc

It is not possible. Calc appears not to allow the same range name, e.g.

"MyCells", to exist on two or more worksheets [sheets].

Porting Excel/VBA to Calc/StarBasic

C# HTML5 PDF Viewer SDK to view PDF document online in C#.NET

Easy to search PDF text in whole PDF document. C# HTML5 PDF Viewer: View PDF Online. 13. Page Thumbnails. Navigate PDF document with thumbnails. 14. Text Search.

how to search text in pdf document; pdf search and replace text

VB.NET PDF replace text library: replace text in PDF content in vb

will guide you how to replace text in specified PDF page. 'Open a document Dim doc As PDFDocument = New PDFDocument(inputFilePath) 'Set the search options Dim

text select tool pdf; pdf text select tool

Examples of Porting Visual Basic for Applications to StarBasic

Access ranges with the same name relative to worksheets [sheets]. Assume in worksheet

[sheet] "Sheet1" cell B1 is named "MyCell" and contains the string "Sheet1MyCell". In

worksheet [sheet] "Sheet2" cell C3 is named "MyCell" and contains the string

"Sheet2MyCell".

VBA Rem The following will display "Sheet1MyCell"

Rem followed by "Sheet2MyCell"

Worksheets("Sheet1").Activate

MsgBox Range("MyCell").Value

Worksheets("Sheet2").Activate

MsgBox Range("MyCell").Value

It is not possible. Calc appears not to allow the same range name, e.g.

"MyCell", to exist on two or more worksheets [sheets].

Charts/Chart

Create a bar chart on the current worksheet [sheet] using the range "MyChartData".

VBA Sub SomeProcedure

Range("MyChartData").Select

Charts.Add

ActiveChart.ChartType = xlColumnClustered

ActiveChart.Name = "Sample Chart"

ActiveChart.SetSourceData _

Source:=Sheets("Example3").Range("ChartData"), _

PlotBy:= xlColumns

ActiveChart.Location Where:=xlLocationAsObject, _

Name:="Example3"

With ActiveChart

.HasTitle = True

.HasLegend = False

.ChartTitle.Characters.Text = "Sample Chart"

.Axes(xlCategory, xlPrimary).HasTitle = True

.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text =

"Category"

.Axes(xlValue, xlPrimary).HasTitle = True

.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text =

"Amount"

End With

End Sub

Porting Excel/VBA to Calc/StarBasic

VB.NET PDF- View PDF Online with VB.NET HTML5 PDF Viewer

Easy to search PDF text in whole PDF document. VB.NET HTML5 PDF Viewer: View PDF Online. 13. Page Thumbnails. Navigate PDF document with thumbnails. 14. Text Search

how to select text in pdf reader; how to make a pdf document text searchable

C# PDF Text Highlight Library: add, delete, update PDF text

The following C# coding example illustrates how to perform PDF text highlight function in your .NET project, according to search option. // Open a document.

how to make pdf text searchable; find and replace text in pdf file

Examples of Porting Visual Basic for Applications to StarBasic

Sub SomeProcedure

'define rectangle to hold chart

Dim aRect as new com.sun.star.awt.Rectangle

with aRect

.X = 8000 : .Y = 1000 : .Width = 16000 : .Height = 10000

end with

' Now add a chart to the spreadsheet.

'get data to chart

oSheet = ThisComponent.CurrentController.ActiveSheet

oCellRangeAddress = _

oSheet.getCellRangeByName( "MyChartData" ). _

getRangeAddress()

' Get the collection of charts from the sheet

oCharts = oSheet.getCharts()

' Add a new chart with a specific name,

' in a specific rectangle on the drawing page,

' and connected to specific cells of the spreadsheet.

oCharts.addNewByName( "Sample Chart", aRect , _

Array( oCellRangeAddress ) , True, True )

' Get the new chart we just created.

oChart = oCharts.getByName( "Sample Chart" )

' Get the chart document model.

oChartDoc = oChart.getEmbeddedObject()

oChartDoc.HasLegend = False

' Get the drawing text shape of the title of the chart.

oChartDoc.getTitle().String = "Sample Chart" 'Change title

' Create a diagram.

oDiagram = _

oChartDoc.createInstance("com.sun.star.chart.BarDiagram")

' Set its parameters.

oDiagram.Vertical = True

' Make the chart use this diagram.

oChartDoc.setDiagram( oDiagram )

oDiagram.getXAxisTitle().String = "Category"

oDiagram.HasXAxisTitle = true

oDiagram.getYAxisTitle().String = "Amount"

oDiagram.HasYAxisTitle = true

' Make more changes to the diagram.

oDiagram.DataRowSource = _

com.sun.star.chart.ChartDataRowSource.COLUMNS

End Sub

Reference: http://api.openoffice.org/docs/DevelopersGuide/Charts/Charts.htm#1+Charts

Porting Excel/VBA to Calc/StarBasic

Examples of Porting Visual Basic for Applications to StarBasic

Delete the chart created in the preceding example.

VBA Sub MyProc

ActiveSheet.Charts("Sample Chart").Delete

End Sub

Sub MyProc

ThisComponent.CurrentController.ActiveSheet. _

getCharts().removeByName("Sample Chart")

End Sub

Porting Excel/VBA to Calc/StarBasic

Examples of Porting Visual Basic for Applications to StarBasic

Controls

This section describes placing controls, such as check boxes, option buttons, combo boxes,

on a worksheet [sheet].

Create a control (Check Box, Combo Box, Option Button, Button, etc.) on the worksheet

[sheet] and give the control a user defined name.

Excel

•

Drag and drop the controls from the Controls menu onto the worksheet

•

Select the control on the worksheet and press right mouse button

•

Select "Properties" option

•

Enter user defined name into the "(Name)" property

Calc

•

Drag and drop the controls from the Forms Function menu onto the sheet

•

Select the control on the sheet and press right mouse button

•

Select the "Control..." option

•

Select the "General" tab and enter user defined name into the "Name"

property

Usage Note: The Name property for option buttons in Calc is used to group option

buttons for selecting one and only one option from a group of options, radio button

operation. This same function in Excel is accomplished by assigning the same value to

the Group property of the option buttons.

Reference: OpenOffice Calc Help

Turn on/off Design Mode

Excel

Press Design Mode icon on Controls menu to toggle on/off

Calc

Press Design Mode icon on the Form Functions menu to toggle on/off

Reference: OpenOffice Calc Help

Porting Excel/VBA to Calc/StarBasic

Examples of Porting Visual Basic for Applications to StarBasic

Assign a worksheet [sheet] cell to hold current state of the control, i.e., is the check box

checked or unchecked, selected item in a combo box.

Excel

•

Turn Design Mode on

•

Select the control on the workhseet and press right mouse button

•

Select Properties option

•

In the property LinkedCell enter a worksheet cell address (e.g., B4, $B$4)

or a user defined named range (e.g., "MyControlState")

Calc

•

Turn Design Mode on

•

Select the control on the sheet and press right mouse button

•

Select the Control... option

•

Select Data tab and enter sheet cell address (e.g.,B4) into the Linked

Cell.... property.

Usage Note: Unable to use named ranges (e.g., "MyControlState") to specify a cell

location in Calc.

Assign to a list box or combo box the cell range on the worksheet [sheet] that holds the

list of items to display.

Excel

•

Turn Design Mode on

•

Select the control on the workhseet and press right mouse button

•

Select "Properties" option

•

In the property "ListFillRange" enter a worksheet cell address (e.g., B4:B6,

$B$4:$B$6) or a user defined named range (e.g., "MyListOfChoices")

Calc

•

Turn Design Mode on

•

Select the control on the sheet and press right mouse button

•

Select the "Control..." option

•

Select "Data" tab and enter sheet cell address (e.g.,B4:B6) into the "Source

Cell Range...." property.

Assign multi-line caption to a button control

Excel

•

Select button control on worksheet

•

Click right mouse button

•

Properties > Word Warp > True

Calc

Not supported

Porting Excel/VBA to Calc/StarBasic

Examples of Porting Visual Basic for Applications to StarBasic

UserForms

Create a UserForm [Dialog] "MyForm"

VBA

•

Start the Visual Basic IDE

•

Select from the tool bar Insert > UserForm

•

Select UserForm object

•

Right-click mouse button on selected UserForm object

•

Click on the Properties option

•

Enter "MyForm" in the (Name) attribute

•

Design the layout of the UserForm

•

Start the StarBasic IDE

•

Press Organizer button

•

Press New Dialog... button

•

Enter "MyForm" in the name menu for new dialog panel and press "OK"

button

•

Select the new dialog just created with mouse pointer, press Edit button

•

Design the layout of the Dialog

Reference:

http://api.openoffice.org/docs/DevelopersGuide/BasicAndDialogs/BasicAndDialogs.htm#1+1+0+2+A+Si

mple+Dialog

Create a control (CheckBox, ComboBox, RadioButton, Button, etc.) on the UserForm

[Dialog] and give the control a user defined name.

VBA

•

Drag and drop the controls from the Controls menu onto the UserForm

•

Select the control and press right mouse button

•

Select Properties option

•

Enter user defined name into the (Name) property

•

Drag and drop the controls from the Controls menu onto the Dialog

•

Select the control and press right mouse button

•

Select the Properties... option

•

Enter user defined name into the Name property

Porting Excel/VBA to Calc/StarBasic

Documents you may be interested

how to show pdf file in asp.net c# : How to search a pdf document for text Library software class asp.net winforms wpf ajax VbaStarBasicXref2-part1896