Open Office

Posted on Updated on

Perusahaan saya telah mulai menggunakan Open Offce dari Februari 2007. Sudah lebih dari 200 PC  saat ini yang telah menggunakan Open Office.  

To many problems occurred, antara lain:

1.       GUI

2.       Habit dari user yang telah terbiasa menggunakan MS Office

3.       Bug dari Open Office

4.       Performance 

Berikut ini adalah bug ataupun komplain dari user: 

Problem

Answer
Why MS-Office is faster then Open Office? Performance?
Why Open Office can’t protect the files with password? Feature?
Why SUMIF formula error when opened with Open Office? Open Office Bugs
Why in Merge Cells, we can’t insert column or rows in Open Office? We need to un-merge cells first then insert columns or rows. (Open Office Bugs)
How to copy value which contains the formula to other worksheet? Copy -> Paste Special -> Choose number or formulas
How to setup comma automatically in Calc? In Excel we found comma icon in menu bar. Calc not provide comma function in menu bar but we can set comma by Click Format Cells then check thousand separator
Why table contains in DOC files are not in place when opened by Open Office? Open Office Bugs?
How to set view of rules in Calc? Open Office Bugs or not provide this function?
When Open Office files with XLS format can’t be publish in Portal? Open Office Bugs?
How to set border in one lines without change other lines in Calc? Open Office Bugs?
Why IF formula can read more then 1 logical (ex: IF (A<1=0,0,1) Open Office Bugs – Critical
Why in Preview mode we can’t edit the documents in Calc? Open Office not provide this utility
Why the formula result is different between MS-Excel and Calc? (Ex: Summary in Excel 200 million but in Open Office 3.2 billion) Open Office Bugs – Critical
Why the formula result is different between MS-Excel and Calc? (Ex: IF formula in Excel 6000 but in Open Office 0) Open Office Bugs – Critical
Why when we create a formula in Open Office and save with XLS format but in MS-Office the formula is error? Open Office Bugs – Critical
Why chart in Excel can’t be read in Open Office (Chart is disappeared)? Open Office Bugs?

 

Apakah dengan Open Office kita dapat meningkatkan performance perusahaan? 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s