Problem with Libreoffice Calc 1

[dik]

This is an Excel workalike... When I copy and paste values for a new beam, it pastes the formulae values in the cells, rather than the formulae. It used to copy the formulae so it was just a matter of changing the beam size from the AISC spreadsheet.

I suspect I may have inadvertently changed a setting. Does anyone know hot to fix this. It used to work.

https://files.engineering.com/getfi...84d0a69ba&file=ET_Maximum_Reactions_AISC.xlsm

-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik

 

[IDS]

I don't use Calc, but is there something similar to Excel's Paste-Special, that allows you to choose exactly how you want something pasted?


Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[dik]

Thanks... I'll take a look. For my Vital Stats spreadsheet, I use paste special all the time. I may have accidentally set a switch or something.

-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik

 

[IRstuff]

In Excel, the only sure way to copy a formula as written is to edit the cell and select its contents and copy.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert!

https://www.youtube.com/watch?v=BKorP55Aqvg

faq731-376 forum1529 Entire Forum list

http://www.eng-tips.com/forumlist.cfm

 

[MintJulep]

When I copy and paste values for a new beam, it pastes the formulae values in the cells, rather than the formulae.

That seems to be working as designed then. Paste values pastes values.

The default paste will paste the formula.

 

[dik]

I'm not using Paste Special; I'm just using Paste.

-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik

 

[Celt83]

See lots of bug posts in the LibreOffice bugzilla regarding this but nothing stands out as a cause:

here were the most common issues I found:
The sheet was not auto-calculating after the paste operations so it only looked like the value instead of the formula was pasted. Force a sheet re-calc with shift-ctrl-F9 or in the menu bar Data - Calculate - Recalculate

Don't use a 3rd party clipboard manager (think this is more applicable on the linux side)

Unsolved/Unknown reason for the behavior

Seems in all cases the recommendation ends up being to stop using ctrl-v when you want to paste formulas and instead do shift-ctrl-v for paste special and then choose formula only.

 

[dik]

Thanks, gentlemen...

-----*****-----
So strange to see the singularity approaching while the entire planet is rapidly turning into a hellscape. -John Coates

-Dik