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 6205 days
Last modified: 8/7/19 10:49 AM
Youre not logged in ... Login
... Home
... Tags

August 2019
Recent updates
Remove old backup files Cron
entry to remove all files in /home/ folder that starts...
by shantanuo (8/7/19 10:49 AM)
Types in AWS CNF List
of important Types in Amazon Cloud Formation tool: IAM (User,...
by shantanuo (8/5/19 7:36 AM)
codes used for classification Standard
codes used for classification: 1 SC 2 OBC 3 SBC...
by shantanuo (6/25/19 11:11 AM)
Shell scripting basics Here are
8 important concepts of Shell scripting that everyone should know....
by shantanuo (6/2/19 6:50 AM)
schema conversion tool This seems
to be a useful tool to convert mysql or oracle...
by shantanuo (3/30/19 6:52 AM)
Install packetbeat In order to
install packetbeat, you may need to change the windows security...
by shantanuo (3/26/19 8:01 AM)
python itertools module from itertools
import groupby s = 'abcccccbba' for w, v in groupby(s):...
by shantanuo (3/17/19 3:22 PM)
audio visual modules for Machine
Learning Here is the list of some of the modules...
by shantanuo (3/16/19 1:08 PM)
google module module for google
search !pip install google from googlesearch import search for url...
by shantanuo (1/8/19 10:38 AM)
Python date and time from
datetime import datetime date_string = "21 June, 2018" date_object =...
by shantanuo (12/26/18 12:14 PM)
Infer types in pandas This
will return the mixed datatypes but this can be slow....
by shantanuo (12/16/18 3:50 PM)
Extract words from Marathi wikipedia
1) Download the polyglot pickled marathi model wget mv...
by shantanuo (11/4/18 10:06 AM)
Google Input tools Google suddenly
stopped download of Input Tools package without giving any reason....
by shantanuo (9/10/18 7:44 AM)
Python objects and methods Here
are important python objects and their methods int __mul__, __add__,...
by shantanuo (8/18/18 3:11 PM)
JSON to DF Here is
how to read a JSON file into pandas dataframe. import...
by shantanuo (8/8/18 1:12 PM)
managing servers using python Fabric
is a high level Python library designed to execute shell...
by shantanuo (8/4/18 10:01 AM)
backup mysql users It is
easy to backup mysql users - wget; perl pt-show-grants
by shantanuo (5/20/18 3:42 PM)
About python 1 everything is
an object (class instances) 2 methods depends upon class of...
by shantanuo (5/20/18 2:52 PM)
mysql and shell command date
-d"-1 day ago" +'%b%d' equals to mysql -Bse"select date_format(date(date_add(now() ,...
by shantanuo (5/16/18 7:47 AM)
Preserving comments in Stored Procedure
You can write multi line comments in a stored procedure...
by shantanuo (5/12/18 12:56 PM)
Custom slack command Here are
5 steps to add any API to your slack channel....
by shantanuo (4/25/18 6:59 AM)
stack bookmarklet This bookmarklet will
help to quickly access stack pages linking to current page...
by shantanuo (1/10/18 10:47 AM)
Manage S3 like rsync ####
create bucket aws s3 mb s3://johntest123/ #### rsync all files...
by shantanuo (12/22/17 12:04 PM)
apache docker container issues If
apache docker container does not start then make these changes......
by shantanuo (11/10/17 3:00 PM)
Install aws client on centos
If pip is not installed, then the following command will...
by shantanuo (10/26/17 9:51 AM)

RSS feed

Made with Antville
Helma Object Publisher