attachment to demonstrate the issue - it is not possible for the cells in B & C columns below the split line to point to the other sheets' values without manually typing the sheetname and cell address.
column freeze bug.ods (application/vnd.oasis.opendocument.spreadsheet), 12.38 KB, created by chl207 on 2008-08-15 04:42:37 UTC
(hide)
 
Creator: chl207
Created: 2008-08-15 04:42:37 UTC
Size: 12.38 KB

The attachment is not viewable in your browser due to security restrictions enabled by your Apache OpenOffice (AOO) Bugzilla administrator.

In order to view the attachment, you first have to download it.

Actions: View
Attachments on issue 92479: 55571 | 55795