A Telegram bot @krutiunicodebot is available for this purpose.
Although this is not what you asked, thought it might be useful to someone else.
A Telegram bot @krutiunicodebot is available for this purpose.
Although this is not what you asked, thought it might be useful to someone else.
I also need one unicode to kruti dev
These are two Telegram bots that you may find useful:
@krutiunicodebot – KrutiDev to Unicode
@unicodekrutibot – Unicode to KrutiDev
This is off-topic. Please email me for more information (address in my profile).
This isn’t about any cells, but about te conversion:
Yes. Of course.
We got many pages of code containing a kind of conversion table.
But we did not get a simple plain text file (“ascii” style) with an example of a short (not too short) text coded in Kruti Dev.
I don’t understand this.
In spreadsheets you can select any SheetCellRanges (plural!) which includes the case of many single cells. You then can apply a converting macro to the string of every selected cell, and you can preselect cells by assigning a specific cell style.
TextTables don’t allow the selection of non-contiguous ranges, and there are no cell styles. How to preselect cells needing to get processed: Study the attached example.
(This is independent of whatever macro you want to apply to the mentioned cells.)
disask_127582_PreselectTTcells.odt (19.2 KB)
1st prototype for Writer, test it dutifully because it wasn’t easy to made it. It uses com.sun.star.util.TextSearch and there was also some problem with move of TextCursor (method .goLeft) in cells for Kruti Dev (Latin script was ok) - it need more tests because it seems as bug in Libre and I probably will test it in next days.
Try 3rd version lower.
@sokol92 maybe it could be faster with next (and not so easy) modification of TreeSort that should does only one pass of replaced string for all replacements. I deleted TreeSort from Github, but actual documentation is on my web with examples in Python - but only in Czech, I still hadn’t time to translate one to English. But I was more dutiful before some years than I remember :-), and it seems I have the functional extended version on disk also in LibreBasic.
I tried it. Very useful. I think the OP should provide a test document.
It is working for Writer. Now please provide for Calc
There are some problems in Calc to keep the formatting in cells, algorithm from Writer tables failed. It seems it will take more days to solve it.
Take your time.
Your table conversion code has been made available as an extension
But this extension is unreliable now, because the arrays OriginalStrings and TargetStrings aren’t sorted according to length(s)
And it is problem! Because the replacements in arrays have different lengths, so for Kruti2Unicode it need the length-sorting according to lengths in TargetStrings, but for Unicode2Kruti according to lengths in OriginalStrings. Really good IQ test :-)! And really convenient for TreeSort, I will try to solve it with TreeSort.
What did I miss?
Is there ONE realistic short example typed/created in kruti dev?
I still also can’t find resonable explanations. There are “online services” and all sorts of suggestions or recommendations, but neither the examples nor the information.
Is kruti dev the secret of the ages?
2nd prototype for Writer, it should be functional also for normal selections in normal text and also for multiselections.
ind-find-replace-in-cells-KL2.odt (49.0 kB)
I removed duplicities from F&R arrays and sorted ones according to lengths, but the conversion still isn’t 100% reliable now
.
F&R in Calc are still problematic 
Not working at all.
It really easy to write only:
But where it doesn’t work? In some cases in my randomly created ODT? Or in some your documents? Where and at what activity?
Nowhere. I tried to type some kruti dev and some unicode text in your document. Then select it and try to run macro but it is not converting. I tried it in cells and also tried it in outside the text. After opening your document it is showing error "Please install the hyphenation package for locale “hi-IN”. Does it has something to do with the functioning of the macro.
Did you run the macro(s) KrutiUnicode or UnicodeKruti? Because it is fully functional for me
The message with hyphenation package is because you didn’t upload example ODT with KrutiDev and Unicode, so I randomly copied some parts from substitution-arrays and selected lines with ones as Hindu language with the font Lohit Devanagari (because without this font it wasn’t well-visible for me). But it hasn’t influence on macro running.
Edit: I discovered the conversion isn’t 100% reliable in prototype 2 :-(, sometimes there are some problems after conversion for Kruti2Unicode and then back Unicode2Kruti.
There are the collisions in substitution table! It is about 70 collisions that causes the bad transformation.
conversion-table.ods (33.9 kB)
Run the macro Module2 / findProblems from ODS to see the lines and Ascii codes of problematic substitutions. Then it need fix all these problematic substitutions.
It is working. You need to select Unicode text and choose the macro replaceInWriter macro. It will convert the Unicode text to Krutidev. But KrutiUnicode or UnicodeKruti macros are not working.