[Issue 126435] New: Consistent incorrect results from many CELL() functions

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126435

          Issue ID: 126435
        Issue Type: DEFECT
           Summary: Consistent incorrect results from many CELL()
                    functions
           Product: Calc
           Version: 4.1.1
          Hardware: PC
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: major
          Priority: P5
         Component: programming
          Assignee: issues@openoffice.apache.org
          Reporter: jgibbons2953@gmail.com

Created attachment 84842
  --> https://bz.apache.org/ooo/attachment.cgi?id=84842&action=edit
OO Calc Wksht with CELL() error examples

Running Calc from AOO411m6(Build:9775) - Rev. 1617669 [13 Aug 2014] on an ASUS
M11AD desktop, all of the following CELL() variants display a single digit (1)
as the incorrect result.  All entries are located in column X of the attached
worksheet.

=CELL("COL";J12)       =CELL("SHEET";A8)     =29+CELL("ROW")
=CELL("ROW";M12)       =CELL("COL")          =CELL("ROW")

I suspect that other INFORMATION functions are behaving similarly, such as
ROW(), COLUMN() and ADDRESS().

I've saved the sheet in both .ODS and .XLS format with no change in results.  I
have also de- and re-installed the entire OO application from Apache's download
server, with system reboots between each step.

I'm willing to take the heat if I've overlooked some obscure footnote or done
something stupid in setting up these functions.  Right now, though, my project
is at a halt unless I can programmatically reference specific cells by row and
column, relative to the current cell's address.

Thank you, one and all, for all that you do for our Open Office community!

//jm

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126435] Consistent incorrect results from many CELL() functions

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126435

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_ISSUE
                 CC|                            |damjan@apache.org

--- Comment #1 from damjan@apache.org ---
If you right-click any or all cells between X6 and X15, and choose "Format
Cells...", you'll see the Category is "User-defined", and the Format "1".

Right click the cells, "Clear Direct Formatting", and it works. Resolving
not_an_issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.