User:Foral/Spec/Justification

{Title:Justification and Distributed for Japanese}

Calc

Cell Format

• Horizontal
  • OpenOffice.org : Default setting "Default"
  • MS Excel:Default setting "Default"

feature	feature(japanese)	Calc	MS-Excel(japanese version)	Comment
Default	標準	X	X	No problem
Left	左	X	X	No problem
Center	中央	X	X	No problem
Right	右	X	X	No problem
Justfied	両揃え	-	X	does not work correctly for Asian Character,work fine if use English.
Filled	塗り潰し/繰り返し	X	X	No problem
Center Across Selection	選択範囲内で中央	-	X	OpenOffice.org does not have this feature.
Distributed	均等割り付け	-	X	OpenOffice.org does not have this feature.

• Vertical
  • OpenOffice.org : Default setting "Default"
  • MS Excel:Default setting "Middle"

feature	feature(japanese)	Calc	MS-Excel(japanese version)	Comment
Default	標準	X	-	MS-Excel does not have this.
Top	上	X	X	No problem
Middle	中央	X	X	No problem/
bottom	下	X	X	No problem
Justfied	両揃え	-	X	OpenOffice.org does not have this feature.
Distributed	均等割り付け	-	X	OpenOffice.org does not have this feature.

for what,we use it and Sample of user scenario

• Justfied
• Distributed
• Center Across Selection

Sample files

listed sample for cell formatting

Horizontal

• Justfied

Media:Sample_Spreadsheet_Format_H_Justfied.xls

• Center Across Selection

Media:Sample_Spreadsheet_Format_H_CAS.xls

• Distributed

Media:Sample_Spreadsheet_Format_H_Distributed.xls

Vertical

• Justfied

Media:Sample_Spreadsheet_Format_V_Justfied.xls

• Distributed

Media:Sample_Spreadsheet_Format_V_Distributed.xls

Glossary from Microsoft 2003

Above		上		TDB	Windows	Excel	2003
Below		下		TXT	Windows	Excel	2003
Left		左		TXT	Windows	Excel	2003
Right		右		TXT	Windows	Excel	2003
Outside End		外部		TXT	Windows	Excel	2003
Inside End		内部外側		TXT	Windows	Excel	2003
Center		中央		TXT	Windows	Excel	2003
Best Fit		自動		TXT	Windows	Excel	2003
Left		左詰め		TXT	Windows	Excel	2003
Right		右詰め		LBX	Windows	Excel	2003
Fill		繰り返し		LBX	Windows	Excel	2003
Justify		両端揃え		LBX	Windows	Excel	2003
Center Across Selection		選択範囲内で中央		LBX	Windows	Excel	2003
Top		上詰め		LBX	Windows	Excel	2003
Center		中央揃え		LBX	Windows	Excel	2003
Bottom		下詰め		LBX	Windows	Excel	2003
Distributed		均等割り付け		TXT	Windows	Excel	2003
Vary colors by slice	V	要素を塗り分ける	V	TXT	Windows	Excel	2003
Default		標準		BUT	Windows	Excel	2003

Ref

• Requirements for Japanese Text Layout