Ask Your Question

[Feature Request] Named Ranges and Import Support [closed]

asked 2013-09-29 02:01:31 +0200

xcv gravatar image

updated 2013-09-29 02:26:57 +0200

Re Excel / Calc

I tried to migrate from Excel to Calc but Libre does not yet support named ranges and Therefore LIbre also can't create or import named ranges

For example nameSTART=workSheet!$G$205 nameEND=workSheet!$G$3012 name=workSheet!nameSTART:nameEND

At the moment, Calc only support direct ranges not referenced ranges ie name=workSheet!$D$205:$G$3012 is supported

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-10 06:55:03.481453

1 Answer

Sort by » oldest newest most voted

answered 2013-09-29 02:26:37 +0200

m.a.riosv gravatar image

updated 2013-09-29 02:27:52 +0200

Why do you think so?
Have you tried?

The separator in ranges for sheets is the point: workSheet.$G$205
except with INDIRECT() function it is automatically adapted.

You can create names in: Menu/Insert/Names/Define

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-29 02:01:31 +0200

Seen: 83 times

Last updated: Sep 29 '13