We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

add-rows-which-are-copied

asked 2021-05-15 12:01:19 +0200

Hardik gravatar image

updated 2021-05-16 09:03:30 +0200

hi there,

Myself Hardik, I have worked mostly on windows excel . just started to work on linux

  1. I am not able to paste column width from one sheet to another.

  2. Most important and useful command, when i select and copy large numbers rows suppose 75 rows selected/copied from sheet "1" and we need to add those in another sheet "2" in existing table in between existing rows present in that table all together . I cannot do it.

in windows excel. I used to just select the rows press "ctrl c" from "sheet 1" . then go to "sheet 2" select the row where i need to add that copied data in between existing data. then I press "ctrl +" then copied data is added in between selected range.

please anyone suggest how can i do this in linux

edit retag flag offensive close merge delete

Comments

1

Your question is a Calc one. Please retag to replace common by calc. Enter a space then press Enter twice to exit retag mode.

ajlittoz gravatar imageajlittoz ( 2021-05-15 13:20:11 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2021-05-15 13:35:28 +0200

PKG gravatar image

updated 2021-05-15 13:37:14 +0200

I am not able to paste column width from one sheet to another.

Only works if the whole column is copied.

edit flag offensive delete link more

Comments

ok. now it worked. but when the both files have same extension. "xlsx".

Thanks a lot

Hardik gravatar imageHardik ( 2021-05-16 07:19:00 +0200 )edit

dear @ajlittoz. Many Thanks for your reply on both my questions. but my both concern are different , coping column width matter is solved thanks to you again.

but this questions was to add rows and columns in database . suppose I need to add 10 rows above 09/05/2021 date . we have 40 entries to copy from file 2 all together as mentioned below

File 1: SN date amount 1 12/05/2021 100 2 11/05/2021 200 13 09/05/2021 300 14 08/05/2021 400

File 2: 3 10/05/21 300 4 10/05/21 400 5 10/05/21 500 6 10/05/21 600 7 10/05/21 700 8 10/05/21 800 9 10/05/21 900 10 10/05/21 1000 11 10/05/21 1100 12 10/05/21 1200

And 1 more question I have raised regarding (') find ...(plus)

Hardik gravatar imageHardik ( 2021-05-16 08:16:42 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2021-05-15 12:01:19 +0200

Seen: 24 times

Last updated: May 15