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: dev@poi.apache.org
Reporter: gallon.fi...@gmail.com
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: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
