Bug 169992 - (Enhanced) Change font settings in VBA macros
Summary: (Enhanced) Change font settings in VBA macros
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA Language-Grouping
  Show dependency tree / graph
 
Reported: 2025-12-16 03:30 UTC by Saburo
Modified: 2025-12-16 03:31 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
testfile.xlsm (12.20 KB, application/vnd.ms-excel.sheet.macroenabled.12)
2025-12-16 03:30 UTC, Saburo 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Saburo 2025-12-16 03:30:07 UTC 
Description:
I run a VBA macro in Calc, but get different results than in Excel.
e.g. Range("A1").Font.Size = 20
The font size for Western languages ​​is changed, but the font size for Asian and complex languages ​​is not changed.
This could easily be fixed by someone with the skills to modify source code, but I thought it should be fixed for those who don't.
The same goes for changing the font to a different one.

Steps to Reproduce:
1. Open an attachment
2. Run macro 'fontsizechange'
3.

Actual Results:
Only Western language numbers are resized

Expected Results:
All font sizes are changed


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: 680(Build:0)
CPU threads: 8; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: threaded
Comment 1 Saburo 2025-12-16 03:30:31 UTC 
Created attachment 204663 [details]
testfile.xlsm