Ask Your Question

smbhatt's profile - activity

2017-12-27 12:05:49 +0200 received badge  Student (source)
2015-05-24 19:50:00 +0200 received badge  Famous Question (source)
2015-05-24 19:50:00 +0200 received badge  Notable Question (source)
2015-04-17 07:41:31 +0200 received badge  Famous Question (source)
2014-06-25 22:39:52 +0200 received badge  Famous Question (source)
2014-06-25 22:39:52 +0200 received badge  Notable Question (source)
2014-03-07 18:48:35 +0200 received badge  Famous Question (source)
2014-02-02 21:44:38 +0200 received badge  Famous Question (source)
2013-11-06 11:39:32 +0200 received badge  Famous Question (source)
2013-11-06 11:36:52 +0200 received badge  Popular Question (source)
2013-11-06 11:36:18 +0200 received badge  Scholar (source)
2013-10-29 14:23:19 +0200 received badge  Notable Question (source)
2013-10-29 08:25:59 +0200 received badge  Notable Question (source)
2013-10-29 07:33:48 +0200 received badge  Notable Question (source)
2013-10-29 07:09:53 +0200 answered a question How can I use conditional formatting to filter by?

Difficult to explain. On dfining 'filter' if the column has colours based on some condition, then in the drop down list of filter, you can select that colour to see only those rows hainv that color. You need to see it in Excel to understand. Beautiful utility. Yes it is conditional formatting but LibO doesnot have that type of conditional filter.

2013-10-29 07:07:52 +0200 received badge  Popular Question (source)
2013-10-29 07:06:42 +0200 answered a question Page Formatting on Multiple Pages

My user cannot define a template because after creating the pages, the 'fit to page' % canbe difined on the size of the page.

2013-10-29 06:55:27 +0200 answered a question Opening of old files in Calc

OS: MS Windows 7, MS Excel 2013, LibO: 4.1.2. Opened file by association (double click). Problem heppens in some of the files. No test file. This is a existing file which opens perfectly in Excel but not in LibO. Thanks for your response.

2013-10-24 20:25:34 +0200 received badge  Popular Question (source)
2013-10-24 06:00:44 +0200 received badge  Notable Question (source)
2013-10-22 23:03:10 +0200 received badge  Popular Question (source)
2013-10-22 17:23:35 +0200 received badge  Popular Question (source)
2013-10-22 13:49:39 +0200 asked a question Page Formatting on Multiple Pages

In Calc How to Copy a Page Format to All Pages (sheets) - workbook?

2013-10-22 13:37:31 +0200 answered a question Modify installed product to open office extensions

On Windows Explorer select the .doc file you want to open by default with Libre (single click) and right-click it. Select 'Open With' and select 'Choose Default Program', Select 'LibreOffcie Writer' and Tick the option 'Always use the selected program to open this kind of file'. This will do a permanent association for you. The same can be done for other file extensions.

2013-10-22 13:35:11 +0200 received badge  Editor (source)
2013-10-22 13:32:20 +0200 asked a question Hyperlink auto-update

I cannot set the link update as 'automaic' and it reamins as manual as the option to make it automatic update remains disabled. This should be automatic so that when I open the file, it is updated.

2013-10-22 13:28:31 +0200 answered a question How to set a default date format for all the office applications?

Same problem with me. I have set the default date format as 'DD-MMM-YYYY' in Regional Settign of Windows. Yet LO doesnot setitself to that format. I have to set for each column!!

2013-10-22 13:26:26 +0200 asked a question Convert to Number

no option of Convert to No. From ' in cell (character field).

2013-10-22 13:23:10 +0200 asked a question Opening of old files in Calc

Formula disappears in cell for Migrated file from MS Office to Libare

2013-10-22 13:20:31 +0200 asked a question How can I use conditional formatting to filter by?

How to do a Colour Filter like in Excel 2010?

[Copied from OP's "answer":]

Difficult to explain. On dfining 'filter' if the column has colours based on some condition, then in the drop down list of filter, you can select that colour to see only those rows hainv that color. You need to see it in Excel to understand. Beautiful utility. Yes it is conditional formatting but LibO doesnot have that type of conditional filter.

2013-10-22 13:07:38 +0200 answered a question How to open the files .doc by default with writer

On Windows Explorer select the .doc file you want to open by default with Libre (single click) and right-click it. Select 'Open With' and select 'Choose Default Program', Select 'LibreOffcie Writer' and Tick the option 'Always use the selected program to open this kind of file'. This will do a permanent association for you.

2013-10-09 00:25:01 +0200 received badge  Popular Question (source)
2013-10-07 07:38:51 +0200 asked a question A file of size 43 Mb or above opens only 2 or 3 pages in Cal and Writer. Pl. help.

A file of 47 in Calc and 43 Mb in Writer opens only 2 or 3 pages (Status bar also shows 1 of 3). Excel or Word opens this properly. Why cant I open these files?