教えてgoo Q4271677

http://oshiete1.goo.ne.jp/qa4271677.html

再現確認できる人いますか？

教えてgoo Q4189125(Function Wizard : arg as String)

http://oshiete1.goo.ne.jp/qa4189125.html

[STEPS TO REPRODUCE:]

1. INPUT FOLLOWING FORMULA INTO A1 CELL.

= a / 2

2. MAKE SURE THAT A1 CELL SHOWS #NAME?

3. INPUT FOLLOWING FORMULA INTO B1 CELL.

= ISERROR(A1)

4. MAKE SURE B1 CELL SHOWS TRUE.

5. SELECT C1 CELL

6. LAUNCH FUNCTION WIZARD, AND SELECT ISERROR FUNCTION.

7. PRESS OK

8. SPECIFY A1 AS ARGUMENT

9. PRESS OK

[ACTUAL RESULT]

C1 CELL SHOWS FALSE,
SINCE FORMULA IN C1 CELL IS
= ISERROR ("A1")
BUT NOT
= ISERROR (A1)


[EXPECTED RESULT]

FORMULA IN C1 SHOULD BE
= ISERROR(A1)
AND THE CELL SHOWS TRUE.

教えてgoo Q3378978(countif function param is double)

凄く昔の。追加してなかったみたいなので。

http://oshiete1.goo.ne.jp/qa3378978.html

教えてgoo Q3893747(Excel:Operator >)

http://oshiete1.goo.ne.jp/qa3893747.html
http://q.hatena.ne.jp/1131966697

マジっすか？

教えてgoo Q3080610(Excel 2002:GCD function bug?)

http://oshiete1.goo.ne.jp/qa3080610.html

See below for details.

http://davidvs.blogspot.com/2006/04/bug-in-excel.html

Confirmation with other versions wanted.

I don't get what they say,
but anyway,question above concludes it seems to be the type conversion issue.

=6*0.018*1000 : Double or Float

IF YOU TYPE
=GCD(INT(A2),1000)
THEN EXCEL SHOW RESULT 4 CORRECTLY.
==================

Gnumeric prior to 1.7.0 also has a bug
http://www.gnome.org/projects/gnumeric/announcements/1.7/gnumeric-1.7.0.html
>Fix LCM and GCD for large arguments.

教えてgoo Q3038287(Word 2007:Words counted strangely)

http://oshiete1.goo.ne.jp/qa3038287.html

Validation 2/0

Reporter says,

Reproducible in Word 2007[JPN], Windows XP SP2

Character count on the status bar is same as the number of Word count,not the number of Character count on Character Count Dialog


http://blogs.wankuma.com/naka/archive/2006/11/24/46778.aspx

me, himajin100000, is not a user of Office 2007, so that I cannot test it myself.

#BTW, Where should I post these bugs to?

教えてgoo Q3007869(PowerPoint 2007 prints wrongly)

http://oshiete1.goo.ne.jp/qa3007869.html

Validation 2/0

================
According to the reporter above,
this is not reproducible in PowerPoint 2000 and Illustrator.
With PowerPoint 2007, it is reproducible in different two printers.

STEPS TO REPRODUCE:

1.Draw Lines that has narrower stroke width than 1px.
2.Be sure print preview showing the lines in 1px.
3.Print it.

EXPECTED RESULTS

Drawn lines printed having width less than 1px.

ACTUAL RESULTS

Lines are printed as 1px lines.

============

http://support.microsoft.com/kb/937783/ja

===========
Changelog

2007-12-16:
Fixed 1pt mistaken for 1px
Added Link to MSKB 937783(JA)