¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤µ¤ì¤Æ¤¤¤ë¥Ç¡¼¥¿¤òCalc¤Ø †
¥Ú¡¼¥¸ | OpenOffice.org FAQ¤ÎÅÐÏ¿¥Ú¡¼¥¸ |
---|---|
Åê¹Æ¼Ô | kimura |
ʬÎà | |
Í¥Àè½ç°Ì | |
¾õÂÖ | |
¥«¥Æ¥´¥ê¡¼ | |
Åê¹ÆÆü | 2009-09-18 11:13:28 (¶â) |
OS | Windows vista |
°Í¸¤¹¤ë¥Ú¡¼¥¸ | |
¥Ð¡¼¥¸¥ç¥ó |
¥á¥Ã¥»¡¼¥¸ †
²óÅú¥Ú¡¼¥¸¤Ç¤Ï¹ÔËö¤Ë¡Ö~¡×¤òÉղ乤ëɬÍפϤ¢¤ê¤Þ¤»¤ó |
½é´üÀßÄ꤬´Å¤¯¡¢¥Õ¥£¡¼¥ë¥É¤Î¥Õ¥£¡¼¥ë¥ÉŽÀ޲ŽÌŽß¤ò¡Ö¥Æ¥¥¹¥È[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¤ò·Ðͳ¤·¤Ê¤¤¡Ö¥Æ¡¼¥Ö¥ë¤Î¥³¥Ô¡¼¡×¤òÍøÍѤ·¤¿¤È¤³¤í¡¢
Àµ¾ï¤Ë¥³¥Ô¡¼¤¬½ÐÍè¤Þ¤·¤¿¡£
¤¤¤Ä¤â¤ª¼ê¿ô¤ò¤ª¤«¤±¤·ÂçÊѤ⤦¤·¤ï¤±¤¢¤ê¤Þ¤»¤ó¡£
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£