poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45041] Invalid Formula cell reference when creating formula
Date Tue, 20 May 2008 15:32:14 GMT

--- Comment #5 from Andreas Goetz <cpuidle@gmx.de>  2008-05-20 08:32:13 PST ---
Update- there is a second bug lurking behind the first one. Let me know if I
should open

If you enter two sample lines of data into columns a and b like this:
01.01.2007      100,00
01.01.2008      -250

Excel however I see either #VALUE! or #DIV/0! in the formula field. Entering
the field,
appending a " " character and OKing it fixes the problem and field displays a
value. It
seems Excel is correcting the formula in the background- visually it does not
change by
this process.

Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message