Thanks to antville.org
base and MySQL connectivity

To get started with the JDBC Driver for MySQL (Connector/J), download it from MySQL's Web site, unpack the downloaded file, and move the resulting mysql-connector-java-x.x.x-bin.jar file into the desired location (e.g. your home directory). In OpenOffice.org, choose Tools -> Options -> Java. Make sure that the appropriate Java Runtime Environment is selected and click the Class Path button. Next, click the Add Archive button and select mysql-connector-java-x.x.x-bin.jar. Click OK to save the settings and close the window, then restart OpenOffice.org.

www.mysql.com

... Link (0 comments) ... Comment


More About Calc

1) Edit - Changes - Record
This option helps you to track changes being made to your spreadsheet.

2) Edit - Compare Document
Compare different versions of the same document.

3) File - Versions
Create versions.

4) Calc and Excel use different default number formats. With Excel, the cells are set to the “General” category number format., so if you entered 25.12345 in a cell it would display “25.12345”. In Calc a default formatted cell is set to the “Number” category in the “General” format. Thus, if 25.12345 is entered, 25.12 will be displayed.

... Link (0 comments) ... Comment


Calc Shortcut keys

Ctrl + F8 - Highlights cells containing numeric values and formulas (not text)
F11 Opens the Styles and Formatting window
Shift+F11 Creates a document template
Shift+Ctrl+F11 Updates the templates
Alt+Down Arrow Increases the height of current row
Alt+Up Arrow Decreases the height of current row
Alt+Right Arrow Increases the width of the current column
Alt+Left Arrow Decreases the width of the current column
Alt+Shift+Arrow Key Optimizes the column width or row height based on the current cell
Alt+Enter (Alt+Shift+Enter also applies the cell format) Enter into all currently selected cells

... Link (0 comments) ... Comment


Format Zip Code

Calc Tip: Format The Zip Code Column For Five Digits Zip Codes

  1. Right-click on the top of the Zip Code column. (A menu appears).
  2. Click Format Cells (The 'Format Cells" window appears)
  3. Click the Numbers tab.
  4. Under Category, select Number.
  5. Under Format, select General.
  6. In the Leading zeros box, increase the number 1 to a 5.
  7. Click OK. (A zero appears at the beginning of the "01111" zip code).

... Link (0 comments) ... Comment


Online for 6367 days
Last modified: 1/29/20 11:15 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
January 2020
SunMonTueWedThuFriSat
1234
567891011
12131415161718
19202122232425
262728293031
December
Recent updates
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 11:15 AM)
Amazing! Yeahh! you have an
informative blog so far. Thanks for sharing | roof repair...
by Danielperez123 (1/28/20 8:32 PM)
Great Work Thanks for sharing
the post. Microsoft toolkit
by talisasoto1989 (1/27/20 10:22 PM)
Farnham Carpet Cleaning Thanks Farnham
Carpet Cleaning
by Dubs@gl.com (1/27/20 10:13 PM)
Locksmith Guildford That's an interesting
point Locksmith in Guildford
by Dubs@gl.com (1/27/20 10:11 PM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 2:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 1:49 PM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 12:40 PM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 11:45 AM)
Thanks for sharing this!!
commercial roofing huntsville al
by Mazikeen (1/24/20 6:37 PM)
Sophie Chciałbym więcej o tym
przeczytać. Szybka, jaka literatura ma studiować? texas colleges and universities
by panistefanin (1/24/20 3:45 PM)
Jack Lovely information thank you
very much decanters
by decanter2020 (1/24/20 1:20 PM)
I like it I like
that logic. interior painting
by LisaCook (1/23/20 10:11 PM)
Love it I like this!
Thanks for posting roll off canister
by LaurenHill (1/23/20 10:05 PM)
Thanks for the heads up!
Thank you for sharing this. Our website
by mozaic (1/23/20 2:32 PM)
Thank you for sharing
a really great piece of information. bubble shooter
by longjumper (1/21/20 11:05 AM)
Thanks Thanks for sharing these.
Sam H - Interior Painter Scaumburg Il
by Samh2019 (1/21/20 10:14 AM)
Fencing in Guildford thanks for
the information Fencing in Guildford Fencing in Surrey
by Dubs (1/20/20 9:26 PM)
satta matka matka boss satta
matka Visit our site for more information
by sattamatka3.net (1/20/20 7:52 PM)
Beebeetravvel Thanks for sharing your
valuable information. we are a tour & travel agency with...
by coolexusa (1/20/20 2:27 PM)
Access Control System Dubai Fingerprintdubai
Company is providing many types of Services like , card...
by coolexusa (1/20/20 12:19 PM)
Air Duct Cleaning This type
of Duct cleaning Miami is absolutely not a must have...
by coolexusa (1/20/20 11:26 AM)
Carpet Cleaning Oxford and Surrounding
Areas Interesting read. Carpet cleaning in Oxford and surrounding areas
by Murray Whelehan (1/19/20 8:18 PM)
Antares AutoTune Crack License
Key With Keygen ( MAC ) A Antares AutoTune Pro Crack...
by ijicrackgh (1/19/20 9:50 AM)
Waves Tune Real-Time Crack (Latest)
Free Download 2020! Visit my site and free crack full...
by ijicrackgh (1/19/20 9:45 AM)

RSS feed

Made with Antville
Helma Object Publisher