incubator-odf-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From devin...@apache.org
Subject svn commit: r1165153 - /incubator/odf/site/trunk/content/odftoolkit/simple/demo/demo4.mdtext
Date Mon, 05 Sep 2011 02:58:46 GMT
Author: devinhan
Date: Mon Sep  5 02:58:46 2011
New Revision: 1165153

URL: http://svn.apache.org/viewvc?rev=1165153&view=rev
Log:
clear tags

Modified:
    incubator/odf/site/trunk/content/odftoolkit/simple/demo/demo4.mdtext

Modified: incubator/odf/site/trunk/content/odftoolkit/simple/demo/demo4.mdtext
URL: http://svn.apache.org/viewvc/incubator/odf/site/trunk/content/odftoolkit/simple/demo/demo4.mdtext?rev=1165153&r1=1165152&r2=1165153&view=diff
==============================================================================
--- incubator/odf/site/trunk/content/odftoolkit/simple/demo/demo4.mdtext (original)
+++ incubator/odf/site/trunk/content/odftoolkit/simple/demo/demo4.mdtext Mon Sep  5 02:58:46
2011
@@ -1,429 +1,128 @@
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml">
-<head>
-<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-<link rel="stylesheet" href="../images/style.css" type="text/css" />
-
-
-<link type="text/css" rel="stylesheet" href="styles/shCoreEclipse.css"/>
-
-<title>Demos - SimpleODF</title>
-<style type="text/css">
-<!--
-.STYLE1 {
-	color: #FFFFFF;
-	font-size: 24px;
-}
-.STYLE2 {font-size: 32px}
-.STYLE3 {font-size: 16px}
-.STYLE4 {font-size: 36px}
--->
-    </style>
-	<script type="text/javascript">
-
-  var _gaq = _gaq || [];
-  _gaq.push(['_setAccount', 'UA-22366020-1']);
-  _gaq.push(['_trackPageview']);
-
-  (function() {
-    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
-    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
-    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
-  })();
-
-</script>
-</head>
-<body>
-<div id="page" align="center">
-  <div id="content" style="width:920px" class="contentpanel">
-    <div id="topheader">
-      <div class="topright"> </div>
-    </div>
-    <div id="menu">
-      <div align="left" class="smallwhitetext"> <a href="../index.html" class="home">
</a> <a href="../downloads.html" class="download"></a> <a href="../documents.html"
class="document"></a> <a href="../demo/index.html" class="sample"> </a>
</div>
-    </div>
-    <div id="subcontent" align ="left">
-        <div align="left" class="titletext"> <span >
-		<a href="index.html">Simple Demos<a> > 
-		<a href="demo4.html">Demo 3: List and Table Conversion<a>
-		</span> 
-		</div>
-		
-		<!---------------------------------------------------------------------------------------------------->

-<div class="contenttitle">
-
-    <a name="overview">Overview</a>
-
-</div>
-
-<div class="bodytext">
-
-    <p> Starting in version 0.4, we have added methods to support bullet, numbered
and 
-
-    image lists to the Simple API. This includes frequently used features 
-
-    for processing lists and list item. This demo is designed to show the power 
-
-    of List API and help you learn how to use it. <br/> <br/> This demo shows

-
-    how to convert between a nested List and Table. As you can see in the 
-
-    following two pictures, on the left we have a simple outline of a corporate 
-
-    hierarchy. There are four departments in this company.  Each department has 
-
-    several managers and each manager has several reporting staff.  Now we want 
-
-    to change this list to a table, just like the picture on the right 
-
-    shows.<br/> <br/> &nbsp;&nbsp;&nbsp;<img 
-
-    src="image/demo4_organization_list.png"><br/> <br/> However, 
-
-    sometimes we want to convert in the opposite direction, from a table to a 
-
-    list. Take the following two pictures as example.  The left one is table of 
-
-    country calling codes, which includes the codes of countries from different 
-
-    continents. Suppose you want to convert this table representation into a 
-
-    nested list.  The picture on the right shows the conversion result. The 
-
-    first level list show the continent names and the second level list show 
-
-    the countries and their calling codes.<br/> <br/> <img 
-
-    src="image/demo4_code_list.png" ><br/> <br/> You can see similar 
-
-    functionality in office software, such as selective copy and paste. In the 
-
-    next section, I will show how easy to do these kinds of conversions using 
-
-    the Simple API. 
-
-    </p>
-
-</div>
-
-<hr/>
-
-<div class="contenttitle">
-
-    <a name="codeintroduction">Code Introduction</a>
-
-</div>
-
-<div class="bodytext">
-
-    <p>
-
-    Let's have a look at the main method. It will help us get an overview of 
-
-    this demo. First, the list data text document, "ListTable.odt" and table 
-
-    data spreadsheet document "TableList.ods" are loaded. Secondly, we use the 
-
-    list iteration function to get all of the lists in the text document and 
-
-    invoke the method <code>convertFromListToTable</code> to convert each of
them to a table. 
-
-    Finally, we get the data table from "TableList.ods" and invoke the method 
-
-    <code>convertFromTableToList</code> to convert this table to a list. All
of the updated 
-
-    documents are saved as new files. You can open them and see the 
-
-    conversion results.
-
-    </p>
-
-    <!--java code-->
-
-    <pre class="brush:java;">
-
-	public static void main(String[] args) {
-
-		try {
-
-			TextDocument textDoc = TextDocument.loadDocument("ListTable.odt");
-
-			SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.loadDocument("TableList.ods");
-
-			// covert list in text document to spreadsheet table
-
-			Iterator<list> listIterator = textDoc.getListIterator();
-
-			int i = 1;
-
-			String[] tableLabel = { "DEPARTMENT", "MANAGER", "EMPLOYEE" };
-
-			while (listIterator.hasNext()) {
-
-				List list = listIterator.next();
-
-				Table newTable = Table.newTable(spreadsheetDoc);
-
-				for (int columnIndex = 0; columnIndex < tableLabel.length; columnIndex++) {
-
-					newTable.getCellByPosition(columnIndex, 0).setStringValue(tableLabel[columnIndex]);
-
-				}
-
-				newTable.setTableName("ListTable" + (i++));
-
-				convertFromListToTable(list, newTable, 0, 1);
-
-			}
-
-			spreadsheetDoc.save("TableListUpdate.ods");
-
-			// covert table in spreadsheet to list in text document
-
-			Table sheet1 = spreadsheetDoc.getTableByName("Sheet1");
-
-			textDoc.newParagraph("ListConvertedFromTable");
-
-			List newList = textDoc.addList();
-
-			convertFromTableToList(sheet1, newList, 0, 0, sheet1.getColumnCount() - 1, sheet1.getRowCount()
- 1);
-
-			textDoc.save("ListTableUpdate.odt");
-
-		} catch (Exception e) {
-
-			e.printStackTrace();
-
-		}
-
-	}
-
-    </pre>
-
-</p>
-
-<p>
-
-In the following two sections, I will review the implementation of the methods 
-
-<code>convertFromListToTable</code> and <code>convertFromTableToList</code>.
<br/><br/>
-
-<b>Convert from List to Table</b>
-
-<br/><br/>
-
-This is a recursive method, similar to a depth-first tree traversal. You 
-
-determine the paste cell address by <code>startColumn</code> and <code>startRow</code>.
First, all of the 
-
-items in the list are retrieved. Second, each list item is converted to table 
-
-cell. Its text content is extracted and set as the cell's display text. If the 
-
-item has a sub list, its sub list is also handled the same as the parent list. 
-
-<br/><br/> After all of the items are converted to cells, we invoke 
-
-<code>CellRange.merge()</code> to merge the blank cells. The generation document
appears just 
-
-like the picture shown earlier.<br/>
-
-    <!--java code-->
-
-<pre class="brush:java;">
-
-	private static int convertFromListToTable(List list, Table table, int startColumn, int startRow)
{
-
-		java.util.List<listitem> items = list.getItems();
-
-		int newItemCount = startRow;
-
-		for (ListItem item : items) {
-
-			Cell cell = table.getCellByPosition(startColumn, newItemCount);
-
-			cell.setStringValue(item.getTextContent());
-
-			cell.setVerticalAlignment(VerticalAlignmentType.MIDDLE);
-
-			Iterator<list> listIterator = item.listIterator();
-
-			startRow = newItemCount;
-
-			while (listIterator.hasNext()) {
-
-				List subList = listIterator.next();
-
-				newItemCount = convertFromListToTable(subList, table, startColumn + 1, newItemCount);
-
-			}
-
-			// merge
-
-			CellRange cellRange = table.getCellRangeByPosition(startColumn, startRow, startColumn,
newItemCount);
-
-			cellRange.merge();
-
-			newItemCount++;
-
-		}
-
-		if (list.size() > 0) {
-
-			return newItemCount - 1;
-
-		} else {
-
-			return startRow;
-
-		}
-
-	}
-
-    </pre>
-
-</p>
-
-<br/>
-
-<p>
-
-<b>Convert from Table to List</b>
-
-<br/><br/>
-
-This is also a recursive method. You determine the conversion range of the table 
-
-by <code>startColumn</code>, <code>startRow</code>, <code>endColumn</code>
and <code>endRow</code>. First, every cell in the 
-
-selected range is retrieved by <code>Table.getCellByPosition</code>. Next, a
list item is 
-
-created to store the cell display text. If the <code>rowSpannedNumber > 1</code>,
that means 
-
-this item has a sub list. Parts of the cells in the right columns of this cell 
-
-become the items of the sub list. They are also determined by recursive calls to 
-
-<code>convertFromTableToList</code>. If the <code>rowSpannedNumber = 1</code>,
there is no need to create 
-
-a sub list, all of the content in the right cells is just added to this 
-
-item.<br/>
-
-    <!--java code-->
-
-<pre class="brush:java;">
-
-    private static void convertFromTableToList(Table table, List list, int startColumn, int
startRow, int endColumn,
-
-			int endRow) {
-
-		while (startRow <= endRow) {
-
-			Cell cell = table.getCellByPosition(startColumn, startRow);
-
-			int rowSpannedNumber = cell.getRowSpannedNumber();
-
-			String cellText = cell.getDisplayText();
-
-			if (!"".equals(cellText)) {
-
-				ListItem item = list.addItem(cellText);
-
-				int columnSpannedNumber = cell.getColumnSpannedNumber();
-
-				int newStartColumn = startColumn + columnSpannedNumber;
-
-				if (newStartColumn <= endColumn) {
-
-					if (rowSpannedNumber > 1) {
-
-						List subList = item.addList();
-
-						convertFromTableToList(table, subList, newStartColumn, startRow, endColumn, startRow
-
-								+ rowSpannedNumber - 1);
-
-					} else {
-
-						int tmpStartColumn = newStartColumn;
-
-						while (tmpStartColumn <= endColumn) {
-
-							cell = table.getCellByPosition(tmpStartColumn, startRow);
-
-							cellText = cell.getDisplayText();
-
-							if (!"".equals(cellText)) {
-
-								item.setTextContent(item.getTextContent() + "|" + cellText);
-
-							}
-
-							tmpStartColumn += cell.getColumnSpannedNumber();
-
-						}
-
-					}
-
-				}
-
-			}
-
-			startRow += rowSpannedNumber;
-
-		}
-
-	}
-
-</pre>
-
-</p>
-
-</div>
-
-<hr/>
-
-<div class="contenttitle">
-
-    <a name="download">Download</a>
-
-</div>
-
-<div class="bodytext">
-
-    <p>
-
-    Powered by Simple API version <a target="_new" href="../downloads.html"><img
src="../images/link.png"></img>0.4</a>.
-
-    </p>
-
-    <p>
-
-    You can download the code of this demo from <a href="table_list_convertion.zip"><img
src="../images/link.png"></img>here</a>.
-
-    </p>
-
-</div>
-<!---------------------------------------------------------------------------------------------------->
	
-		
-		
-
-    </div>
-    <div id="footer" class="smallgraytext"> <a href="../index.html">Home</a>
| <a href="#">About Us</a> | <a href="mailto:Daisy@odftoolkit.org">Contact
Us</a> </div>
-  </div>
-</div>
-</body>
-</html>
-
-
-
-<script type="text/javascript" src="scripts/shCore.js"></script>  
-
-<script type="text/javascript" src="scripts/shBrushJava.js"></script>  
-
-<script type="text/javascript"> SyntaxHighlighter.all();</script> 
-
-
-
-
+**[Demos][1]** > **List and Table Conversion**   
+
+**Overview**  
+
+Starting in version 0.4, we have added methods to support bullet, numbered and image lists
to the Simple API. This includes frequently used features  for processing lists and list item.
This demo is designed to show the power of List API and help you learn how to use it.  
+   
+This demo shows how to convert between a nested List and Table. As you can see in the following
two pictures, on the left we have a simple outline of a corporate 
+hierarchy. There are four departments in this company.  Each department has several managers
and each manager has several reporting staff.  Now we want 
+to change this list to a table, just like the picture on the right shows.  
+ 
+ ![image1][2]  
+
+However, sometimes we want to convert in the opposite direction, from a table to a list.
Take the following two pictures as example. The left one is table of country calling codes,
which includes the codes of countries from different continents. Suppose you want to convert
this table representation into a nested list.  The picture on the right shows the conversion
result. The first level list show the continent names and the second level list show the countries
and their calling codes.    
+  
+ ![image2][3]     
+
+You can see similar functionality in office software, such as selective copy and paste. In
the next section, I will show how easy to do these kinds of conversions using the Simple API.

+
+**Code Introduction**
+
+Let's have a look at the main method. It will help us get an overview of this demo. First,
the list data text document, "ListTable.odt" and table data spreadsheet document "TableList.ods"
are loaded. Secondly, we use the list iteration function to get all of the lists in the text
document and invoke the method <code>convertFromListToTable</code> to convert
each of them to a table. Finally, we get the data table from "TableList.ods" and invoke the
method <code>convertFromTableToList</code> to convert this table to a list. All
of the updated documents are saved as new files. You can open them and see the conversion
results.   
+
+	public static void main(String[] args) {
+		try {
+			TextDocument textDoc = TextDocument.loadDocument("ListTable.odt");
+			SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.loadDocument("TableList.ods");
+			// covert list in text document to spreadsheet table
+			Iterator<list> listIterator = textDoc.getListIterator();
+			int i = 1;
+			String[] tableLabel = { "DEPARTMENT", "MANAGER", "EMPLOYEE" };
+			while (listIterator.hasNext()) {
+				List list = listIterator.next();
+				Table newTable = Table.newTable(spreadsheetDoc);
+				for (int columnIndex = 0; columnIndex < tableLabel.length; columnIndex++) {
+					newTable.getCellByPosition(columnIndex, 0).setStringValue(tableLabel[columnIndex]);
+				}
+				newTable.setTableName("ListTable" + (i++));
+				convertFromListToTable(list, newTable, 0, 1);
+			}
+			spreadsheetDoc.save("TableListUpdate.ods");
+			// covert table in spreadsheet to list in text document
+			Table sheet1 = spreadsheetDoc.getTableByName("Sheet1");
+			textDoc.newParagraph("ListConvertedFromTable");
+			List newList = textDoc.addList();
+			convertFromTableToList(sheet1, newList, 0, 0, sheet1.getColumnCount() - 1, sheet1.getRowCount()
- 1);
+			textDoc.save("ListTableUpdate.odt");
+		} catch (Exception e) {
+			e.printStackTrace();
+		}
+	}
+
+In the following two sections, I will review the implementation of the methods <code>convertFromListToTable</code>
and <code>convertFromTableToList</code>.    
+
+
+***Convert from List to Table***
+
+This is a recursive method, similar to a depth-first tree traversal. You determine the paste
cell address by <code>startColumn</code> and <code>startRow</code>.
First, all of the items in the list are retrieved. Second, each list item is converted to
table cell. Its text content is extracted and set as the cell's display text. If the item
has a sub list, its sub list is also handled the same as the parent list. After all of the
items are converted to cells, we invoke <code>CellRange.merge()</code> to merge
the blank cells. The generation document appears just like the picture shown earlier.    
+
+
+	private static int convertFromListToTable(List list, Table table, int startColumn, int startRow)
{
+		java.util.List<listitem> items = list.getItems();
+		int newItemCount = startRow;
+		for (ListItem item : items) {
+			Cell cell = table.getCellByPosition(startColumn, newItemCount);
+			cell.setStringValue(item.getTextContent());
+			cell.setVerticalAlignment(VerticalAlignmentType.MIDDLE);
+			Iterator<list> listIterator = item.listIterator();
+			startRow = newItemCount;
+			while (listIterator.hasNext()) {
+				List subList = listIterator.next();
+				newItemCount = convertFromListToTable(subList, table, startColumn + 1, newItemCount);
+			}
+			// merge
+			CellRange cellRange = table.getCellRangeByPosition(startColumn, startRow, startColumn,
newItemCount);
+			cellRange.merge();
+			newItemCount++;
+		}
+		if (list.size() > 0) {
+			return newItemCount - 1;
+		} else {
+			return startRow;
+		}
+	}
+
+***Convert from Table to List***
+
+This is also a recursive method. You determine the conversion range of the table by <code>startColumn</code>,
<code>startRow</code>, <code>endColumn</code> and <code>endRow</code>.
First, every cell in the selected range is retrieved by <code>Table.getCellByPosition</code>.
Next, a list item is created to store the cell display text. If the <code>rowSpannedNumber
> 1</code>, that means this item has a sub list. Parts of the cells in the right
columns of this cell become the items of the sub list. They are also determined by recursive
calls to <code>convertFromTableToList</code>. If the <code>rowSpannedNumber
= 1</code>, there is no need to create a sub list, all of the content in the right cells
is just added to this item.   
+
+    private static void convertFromTableToList(Table table, List list, int startColumn, int
startRow, int endColumn, int endRow) {
+		while (startRow <= endRow) {
+			Cell cell = table.getCellByPosition(startColumn, startRow);
+			int rowSpannedNumber = cell.getRowSpannedNumber();
+			String cellText = cell.getDisplayText();
+			if (!"".equals(cellText)) {
+				ListItem item = list.addItem(cellText);
+				int columnSpannedNumber = cell.getColumnSpannedNumber();
+				int newStartColumn = startColumn + columnSpannedNumber;
+				if (newStartColumn <= endColumn) {
+					if (rowSpannedNumber > 1) {
+						List subList = item.addList();
+						convertFromTableToList(table, subList, newStartColumn, startRow, endColumn, startRow
+ rowSpannedNumber - 1);
+					} else {
+						int tmpStartColumn = newStartColumn;
+						while (tmpStartColumn <= endColumn) {
+							cell = table.getCellByPosition(tmpStartColumn, startRow);
+							cellText = cell.getDisplayText();
+							if (!"".equals(cellText)) {
+								item.setTextContent(item.getTextContent() + "|" + cellText);
+							}
+							tmpStartColumn += cell.getColumnSpannedNumber();
+						}
+					}
+				}
+			}
+			startRow += rowSpannedNumber;
+		}
+	}
+
+**Download**   
+    
+Powered by Simple API version [0.4][4].    
+You can download the code of this demo from [here][5].   
+
+  [1]: index.html
+  [2]: image/demo4_organization_list.png
+  [3]: image/demo4_code_list.png
+  [4]: ../downloads.html
+  [5]: table_list_convertion.zip
\ No newline at end of file



Mime
View raw message