Ask Your Question
0

In LO writer, can I make 10000 to automatically convert to 10,000?

asked 2020-03-30 13:34:58 +0200

Pranav Bbhattarai gravatar image

updated 2020-03-30 13:37:47 +0200

In Indian number system format, like

100
1,000
10,000
1,00,000
10,00,000 ....... and so on.

While solving accounting problems, this can heavily reduce my time. Financial Accounting 2nd sem.odt After a google search, I learned about Tools > Options > Language Setting. I tried to change and see it really separates the numbers after I type; sadly it doesn't do anything. What should I do? What wrong? Settings of LO

LO 6.4.2.2 | Ubuntu 19.10

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-03-30 13:56:46 +0200

ajlittoz gravatar image

Writer, being a document processor, is not well suited for automatic formatting of lakh and crore. You can do that easily in Calc which is primarily number oriented with powerful formatting primitives.

If your format conversion is only to take place inside Writer tables, this can be done like it is in Calc.

Create your table. Enable Table>Number Recognition and "type" the cells with Table>Number Format. Design a new format under Number or Currency category. Format code will be ##,##,##,##,##0.00 with or without currency sign. Put as many ##, groups at head as needed.

BEWARE! From my test, if you erase cell content to type another value, you seem to lose the formatting.

To show the community your question has been answered, click the ✓ next to the correct answer, and "upvote" by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!

In case you need clarification, edit your question (not an answer) or comment the relevant answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-03-30 13:34:58 +0200

Seen: 39 times

Last updated: Mar 30