Thanks to
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, 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

... 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 6640 days
Last modified: 10/28/20 5:59 PM
Youre not logged in ... Login
... Home
... Tags

October 2020
Recent updates
important leafy vegetables 1. Amaranthus
caudatus: rajgira. 2. Amaranthus tricolor: Math.  (Chhoti Chulai- Hindi, Cheera-...
by shantanuo (4/12/20 2:01 PM)
program creek program creek
seems to be a good site for handy references of python...
by shantanuo (4/11/20 11:24 AM)
Standard out to a file
This code will change the standard out to a file...
by shantanuo (4/11/20 11:18 AM)
Create config file for AWS
command line tool While creating amazon config file in a...
by shantanuo (2/20/20 6:00 AM)
setting colors in pandas This
is how to set the colors in pandas mapper =...
by shantanuo (2/20/20 5:53 AM)
log mysql output tee output.txt
show global variables; show engine innodb status\G show full processlist;...
by shantanuo (2/19/20 10:33 AM)
access AWS API gateway using
python Amazon API gateway allows us to host server-less API's...
by shantanuo (2/16/20 9:41 AM)
Using boto In the bad
old days, the glacier class used to have different layers....
by shantanuo (2/15/20 10:28 AM)
backup mysql users  3
steps to install perconal utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
by shantanuo (2/13/20 1:49 PM)
Steps to be used for
generating AWS API gateway a) Method Execution - Get Method...
by shantanuo (2/13/20 1:30 PM)
apply colors to pandas Here
is how to change the color of negative values to...
by shantanuo (2/12/20 8:57 AM)
Holidays in India These are
the common holidays celebrated in India (Mumbai) during 2016 -...
by shantanuo (2/11/20 1:53 PM)
change log file size in
MySQL Here are the steps to be followed while changing...
by shantanuo (2/11/20 10:38 AM)
MySQL common error messages 1146
Table does not exist 1054 column does not exist 1062...
by shantanuo (2/11/20 10:13 AM)
ipython parallel demo First start
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
by shantanuo (2/9/20 9:02 AM)
djanog settings You may see
this message if you have DEBUG = True in your...
by shantanuo (2/9/20 4:07 AM)
clear tmp folder Here is
following commands to clear unwanted stuff from the /tmp partition...
by shantanuo (2/8/20 2:41 PM)
change your server time to
IST If you need to change your server clock to...
by shantanuo (2/8/20 2:39 PM)
Transfer root emails to another
email address If you have root access to the server...
by shantanuo (2/8/20 2:32 PM)
special strings in cron Instead
of the first five fields, you can use any one...
by shantanuo (2/8/20 2:30 PM)
LibreOffice version conflict I am
not able to install latest version of Libre office. I...
by shantanuo (1/29/20 9:15 AM)
while loop This is
a sample shell script while loop while read mydb do echo...
by shantanuo (1/26/20 12:24 PM)
compare mysql schema And here
is poor man's schema compare using good old diff command......
by shantanuo (1/26/20 11:49 AM)
Selecting from error log grep
"error" error_log |awk -F[ {'print $4'} \ | sort |...
by shantanuo (1/26/20 10:40 AM)
Rank mysql records using variables
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
by shantanuo (1/26/20 9:45 AM)

RSS feed

Made with Antville
Helma Object Publisher