Bug 165970 - Division of 1 cell
Summary: Division of 1 cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.5.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL: t.me
Whiteboard: none
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2025-03-29 20:40 UTC by ouiouioie@mailfence.com
Modified: 2025-08-24 18:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
a screenshot of cells in different rows. (43.41 KB, image/png)
2025-03-29 22:21 UTC, ouiouioie@mailfence.com
Details
with marker (52.39 KB, image/png)
2025-03-29 22:24 UTC, ouiouioie@mailfence.com
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ouiouioie@mailfence.com 2025-03-29 20:40:49 UTC
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
Comment 1 ouiouioie@mailfence.com 2025-03-29 22:21:59 UTC
Created attachment 200085 [details]
a screenshot of cells in different rows.

I wanted to attach one more screenshot but this page don't allow to attach more then one so you can open via link to my group in telegram.

also thek you very much developers for open source free soft. Wishing everything goof to you
Comment 2 ouiouioie@mailfence.com 2025-03-29 22:23:17 UTC
if you need to contact me: t.me/yojiknadache .
Comment 3 ouiouioie@mailfence.com 2025-03-29 22:24:34 UTC
Created attachment 200086 [details]
with marker
Comment 4 ouiouioie@mailfence.com 2025-03-29 22:28:32 UTC
thanks.