[Issue 127512] textable: cell value is set to "0" on save if cell format does not match written cell value

[bugzilla]

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

--- Comment #3 from oooforum (fr)  ---
(In reply to Oliver Brinzing from comment #2)
> sure, but if a user inputs a string value into cell c2/c3, 
> the cell format will be (re)set to @ automatically, and the 
> value will not get lost during save/reload.
That's happen with UI but not through API

In Tools > Options > Writer > Table, we found:
Input in tables 
 [x] Number format recognition
So, a macro must take care of this parameter.

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

[Issue 127512] textable: cell value is set to "0" on save if cell format does not match written cell value

[bugzilla]

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

Oliver Brinzing  changed:

   What|Removed |Added

 CC||oliver.brinz...@gmx.de

--- Comment #2 from Oliver Brinzing  ---
> For me, input a number or a date must be set with Value property.

sure, but if a user inputs a string value into cell c2/c3, 
the cell format will be (re)set to @ automatically, and the 
value will not get lost during save/reload.

so i would expect setString() will either throw an exception in 
that case, or behave as described above.

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

[Issue 127512] textable: cell value is set to "0" on save if cell format does not match written cell value

[bugzilla]

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

oooforum (fr)  changed:

   What|Removed |Added

 CC||ooofo...@free.fr

--- Comment #1 from oooforum (fr)  ---
For me, input a number or a date must be set with Value property.
This code works as expected:
 oCell = oTable.getCellByName("C1")
 oCell.setString("Hello")
 oCell = oTable.getCellByName("C2")
 oCell.setValue("123.45")
 oCell = oTable.getCellByName("C3")
 oCell.setValue(dateValue("17/08/2017"))

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