Categories
Spreadsheet

Bypass Excel CSV formula Conversion with Operator signs with Simple Practise

You might try to open a CSV file and got error with some columns with error “#NAME?“, it is because of the excel formula conversion issue when there is an operator sign (+, -) in front of the value of the cell as following example: Some solutions may suggest you to put some few spaces…

Categories
Khmer Unicode Spreadsheet

How to Convert MS Excel document of Limon to Khmer Unicode text

I have already illustrated how we convert a MS Word document from Limon to Uniocde here but I haven’t tried out for case of MS Excel document once. As previously stated, it won’t have a straight way to do it without using some tricking steps. I’ll detail about it later… let me know if it…

Categories
Java

Create Openoffice document with template in Java Solution

POI is not supported well to create open office document (calc, spreadsheet), it’s working fine for MS Excel (only). I would clarify my point with POI, it’s not working to set Khmer Unicode font to Openoffice document that could block us to use it well in JODConverter. So another solution should be applied for manipulate…

Categories
VBA

Declare and compare a variable with Khmer unicode string in VBA, excel

Khmer unicode character string is different from other unicode character, we can’t write it on VBA editor of Excel or MS Access.

Categories
Spreadsheet

ភ្លេច Password របស់ File Excel

​ខ្ញុំមាន File សំខានៗ​ជា​ច្រើន​ដែល​ជា File Excel ក៏ ប៉ុន្តែ​ខ្ញុំ​បានភ្លេច Password ទៅហើយ។ ខ្ញុំប្រើ​ MS Excel 2007. តើត្រូវធ្វើយ៉ាងម៉េចទៅ ដើម្បីបើកបាន?