Ask Your Question

user9733's profile - activity

2014-04-09 21:52:57 +0100 received badge  Popular Question (source)
2014-04-09 21:52:57 +0100 received badge  Notable Question (source)
2014-04-09 21:52:57 +0100 received badge  Famous Question (source)
2013-03-20 05:38:42 +0100 received badge  Self-Learner (source)
2013-03-20 05:38:42 +0100 received badge  Teacher (source)
2013-03-20 02:24:34 +0100 answered a question How do you get libreoffice to fill in these boxes automatically?

I asked how to mass paste in xlsx without messing it up.

I never used office apps before but I figured it out.

  1. copy paste everything into a new document
  2. "delete contents" formatting, etc.
  3. edit without format crap in the way
  4. copy paste text and numbers into original document

http://www.mediafire.com/?kk8bqb2p6hh14nt

http://depositfiles.com/files/mvs6mb69e

Some things I didn't figure out;

  1. count every 20 rows from 100 to 120
  2. select every 20 rows and change row height
  3. make the cell boarders less thick after saving

So I just did it manually.

I know I don't need advice anymore I just wanted to tell everyone.

2013-03-20 02:21:52 +0100 answered a question How do you get libreoffice to fill in these boxes automatically?

Hi @qubit

A macro was suggested but I can not into programming.

Yes, I never used libre or any office either.

Thanks for the reading material.

Thank you for responding.

2013-03-19 11:14:55 +0100 received badge  Student (source)
2013-03-19 06:54:08 +0100 received badge  Editor (source)
2013-03-19 06:38:18 +0100 asked a question How do you get libreoffice to fill in these boxes automatically?

Noob here.

How do you get libreoffice to fill in these boxes automatically?

The "points" box is "1" and feedback "Correct!" and "Incorrect".

Links to the file.

http://speedy.sh/jMa8E/microsoft-office-excel-quiz-template-2.xlsx

http://www.mediafire.com/view/?zbsayacod1jeo5v

http://depositfiles.com/files/srzvxhgwj

Image of what I'm talking about.

image description

I have 100 boxes like that.

I need to paste that same information in all the boxes.

Also I need 120 questions instead of 100.

I never used microsoft or open office before.