[Bug 62947] New: Incorrect screening of [book index] and sheet name(s) in Ref3DPxg/Area3DPxg.toFormulaString()

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 62947] New: Incorrect screening of [book index] and sheet name(s) in Ref3DPxg/Area3DPxg.toFormulaString()

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=62947

            Bug ID: 62947
           Summary: Incorrect screening of [book index] and sheet name(s)
                    in Ref3DPxg/Area3DPxg.toFormulaString()
           Product: POI
           Version: 4.0.x-dev
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Currently in {Ref3DPxg | Area3DPxg}.toFormulaString() each sheet name is
screened with ' ' if necessary, producing results like:
[0]'1screened'!A1, [0]notScreened:'1screened'!A1, etc.

However, Excel behaves differently and screens the entire book+sheet [range]
section if any sheet name needs screening. Thus formatting this part of a
reference string cannot be done recursively but shall be done in one piece.

I have already written a solution and will post a pull request soon.

For now, a simple test case:

    @Test
    public void test() {
        Ref3DPxg instance = new Ref3DPxg(
                0,
                new SheetIdentifier("book", new NameIdentifier("1screened",
false)),
                "A1");

        assertEquals("'[0]1screened'", instance.toFormulaString());
    }

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 62947] Incorrect screening of [book index] and sheet name(s) in Ref3DPxg/Area3DPxg.toFormulaString()

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=62947

[hidden email] <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #1 from [hidden email] <[hidden email]> ---
pull request: https://github.com/apache/poi/pull/134

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 62947] Incorrect screening of [book index] and sheet name(s) in Ref3DPxg/Area3DPxg.toFormulaString()

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=62947

PJ Fanning <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #2 from PJ Fanning <[hidden email]> ---
Merged using https://svn.apache.org/viewvc?view=revision&revision=1847418

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]