¡ÖWeb½ÐÈÇ¥µ¥¤¥È¡×¥Ù¡¼¥¿¸ø³«

Q&A½¸[¡©]

Åö¥µ¥¤¥È¤Ç¤Î¤´¼ÁÌä¤Î¼õÉդϽªÎ»¤·¤Þ¤·¤¿

¤¹¤Ù¤Æ¤Î¥³¥ó¥Æ¥ó¥Ä¤òÆÉ¤ß¹þ¤ßÀìÍѤȤ·¤¿¤¿¤á¡¢²óÅúÍ󤫤é¤âÅê¹Æ¤Ç¤­¤Þ¤»¤ó

Apache OpenOffice/LibreOffice¤Î¤´¼ÁÌä¤Ï¤½¤ì¤¾¤ì¤Î¥Õ¥©¡¼¥é¥à¤Ø¤´Åê¹Æ¤¯¤À¤µ¤¤

¼ÁÌ䥳¡¼¥Ê¡¼

¥µ¥¤¥ÈÆâ¸¡º÷

ʬÎà¥á¥Ë¥å¡¼

´ØÏ¢¥µ¥¤¥È


ËÜÆü¡§1
ºòÆü¡§1
Áí¿ô¡§2682
¸½ºß¡§2


¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë¥Ç¡¼¥¿¤òCalc¤Ø

¥Ú¡¼¥¸OpenOffice.org FAQ¤ÎÅÐÏ¿¥Ú¡¼¥¸
Åê¹Æ¼Ôkimura
ʬÎà
edit/refer
Í¥Àè½ç°Ì
edit/refer
¾õÂÖ
edit/refer
¥«¥Æ¥´¥ê¡¼
edit/refer
Åê¹ÆÆü2009-09-18 11:13:28 (¶â)
OSWindows vista
°Í¸¤¹¤ë¥Ú¡¼¥¸
¥Ð¡¼¥¸¥ç¥ó
edit/refer

¥á¥Ã¥»¡¼¥¸

²óÅú¥Ú¡¼¥¸¤Ç¤Ï¹ÔËö¤Ë¡Ö~¡×¤òÉղ乤ëɬÍפϤ¢¤ê¤Þ¤»¤ó

½é´üÀßÄ꤬´Å¤¯¡¢¥Õ¥£¡¼¥ë¥É¤Î¥Õ¥£¡¼¥ë¥ÉŽÀ޲ŽÌŽß¤ò¡Ö¥Æ¥­¥¹¥È[VARCHAR]¡×¤Çºî¤Ã¤Æ¤¤¤Þ¤·¤¿¡£ ¥¯¥¨¥ê¡¼¤Ê¤É¤Ç·×»»¤¬É¬Íפʾì¹ç¡¢¿ôÃÍ·¿¤Ç¤¢¤ë¡Ö¿ôÃÍ¡ÎNUMRIC¡Ï¡×Åù¤Ë¤·¤Ê¤¤¤È¤À¤á¤À¤È¤ï¤«¤ê¡¢¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿·¿¤òÊѹ¹¤·¤è¤¦¤È»×¤Ã¤Æ¤¤¤Þ¤¹¡£

¤·¤«¤·¡¢ÊÔ½¸¤Ç¥Õ¥£¡¼¥ë¥ÉŽÀ޲ŽÌŽß¤ò½ñ¤­´¹¤¨¤ë¤È¡¢¥Ç¡¼¥¿¤¬°ú¤­·Ñ¤²¤Ê¤¤¤Èʹ¤­¤Þ¤·¤¿¡£ Calc¤Ë¤À¤·¡¢base¤ËÌᤷ¡¢¿·µ¬¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Ê¤¤¤È¤Ïʹ¤¤¤¿¤Î¤Ç¤¹¤¬¡¢¤ä¤êÊý¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£ ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬¡¢¥¢¥É¥Ð¥¤¥¹¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£


¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×¤ò»È¤¤¤Þ¤·¤ç¤¦

M.Kamataki (2009-09-18 12:39:00 (¶â))

¡Ö¥Æ¥­¥¹¥È[VARCHAR]¡×¤Ê¥Õ¥£¡¼¥ë¥É¤Î¤¢¤ë¥Æ¡¼¥Ö¥ë¤òA¤È¤·¤Þ¤¹¡£A¤òÁªÂò¤·¡ÖÊÔ½¸¡×¡Ý¡Ö¥³¥Ô¡¼¡×¤·¤Þ¤¹¡£¼¡¤Ë¡ÖÊÔ½¸¡×¡Ý¡ÖޤêÉÕ¤±¡×¤¹¤ë¤È¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×¥À¥¤¥¢¥í¥°¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£

¥Æ¡¼¥Ö¥ë̾Íó¤ò¡ÖB¡×¤Ë½ñ¤­´¹¤¨¡¢¥ª¥×¥·¥ç¥ó¤Ç¡ÖÄêµÁ¤È¥Ç¡¼¥¿¡×¤òÁª¤Ó¤Ê¤ª¤·¡¢¡Ö¼¡¤Ø¡×¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¤Þ¤¹¡£

¡ÖÎó¤ÎŬÍѡץÀ¥¤¥¢¥í¥°¤Ç¡Ö>>¡×¤ò¥¯¥ê¥Ã¥¯¤·¤Æ±¦¤Î¥Ú¥¤¥ó¤Ë¥Õ¥£¡¼¥ë¥É¤ò¤¹¤Ù¤Æ°Üư¤µ¤»¡¢¡Ö¼¡¤Ø¡×¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¤Þ¤¹¡£

¡Ö¥¿¥¤¥×¤Î½ñ¼°ÀßÄê¡×¥À¥¤¥¢¥í¥°¤Ç¡Ö¥Æ¥­¥¹¥È[VARCHAR]¡×¤ò¡Ö¿ôÃÍ¡ÎNUMERIC¡Ï¡×¤ËÊÑ´¹¤·¤¿¤¤¥Õ¥£¡¼¥ë¥É¤òÁª¤Ó¡¢Îó¤Î¾ðÊó¤òÊѹ¹¤·¤Þ¤¹¡£¤³¤Î¤È¤­¡¢¾®¿ôÅÀ¤¬¤¢¤ë¾ì¹ç¤Ï¤½¤ÎºÇÂç¤Î·å¿ôÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£¤³¤³¤ò´Ö°ã¤¦¤È¾®¿ôÅÀ°Ê²¼¤Î¿ôÃͤ¬¼º¤ï¤ì¤Þ¤¹¡£¡Ö´°Î»¡×¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤¹¤ì¤Ð¡¢B¥Æ¡¼¥Ö¥ë¤È¤·¤Æ¤¹¤Ù¤Æ¤Î¥ì¥³¡¼¥É¤ò°Ü¹Ô¤Ç¤­¤Þ¤¹¡£¤½¤Î¸å¡¢A¤òºï½ü¤·¤ÆB¤ò¥ê¥Í¡¼¥à¤¹¤ë¤È¤«¤ÏŬÅö¤Ë¡£

¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×µ¡Ç½¤Ë¤Ä¤¤¤Æ¤Ï¡¢faq/1/28¡ÖBase¤Ç¤Î¥Æ¡¼¥Ö¥ë¥³¥ó¥Ð¡¼¥È¤È¢½ñ´ÉÍý¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÎÀßÄê¡×¤ò»²¹Í¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£

¤È¤¤¤¦¤³¤È¤ÇCalc¤ò·Ðͳ¤¹¤ëɬÍפϤ¢¤ê¤Þ¤»¤ó¤¬¡¢Calc¤ËBase¤Î¥Æ¡¼¥Ö¥ë¤òÁÞÆþ¤¹¤ë¤Î¤Ï´Êñ¤Ç¤¹¡£Calc¤ò³«¤¤¤¿¤éF4¥­¡¼¤ò²¡¤·¤Æ¤¯¤À¤µ¤¤¡£¥Ç¡¼¥¿¥½¡¼¥¹¤Î°ìÍ÷¤¬É½¼¨¤µ¤ì¤Þ¤¹¡£ÌÜŪ¤Î¥Æ¡¼¥Ö¥ë¤òÁªÂò¤·¡¢¥Þ¥¦¥¹¤ò»È¤Ã¤ÆCalc¤Î¥·¡¼¥È¤Ø¥É¥é¥Ã¥°&¥É¥í¥Ã¥×¤·¤Æ¤¯¤À¤µ¤¤¡£¤³¤ì¤ÇCalc¤Ë¥¤¥ó¥Ý¡¼¥È¤Ç¤­¤Þ¤¹¡£

ÊÔ½¸¤Ç¤â

M.Kamataki (2009-09-18 12:44:12 (¶â))

¾®¿ôÅÀ¤Î·å¿ô¤À¤±´Ö°ã¤ï¤Ê¤±¤ì¤Ð¡¢¡Ö¿ôÃÍ¡ÎNUMERIC¡Ï¡×¤ËÊѹ¹¤ò¤·¤Æ¤âÂç¾æÉפʤ褦¤Ç¤·¤¿¡Ê¤À¤¤¤Ö²þÁ±¤µ¤ì¤¿¤È»×¤¤¤Þ¤¹¡Ë¡£¤·¤«¤·¡¢ÊÔ½¸¤Çľ¤¹¤È¤¤¤¦¤Î¤Ï¡¢¤ä¤Ï¤êÉݤ¤µ¤¤¬¤¹¤ë¤Î¤Ç¡Ê¾®¿ôÅÀ¤Î·å¿ô¤ò´Ö°ã¤¨¤ë¤Ê¤É¡Ë¡¢¤è¤ê°ÂÁ´¤Ê¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×¤ò»È¤ï¤ì¤ë¤³¤È¤òÁ¦¤á¤Þ¤¹¡£

¥¯¥¨¥ê¡¼¤Ç¤Î·×»»

M.Kamataki (2009-09-18 13:28:15 (¶â))

·×»»¤¬¤Ç¤­¤ë¤Î¤Ï³Î¤«¤Ë¥Õ¥£¡¼¥ë¥É¤¬¿ôÃÍ·¿¤Ç¤Ê¤¤¤È¤¤¤±¤Þ¤»¤ó¤¬¡¢HSQLDB¤ÎSQL¤Ë¤Ï·¿ÊÑ´¹´Ø¿ôCAST¤âÍѰդµ¤ì¤Æ¤¤¤Þ¤¹¡£¥¯¥¨¥ê¡¼¥Ç¥¶¥¤¥ó¤Î¥Õ¥£¡¼¥ë¥ÉÍó¤ÎÀßÄê¤ò¡ÖCAST ( "¥Æ¥­¥¹¥È·¿¤Î¥Õ¥£¡¼¥ë¥É" AS NUMERIC )¡×¤È¤¹¤ì¤Ð¡¢·×»»¤Ï²Äǽ¤Ç¤¹¡£É¬¤º¤·¤â¡Ö¤À¤á¡×¤È¤¤¤¦¤ï¤±¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£

¥¨¥é¡¼¤¬½Ð¤Æ¤·¤Þ¤¤¤Þ¤¹¡£

kimura (2009-09-24 13:57:20 (ÌÚ))

­¡¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×
­¢¡Ö¤¤¤Ã¤¿¤óCalc¤Î¥·¡¼¥È¤Ø½ñ¤­½Ð¤·¡¢¤½¤ì¤ò¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥ó¥Ð¡¼¥È¡×¤Ç¤â¤È¤ËÌ᤹¡£
¤ò¹Ô¤¤¤Þ¤·¤¿¤¬¡¢°Ê²¼¤Î¤è¤¦¤Ê¥¨¥é¡¼¤¬½Ð¤Æ¤·¤Þ¤¤¡¢¤¹¤Ç¤ËÆþÎϺѤߤΥǡ¼¥¿¤¬°Ü¤»¤Þ¤»¤ó¤Ç¤·¤¿¡£
¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý
SQL ¥¹¥Æ¡¼¥¿¥¹: 37000
¥¨¥é¡¼¥³¡¼¥É: -16

Wrong data type: java.lang.NumberFormatException: For input string: ""
¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý¡Ý
ºÇ½é¤Ë¼ÁÌ䤵¤»¤Æ¤¤¤¿¤À¤¤¤¿¡¢¡¢¡Ö¿ôÃÍ¡ÎNUMERIC¡Ï¡×¤Ø¤ÎÊѹ¹¤À¤±¤Ç¤Ê¤¯¡¢
¤¢¤Á¤³¤Á¥Æ¥­¥¹¥È[VARCHAR]¡×¤ò¡Ö¥Æ¥­¥¹¥È[¡Ê¸ÇÄê¡ËCHAR]¡×¤Ë¤·¤¿¤ê¡¢¥Õ¥£¡¼¥ë¥ÉŽÀ޲ŽÌŽß¤ò½¤Àµ¤·¤¿¤Î¤Ç¤¹¤¬¡¢¤½¤Î¤»¤¤¤Ç¤·¤ç¤¦¤«¡£
¤ª¼ê¿ô¤ò¤ª¤«¤¨¤·¤Æ¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£

¥Õ¥£¡¼¥ë¥É¥¿¥¤¥×¤Î¥ß¥¹¥Þ¥Ã¥Á

M.Kamataki (2009-09-24 15:57:09 (ÌÚ))

¼ÂºÝ¤Î¥Ç¡¼¥¿¤ò¸«¤Æ¤¤¤Ê¤¤¤Î¤Ç³Î¼Â¤Ç¤Ï¤Ê¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡¢¥³¥Ô¡¼´ð¤ÈޤêÉÕ¤±Àè¤Î¥Æ¡¼¥Ö¥ë¤Î¤Ê¤ó¤é¤«¤Î¥Õ¥£¡¼¥ë¥É¥¿¥¤¥×¤Î¥ß¥¹¥Þ¥Ã¥Á¤¬µ¯¤­¤Æ¤¤¤ë¤È»×¤ï¤ì¤Þ¤¹¡£

ÌÀ¼¨¤µ¤ì¤¿¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤ÇÄ´¤Ù¤ë¤È°Ê²¼¤ÎOOoForum¤Î¼ÁÌ䤬°ú¤Ã¤«¤«¤ê¤Þ¤·¤¿¡£º£²ó¤Î¤´¼ÁÌä¤Ë»÷¤Æ¤¤¤Þ¤¹¤Í¡£¥Õ¥£¡¼¥ë¥É¥¿¥¤¥×¤ò¥Æ¥­¥¹¤«¤éÀ°¿ô¤ËÊѹ¹¤¹¤ëºÝ¤ÎÌäÂê¤Ç¤¹¤¬¡¢NULLÃ͡ʶõʸ»ú¡Ë¤¬¥Õ¥£¡¼¥ë¥É¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤¿¤Î¤¬¸¶°ø¤Î¤è¤¦¤Ç¤¹¡£

[Solved] How do I convert data types - text to numeric?
http://www.oooforum.org/forum/viewtopic.phtml?t=77304

¤Ê¤ª¡¢ÌÀ¼¨¤µ¤ì¤¿¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤Ï¥Õ¥£¡¼¥ë¥É¥¿¥¤¥×¤ò¥Æ¥­¥¹¥È¤«¤é¡ÖÀ°¿ô[INTEGER]¡×¤ËÊѹ¹¤·¤¿¥Õ¥£¡¼¥ë¥É¤Çµ¯¤­¤ë¤è¤¦¤Ç¤¹¡£¤ï¤¿¤·¤¬»î¤·¤¿¤È¤³¤í¡¢À°¿ô¤Ë¤·¤è¤¦¤È¤·¤¿¥Õ¥£¡¼¥ë¥É¤Ë¾®¿ôÅÀ¤ò´Þ¤ó¤À¥Ç¡¼¥¿¤¬¤¢¤Ã¤¿¾ì¹ç¤Ï¼¡¤Î¤è¤¦¤Ê¥¨¥é¡¼¤¬É½¼¨¤µ¤ì¤Þ¤·¤¿¡£

Wrong data type: java.lang.NumberFormatException: For input string: "12.3"

¤³¤Î¤³¤È¤«¤é¤ä¤Ï¤êNULLÃ͡ʶõʸ»ú¡Ë¤Îµ¿¤¤¤¬Ç»¤¤¤È»×¤¤¤Þ¤¹¡£

¥¨¥é¡¼¤ÏCalc¤«¤é¤Î¥³¥ó¥Ð¡¼¥È»þ¤Ëµ¯¤­¤¿¤È¤¤¤¦¤³¤È¤ÇÎɤ¤¤Ç¤·¤ç¤¦¤«¡£¼Â¤Ï¡¢¤ï¤¿¤·¤¬ºÇ½é¤Ë½ñ¤¤¤¿¥Æ¡¼¥Ö¥ëA¤ò¥³¥Ô¡¼¤·¡¢¥Æ¡¼¥Ö¥ëB¤ËޤêÉÕ¤±¤ëÊýË¡¤Ç¤Ï¡¢NULLÃ͡ʶõʸ»ú¡Ë¤¬¤¢¤Ã¤Æ¤â¥¨¥é¡¼¤Ë¤Ï¤Ê¤ê¤Þ¤»¤ó¤Ç¤·¤¿¡£

¥Õ¥£¡¼¥ë¥É¥Õ¥©¡¼¥Þ¥Ã¥È¤òÊѹ¹¤¹¤ëºÝ¡¢¡ÖÆþÎϤ¬É¬Íס×Íó¤ò¡Ö¤Ï¤¤¡×¤Ë¤¹¤ë¤È¡¢NULLÃ͡ʶõʸ»ú¡Ë¤ÇÅöÁ³¥¨¥é¡¼¤Ë¤Ê¤ê¤Þ¤·¤¿¤¬¡¢¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤Ï°Û¤Ê¤ë¤â¤Î¤Ç¤·¤¿¡£

¤³¤Î¤³¤È¤«¤é¡¢¤Ê¤ë¤Ù¤¯Calc¤ò·Ðͳ¤·¤Ê¤¤¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×¤òÍøÍѤ·¤¿¤Û¤¦¤¬Îɤ¤¤È»×¤¤¤Þ¤¹¡£

¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£

kimura (2009-09-25 11:40:02 (¶â))

³Î¤«¤ËCalc¤«¤é¤Î¥³¥ó¥Ð¡¼¥È»þ¤Î¤â¤Î¤Ç¤¹¡£

ºÇ½é¤Ë¶µ¤¨¤Æ¤¤¤¿¤À¤¤¤¿¥Æ¡¼¥Ö¥ë¥³¥Ô¡¼¤ò»î¤·¤Æ¤ß¤Æ¥¨¥é¡¼¤Ë¤Ê¤ê¡¢¼¡¤ËCalc¤«¤é¤Î¥³¥ó¥Ð¡¼¥È¤ò¤·¤Æ¤ß¤ë¤È¥¨¥é¡¼¤Ë¤Ê¤ê¡¢¸å¼Ô¤Î¥¨¥é¡¼¥³¡¼¥É¤ò½ñ¤­Î±¤á¤Æ¼ÁÌ䤵¤»¤Æ¤¤¤¿¤À¤­¤Þ¤·¤¿¡£
¤½¤·¤Æ¡¢¤½¤Î»þ¤ÎCalc¤«¤é¤Î¥³¥ó¥Ð¡¼¥È»þ¤Ë¡¢¿§¡¹ÊѤ¨¤¿Ãæ¤Ç¡¢¥Õ¥£¡¼¥ë¥É¥¿¥¤¥×¤ò¥Æ¥­¥¹¥È¤«¤é¡ÖÀ°¿ô[INTEGER]¡×¤ËÊѹ¹¤·¤¿¥Õ¥£¡¼¥ë¥É¤â¤¢¤ê¡¢¤½¤³¤¬°ìÉô¶õʸ»ú¤Ë¤Ê¤Ã¤Æ¤Þ¤·¤¿¡£

ËÜÆü¡¢ºÆÅÙ¡¢¥³¥Ô¡¼¸µ¤ÈޤêÉÕ¤±Àè¤Î¥Æ¡¼¥Ö¥ë¤Î¥Õ¥£¡¼¥ë¥É¥¿¥¤¥×¤ò³Îǧ¤·¤Ê¤¬¤é¡¢Calc¤ò·Ðͳ¤·¤Ê¤¤¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×¤òÍøÍѤ·¤¿¤È¤³¤í¡¢
Àµ¾ï¤Ë¥³¥Ô¡¼¤¬½ÐÍè¤Þ¤·¤¿¡£

¤¤¤Ä¤â¤ª¼ê¿ô¤ò¤ª¤«¤±¤·ÂçÊѤ⤦¤·¤ï¤±¤¢¤ê¤Þ¤»¤ó¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£

¤ªÌ¾Á°:
Âê̾: