https://bugs.documentfoundation.org/show_bug.cgi?id=165970
Bug ID: 165970
Summary: Division of 1 cell
Product: LibreOffice
Version: 24.8.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
how to split 1 cell in libreofice? without having to insert a new column and
then connect every pair of cells except the one that needed to be separated?
lire in MC excel.
EDITING
Steps to Reproduce:
try out to separate one cell in two ones without adding a new column.
Actual Results:
unfortunately you'll need to add a new column and later fuse all new couples of
cells except on the single row that you needed.
Expected Results:
I don;t know how to improve that but deepseek sujested:
Possible solutions:
Use cell pooling (as a temporary crutch):
Create several cells (by inserting rows/columns), then combine the
unnecessary parts.
It's inconvenient, but it works without modifications.
Create a macro or extension:
You can write a script in Python or LibreOffice Basic that automates
row/column insertion and merging.
An example of a simple macro:
basic
Copy
Sub SplitCellVertically()
Dim oSheet As Object
Dim oCell As Object
oSheet = ThisComponent.CurrentController.ActiveSheet
oCell = oSheet.getCurrentSelection()
' Inserting the column on the right
oSheet.Columns.insertByIndex(cell.Cell Address.Column + 1, 1)
End Sub
More complex scripts can simulate "separation" through automatic border
management.
Reproducible: Always
User Profile Reset: No
Additional Info:
screenshots of design-problem: https://t.me/jhauhgy/99
https://t.me/jhauhgy/100
--
You are receiving this mail because:
You are the assignee for the bug.
