[ILUG-BOM] Open Office Solution Required

[Rony]

Hello All,

An OO user in Windows is facing some problems with Spreadsheet. He uses 
the .xls format.

Problem 1: His file consists of many rows and columns. Cells in each row 
are related to each other. Now in Excel he can sort columns individually 
and during each sorting, entire rows get sorted. So after every sort, 
the cells in each row are the same. It is the entire row that gets 
sorted. In OO he can sort columns but it sorts cells in that column only 
and this breaks the row and ultimately the table cells get cross connected.

Problem 2: In Excel, he can secure a file but allow partial changes like 
changing the cell background colour. This is needed as his job status 
indicator is colour coded as the job progresses. His employees can only 
change colours as they progress with the job. In OO he can secure a file 
but it is like ON/OFF. Once secure, no partial changes are allowed.

Any help will be greatly appreciated.

-- 
Regards,

Rony.

Knock Knock
Who's There?
Linux
Who Linux?
GNU/Linux