https://bugs.documentfoundation.org/show_bug.cgi?id=150464
Bug ID: 150464
Summary: calc macro using uno:numberformatvalue displays
different formats in cell on different spreadsheets
and computers for the same value
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The macro as follows
Sub srCellFormat(sSpread As String, sCellRange As String, iFormatType As
Integer)
Dim oDocument As Object
Dim oDispatcher As Object
srSetActiveSheet(sSpread)
oDocument = ThisComponent.CurrentController.Frame
oDispatcher =
createUnoService("com.sun.star.frame.DispatchHelper")
Dim aArgs1(0) As New com.sun.star.beans.PropertyValue
aArgs1(0).Name = "ToPoint"
aArgs1(0).Value = sCellRange
oDispatcher.executeDispatch(oDocument, ".uno:GoToCell", "", 0,
aArgs1())
Dim aArgs2(0) As New com.sun.star.beans.PropertyValue
aArgs2(0).Name = "NumberFormatValue"
aArgs2(0).Value = iFormatType
oDispatcher.executeDispatch(oDocument, ".uno:NumberFormatValue", "", 0,
aArgs2())
End Sub
Before I upgraded to Linux Mint Mate 21 and LO 7.3.5.2 it was working correctly
with a value of 155 to give a format in dollars to 6 decimal places. Now it
requires 109 or 110 and it will work when it wants to or even give a format to
3 decimal places
Steps to Reproduce:
1. Run the included macro using the following
2. sSpread is the sheet name, sCellRange is for example "A1" and iFormatType
is value to give the required number format
3.
Actual Results:
Instead of giving the required format it does what it pleases
Expected Results:
The cell to be format to dollars with 6 decimal places
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Give a correctly formatted cell to give the spreadsheet a good structured
appearance
Version: 7.3.5.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.5-0ubuntu0.22.04.1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
