DATA GROUP/UNGROUP

Discuss the spreadsheet application
Post Reply
Bataj
Posts: 1
Joined: Fri Jan 25, 2008 8:43 am

DATA GROUP/UNGROUP

Post by Bataj »

Hello

Can anybody help me ?

My grouped rows contains some form controls in one column cells (check or radio buttons) anchored to cells. When group command was applied they were ordered one over each other so I can access to the last bottom control. But after ungrouping they keep their grouped position. Where is the problem, may be I use wrong embeding command. However, I tried open this grouped worksheet in MS Excel and everything works fine.

Thanks for any hint.
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: DATA GROUP/UNGROUP

Post by Villeroy »

1. This is not Excel, never has been Excel and -most important- never will be Excel. This is the spreadsheet component of a completely different office application. This component tries to mimic some of (old) Excel's look and feel and tries to do a good job when loading Excel documents.
2. Yes, all the objects that can be attached to a draw page of a sheet behave weird when the underlying cells move or hide. Simply use hyperlinks instead of push buttons, true/false values instead of check boxes and list-validation instead of list boxes. Form controls don't behave well in a "living spreadsheet" with moving cells. Their main purpose is to be used in data aware forms connected to databases.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply