Open Office Skills

001: Create a bar chart and line chart for Open Office
If you open the chart in Excel directly with open office, you will find the original chart with a column chart and a line chart at the same time, only the bar chart is displayed. Does open support simultaneous display of two types of charts?
No. Originally, in open, you must specify its type as the extended attribute of the bar chart for the chart to achieve simultaneous bar chart and line chart. For details, right-click the chart, and select the chart type. The chart type is 2 dimensions. The chart type is bar. The variant is a combination chart. The number of lines is set to 1, you can.

002: Open Office creates two Y axis scales
Open charts sometimes need to display two Y-axis scales. You need to right-click the chart and edit the chart, and then select the sequence to show the other Y-axis (to be selected, otherwise, the object property is not targeted at it.) Right-click the object property, select the last tab, select "option", align the Data Group, and select "Y axis ", you can create another Y axis.

003: How to zoom in on Open Office
When I first started using open office, I wanted to enlarge the page so that I could select two vertices that were together, but I could not find them.
Later, I saw the penultimate button in the toolbar, a magnifier icon, that is, display the proportion. After clicking it, a dialog box is displayed, and I am free to select the corresponding content.
Later, I found that there is a "display proportion" in the menu "View", and the result is also called up.

004: how to modify the title of a chart in Open Office
After inserting a chart, you want to change the title, select the chart, right-click it, edit it, and select "Main title". Then, you can see that the title is not changed in "Object Attributes.
After a while, I found that if I double-click "Main title", it will enter the text editing status. Then I can enter the title you want.

005: how to modify the scale range of the Y axis of Open Office
In an automatically generated chart, the scale ranges from zero to the maximum value in the sequence, and then the scale is automatically divided. However, if the value of the sequence is large but the difference is small, you need to modify the scale range and how to operate it.
At the same time, select the chart, right-click, edit, and then click the Y axis. This is a bit of effort. If it is not good, it often points to the entire chart area. If it is not good, you can restore the normal state first, increase the display proportion, enter the chart, and edit the chart. Once the y-axis is selected, only the upper and lower boxes of the Y-axis are displayed. Right-click the object attribute and switch to the "display ratio" tab to turn off the automatic options of the minimum and maximum values, then enter the required size.

006: In open office, neither 1 nor 1 is equal to 2?
Open an original Excel file and find that the original formula is incorrect. Cell 3 = cell 1 + cell 2, and the result cell 3 is equal to cell 2. Why?
Open this document in Excel and find that cell 1 has a green arrow in the upper left corner of the Excel file. Move the mouse up and the prompt is: "The number in this cell is in text format, or there is an marker in front of it. ", If you convert it to a number in Excel, no error will occur in open.
If you do not have an Excel file, you can remove the single marker (also called single quotation marks) in front of the text in open to restore the normal formula.

007: Number in text format in open. There is no marker before it. how to convert it to a value?
The result of a cell involved in the operation is incorrect because the cell is of the text type. However, when the cursor falls on the cell, it cannot be converted into a numeric value because it never sees an marker.
The reason is that the cell has been formatted as text and the format code is "@". If we change it to a number, the format code is "General ", the cell marker is displayed.

008: How to know which words in the worksheet look like numbers
How do I know which text is like this? In the menu "Tools" and "options", find the view node under the "OpenOffice.org calc" node and find the "highlighted value" option in "display, in this way, you can check which numbers and texts are displayed in the worksheet.

: How to change the text of all numbers in the worksheet to real numbers
I couldn't find the answer to the existing operation, so I had to write a macro myself, the Code is as follows:
'Convert the column name to a value. If the column name is a value, return directly.
'Test case
'Enter A and convert it to 0.
'Input AC, convert to 28
'Input 12, convert to 12
Function name2val (sname as string) as integer
Dim ivalue as integer
If isnumeric (sname) then
Ivalue = Val (sname)
Else
Sname = ucase (sname)
If Len (sname) = 1 then
Ivalue = ASC (sname)-65
Elseif Len (sname) = 2 then
Ivalue = (ASC (left (sname, 1)-65) * 26 + (ASC (right (sname, 1)-65)
Else
Msgbox "The entered column name is not in the valid range and must contain two letters", 64, "information"
Name2val =-1
Exit Function
Endif
Endif
If ivalue <0 or ivalue> 255 then
Msgbox "the input column value is not in the valid range, 0 ≤ column ≤ 255", 64, "information"
Name2val =-1
Exit Function
Endif
Name2val = ivalue
End Function

Sub text2num
Dim odoc as object, osheet as object, ocell as object
Dim I as integer
Dim si0 as string
The first column of dim I0 as integer
Last column of dim I9 as integer
Dim J as integer
Dim J0 as integer 'first line
Last line of dim j9 as integer
Dim K as integer replacement count
Dim stemp as string
'Odoc = thiscomponent
Osheet = thiscomponent. currentcontroller. activesheet

Si0 = trim (inputbox ("Enter the first column to be replaced automatically "))
I0 = name2val (si0)
If I0 =-1 then exit sub

Si0 = trim (inputbox ("Enter the last column to be replaced automatically", "", si0 ))
I9 = name2val (si0)
If I9 =-1 then exit sub

If I0> I9 then
I = I0
I0 = I9
I9 = I
Endif

Si0 = trim (inputbox ("Enter the first line to be replaced automatically "))
J0 = name2val (si0)
If J0 =-1 then exit sub

Si0 = trim (inputbox ("Enter the last line to be replaced automatically", "", si0 ))
J9 = name2val (si0)
If j9 =-1 then exit sub

If J0> j9 then
J = J0
J0 = j9
J9 = J
Endif

K = 0
For I = I0 to I9
For J = J0 to j9
Ocell = osheet. getcellbyposition (I, J-1)
Stemp = ocell. Formula
If left (stemp, 1) = "'" Then
Stemp = mid (stemp, 2)
Ocell. formula = stemp
K = k + 1
Endif
Next
Next
Msgbox "replaced! A total of "& K &" locations are replaced. ", 64," information"
End sub
During the test, if the subprogram name is changed to Chinese, it cannot be displayed in the list.

010: the menu font is strange.
After some computers are installed, the fonts are strange and difficult to understand when they enter open office.
It turns out that during installation, the OS menu font is changed to an 8-dot-matrix character in English. For Chinese, at least 9 dot-matrix characters are normally displayed. You can follow these steps:
Right click the blank area on the desktop, right click, properties, display the screen properties, select the appearance tab, and select the menu item (if it is an XP system, select Advanced first, in the new pop-up window ), change the font to "" and the font size to "9.