asked 2012-04-09 20:38:05 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
Hi, I have a problem. I have an excel file with a big formula consisting of a serie of if-conditions. When I open the file in the open calc app, all these formulas are truncated and therefore It produces an error in the cells where the formula is applied. This problem doesn't happen when the file is opened from Microsoft Excel, of course.
Why this happen?
Thanks
(Turning comment into Answer so we may resolve this question)
@Pedro writes:
Can you upload a sample file? It seems like a limitation of the Excel import filter. Have you tried pasting the formula in an ODS file?
answered 2012-11-07 00:43:53 +0200
This post is a wiki. Anyone with karma >750 is welcome to improve it.
For complicated formulae, I type and format them in another editor, emacs in my case. This makes it easier to catch missing closing parentheses and to see the structure of a formula. When I'm satisfied, I paste it into calc.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-09 20:38:05 +0200
Seen: 128 times
Last updated: Feb 06
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Can you upload a sample file? It seems like a limitation of the Excel import filter. Have you tried pasting the formula in an ODS file?
Pedro ( 2012-04-09 21:49:21 +0200 )edit