Apache OpenOffice (AOO) Bugzilla – Issue 101704
Shared Workbook Problem
Last modified: 2014-01-12 09:40:42 UTC
Earlier I was using Shared Workbook feature in Excel; everything was fine. But problem started as soon as I swiched OOo 3.0.1 and Shared the same Workbook (after converting in .ods). Whenever people working on at said Workbook inserts or deletes rows, the whole Worksheet works unexpectedly. I am using formulas in many of the cell. Some time conflict is being shown for the same user who has changed & saved the Worksheet while other users are viewing or entering the data. If the user selects Keep All Mine option the cell shows error (as it contains formula). I got another problem, despite of changing the cell date format to DD/MM/YYYY what ever date we enter (before 13) it gets converted in MM/DD/YYYY other wise it works fine. While i use the auto filter the sequence of dates not proper for example if I have entered 01-04-2009, 10-04-2009 and 01-05-2009 in the of auto filter the sequence is 01-04-2009, 01-05-2009 and 10-04-2009. Your earliest reply is awaited.