You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2017/01/20 19:39:03 UTC
[Issue 127292] New: Cell.Formula in Macro is empty, though I just
typed a value in the cell.
https://bz.apache.org/ooo/show_bug.cgi?id=127292
Issue ID: 127292
Issue Type: DEFECT
Summary: Cell.Formula in Macro is empty, though I just typed a
value in the cell.
Product: Calc
Version: 4.1.3
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: ambusy@gmail.com
Target Milestone: ---
Created attachment 85931
--> https://bz.apache.org/ooo/attachment.cgi?id=85931&action=edit
Problem description with screen shots.
The contents of Cell.Formula while in a Macro is not the same as the text shown
on the Calc.
I enter a number 11 in a cell and after the last digit I press F12 to activate
a macro.
The macro shows the cell.formula as empty, whereas it should be “11”.
If I execute the macro in debug step by step the value is 11, it looks as if
something happens to the cell's object, when the screen looses focus. Only
using msgbox I was able to understand the nature of the problem.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127292] Cell.Formula in Macro is empty, though I just typed a
value in the cell.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127292
--- Comment #2 from ambusy@gmail.com ---
I have no idea how to do that, I saw the possibility to add an attachment, so I
made a container for the images.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127292] Cell.Formula in Macro is empty, though I just typed a
value in the cell.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127292
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
Why attach an ODT with screenshots?
Save our time and attach directly this pictures here.
Thanks to provide a sample ODS with your macro to reproduce.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127292] Cell.Formula in Macro is empty, though I just typed a
value in the cell.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127292
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 127292] Cell.Formula in Macro is empty, though I just typed a
value in the cell.
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=127292
mroe <mr...@gmx.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #3 from mroe <mr...@gmx.net> ---
http://www.openoffice.org/api/docs/common/ref/com/sun/star/table/XCell.html#getType
http://www.openoffice.org/api/docs/common/ref/com/sun/star/table/CellContentType.html
If you get a cell object Cell, you can use something like
Dim lLong As Long
lLong = Cell.getType()
Select Case lLong
Case com.sun.star.table.CellContentType.VALUE
MsgBox( "Numeric: " & Cell.getValue() )
Case com.sun.star.table.CellContentType.TEXT
MsgBox( "String: " & Cell.getString() )
Case com.sun.star.table.CellContentType.FORMULA
MsgBox( "Formula: " & Cell.getFormula() )
Case Else
MsgBox( "Nothing." )
End Select
Please discuss problems first at a user forum!
--
You are receiving this mail because:
You are the assignee for the issue.