Ask Your Question

itsols's profile - activity

2017-07-31 12:18:51 +0200 received badge  Famous Question (source)
2016-12-20 09:35:33 +0200 commented answer Writer - How do I remove the header and footer on some specific pages?

First, many thanks for your answer. Despite your instructions, I found it a bit of a challenge to get this going. I think the interface is not very intuitive and can easily put someone off. I was honestly trying to see if I could run Word 2003 on Ubuntu but couldn't find a genuine copy. Nevertheless, I truly appreciate your answer and the effort of the open source community in making Libre Office possible. Thanks to all!

2016-09-24 09:37:57 +0200 commented answer Validity rules are missing when a Calc file is re-opened.

@mark_t My primary concern was giving the file to a user in Excel format. And your method worked. I literally followed your instructions and put a dot on the last row for every column... As for coming back to ODS, I'm not sure - I did not try it. I guess you're right. It must be a bug. But thanks a lot for your help on this!

2016-09-24 09:35:10 +0200 received badge  Scholar (source)
2016-09-24 04:37:58 +0200 commented answer Validity rules are missing when a Calc file is re-opened.

@rautamiekka when I reopen my ods file, the formatting and rules are all in tact. So mark_t is correct. But the issue is when I save it as Excel.

2016-09-23 19:43:56 +0200 received badge  Notable Question (source)
2016-09-23 18:48:42 +0200 received badge  Popular Question (source)
2016-09-23 07:05:50 +0200 commented answer Validity rules are missing when a Calc file is re-opened.

Thank you mark_t for your answer. That is what I'm using. The drop-down remains when I reopen the file, on rows that have data. But on the blank rows, the drop-downs are gone. Is there something I can do about it? Thanks!

2016-09-23 04:51:19 +0200 asked a question Validity rules are missing when a Calc file is re-opened.

I'm using: Version: 4.2.8.2 Build ID: 420m0(Build:2)

I have created some drop-down boxes and validation rules on the worksheet. I all works fine with data.

I replicate the validation rules to empty cells so that a user may enter new data as per the rules.

But when I reopen the file, there are no validation rules or drop downs. There's just plain cells.

What can I do to get around this?

BTW, I'm saving it as an XLSX file for the user to enter on Excel.