質問する

mmasroorali's profile - activity

2019-02-09 18:24:08 +0200 バッジを受け取った  卓越した質問 (source)
2019-02-09 16:34:46 +0200 ベストアンサーマーク Add xlam file to LibreOffice Calc

How can I use add existing XLAM file (an Excel Macro-Enabled Add-In file that's used to add new functions to Excel) to LibreOffice Calc?

For example, here is an XLAM file which I would like very much to use.

Any help will be appreciated.

2019-02-09 16:19:09 +0200 コメント付き回答 Add xlam file to LibreOffice Calc

While going through the tutorial for "en", some string caught my eye. Found eventually that using the language en-IN se

2019-02-09 13:44:18 +0200 バッジを受け取った  人気の質問 (source)
2019-02-09 12:20:13 +0200 コメント付き質問 Add xlam file to LibreOffice Calc

That one works fine. But it does not take care of the local number system (crore, lakh) that has been used in the repor

2019-02-09 11:43:51 +0200 バッジを受け取った  解説者
2019-02-09 11:43:51 +0200 コメント付き質問 Add xlam file to LibreOffice Calc

Sorry. missed that one. Feel like a fool. Will give it a try and report back here.

2019-02-09 10:54:24 +0200 コメント付き質問 Add xlam file to LibreOffice Calc

But how that web interface can be used in LibreOffice Calc?

2019-02-09 10:04:46 +0200 質問をする Add xlam file to LibreOffice Calc

Add xlam file to LibreOffice Calc How can I use add existing XLAM file (an Excel Macro-Enabled Add-In file that's used t

2015-11-16 14:28:03 +0200 バッジを受け取った  有名な質問 (source)
2015-11-13 08:52:17 +0200 ベストアンサーマーク Incorrect CTL font rendering by LibreOffice 4

This issue has been raised before and looks like we have an accepted answer. But the answer does not actually solve the problem. It tries to blame some font.


(UPDATE: Further discussion shows that the particular (blamed) font, SutonnyMJ is actually broken. But that font is not part of my following discussion. SutonnyMJ is a non-Unicode font and hence obsolete with its own inherent problems. The fonts, SolaimanLipi and SutonnyOMJ, mentioned in the following discussion are both Unicode fonts.)


The issue is, it appears that LibreOffice 4 is rendering CTL (Bangla/Bengali) fonts incorrectly.

Please see the following Bengali/Bangla text as rendered in LibreOffice 3. The interword spaces are fine. This documents uses two fonts, SolaimanLipi and SutonnyOMJ

image description

I have using the first font for a quite a long time. In fact this is the most popular font used the newspapers and websites in Bangladesh. Moreover, this font, along with the second one, has been chosen (gazetted) as one of the standard fonts to be used in all government documents.

Anyway, when the same file in opened in LibreOffice 4, we find that the inter word spaces are garbled, bottom part of characters are missing and some characters are shown as empty boxes.

image description

But when we open the same document in OpenOffice, there is no problem at all. Please see below,

image description

Even more, when the same text is displayed in Google Chrome using SolaimanLipi font, there is no problem at all. Please see below,

image description

As my experience goes over all these years, I can unequivocally confirm that the above mentioned problem is solely due to LibreOffice 4. This problem occurs irrespective of the input method, be it keyboard or cut-and-paste. Moreover, these fonts present absolutely no problem in the commercial word processing software.

I have correctly set the CTL language and CTL font in all the cases.

I find that two bugs, with insufficient or misdirected attention, have been lodged here (one, two). Please see the comment in the first one, which is absolutely incorrect.

Please let me know if you any observation or advice. Also, please let me know how do I bring more attention to the bugs already reported.

You can find the .odt file which has been used for test purpose over here.

2015-10-05 01:25:08 +0200 バッジを受け取った  有名な質問 (source)
2015-08-25 14:38:16 +0200 バッジを受け取った  卓越した質問 (source)
2015-06-22 17:30:32 +0200 バッジを受け取った  人気の質問 (source)
2015-06-21 23:03:16 +0200 コメント付き回答 How do I write the word iTransfer in LibreOffice Calc?

I tried all the steps I could think of, including replacements. Now it works without any tweaking.

2015-06-21 22:47:22 +0200 コメント付き回答 How do I write the word iTransfer in LibreOffice Calc?

No problem at this end either, tested more than once. I spent more than ten minutes this morning trying to write iTransfer in a cell, without success. Feeling like a fool.

2015-06-21 19:27:18 +0200 質問をする How do I write the word iTransfer in LibreOffice Calc?

The question is really simple. How do I write the word iTransfer in LibreOffice Calc?

Whenever I write it, it gets auto corrected to ITransfer. The initial small i gets transformed into capital I.

I have tried various options at Auto Correct settings (exceptions mainly), without success.

Please understand that general solutions like turning off auto correct completely, or some other general solution with a narrower range is not an option.

How do I keep all other options unchanged and have an exception only for this one?

2015-06-21 19:24:46 +0200 質問をする How do I write iTransfer in LibreOffice Calc?

The question is really simple. How do I write the word iTransfer in LibreOffice Calc?

Whenever I write it, it gets auto corrected to ITransfer. The initial small i gets transformed into capital I.

I have tried various options at Auto Correct settings (exceptions mainly), without success.

Please understand that general solutions like turning off auto correct completely, or some other general solution with a narrower range is not an option.

How do I keep all other options unchanged and have an exception only for this one?

2014-09-29 10:44:35 +0200 バッジを受け取った  卓越した質問 (source)
2014-09-29 10:44:35 +0200 バッジを受け取った  有名な質問 (source)
2014-07-21 03:11:46 +0200 バッジを受け取った  有名な質問 (source)
2014-07-12 18:09:21 +0200 バッジを受け取った  人気の質問 (source)
2014-07-12 18:09:21 +0200 バッジを受け取った  卓越した質問 (source)
2014-05-12 15:01:05 +0200 バッジを受け取った  有名な質問 (source)
2014-02-22 23:40:28 +0200 バッジを受け取った  有名な質問 (source)
2014-02-22 23:40:28 +0200 バッジを受け取った  卓越した質問 (source)
2014-01-26 23:21:56 +0200 バッジを受け取った  人気の質問 (source)
2014-01-26 15:25:00 +0200 コメント付き回答 Use Image in LibreOffice Calc Header

Thanks. That did the trick. Though I have to presize the image, LO does not provide an option to set the image to some particular size, the situation is saved.

2014-01-26 14:27:02 +0200 質問をする Use Image in LibreOffice Calc Header

I want to use an image in the left header area. The center area will contain other header texts.

How do I do this?

Format Page -> Header -> Edit do not show any option to add an image.

2014-01-08 09:42:14 +0200 バッジを受け取った  有名な質問 (source)
2013-12-11 10:37:22 +0200 バッジを受け取った  卓越した質問 (source)
2013-12-08 10:31:24 +0200 バッジを受け取った  人気の質問 (source)
2013-12-08 01:44:03 +0200 コメント付き回答 Format cell to show date (completely) in another language

It did not work. System or Context keep the numbers unchanged. Hindi produced Arabic (yes, from Arabic language, not Arabic system) numerals.

2013-12-07 16:08:12 +0200 質問をする Format cell to show date (completely) in another language

If I go to Format Cells and set the format as shown below, I can get the date (partially) in Bengali.

image description

But the problem is, the numbers are still in English. See here.

image description

Is there an way I can get the numbers in Bengali as well?

I tried changing the font to some Bengali font, without avail.

Thanks in advance.

2013-11-26 16:45:02 +0200 バッジを受け取った  人気の質問 (source)
2013-11-26 15:09:04 +0200 質問をする How do I correctly parse a range of dates?

Please see the followong excerpt from a calc file. It has around four hundred entries. I got these entered by a data entry operator using Excel in another machine. Now this file has been saved as .ods in my machine.

image description

The first column contains serial numbers. The second column contains dates. The second column entries need to be interpreted as, D/M/Y. However, if I set the column format as Date, those with a number in the range (1-12) before the first /, are being parsed as M/D/Y (102-106, 109-111). And those with a number greater than 12 before the first /, remain unparsed (107,108).

I want the second column to be parsed as D/M/Y. So, the first one with serial 102 should be parsed as Nov 11 2013, the third one with serial 104 should be parsed as Nov 6 2013, and the one with serial 107 should be parsed as Nov 13 2013. As you can see, the sheer volume makes any manual operation prohibitive.

Do you think you can point me to some function, or a sequence of operations to correctly parse the date texts?

Thanks in advance.

2013-11-23 03:39:57 +0200 バッジを受け取った  卓越した質問 (source)
2013-11-22 11:38:20 +0200 コメント付き回答 How do I delete multiple page styles?

@mariosov Perhaps I will wait for the stable version to come out. I am afraid to try the unstable new version since my 4.1 does not let me delete even a single style. I click on delete, the style remains there without any error message.

2013-11-22 03:52:01 +0200 バッジを受け取った  人気の質問 (source)
2013-11-21 11:41:31 +0200 質問をする How do I delete multiple page styles?

I have an .ods file with many page styles. I want to delete some of these styles.

image description

From the page styles shown, I want to delete all of them except the first and the last one.

I know that I can click on one, either press right mouse button and select Delete or press the Delete button, and then answer Yes if necessary. But is there any way to delete multiple page styles at a time? I tried Shift-click and Ctrl-click without any avail.

2013-11-21 11:35:12 +0200 質問をする Import/export page style from/to another .ods file

I have a certain page style defined in one .ods file. I can view them by pressing either the F11 button or clicking on the appropriate icon.

image description

Among the page styles defined, I want to export the highlighted page style to another file or import it from another file.

Could you please tell me how I can do this?

2013-11-15 13:13:49 +0200 バッジを受け取った  卓越した質問 (source)