Hi,
Is anybody aware of any limitations of the Rows or Columns NL functionality? For example, I have a NL Columns within an NL Columns. They appear to replicate across the sheet Ok, until a point where the inner most NL stops replicating. I'm a little stumped as the inner formula that stops replicating is very simple:=nl("Columns",{"Builder","Retail","Commercial","Distributor"})
The outer formula replicates using Columns=5 on a table of date ranges - this continues to replicate through all expected values without problem, however the inner one stops at columns FT. No errors are thrown.
Does anybody in forums land have an idea before I try support?
thanks, Mark
Date
Votes
8 comments
-
Jet Reports Historic Posts I think there may be a limit of 256 columns in a report. I think this is increased in newer versions of Excel though (over 16,000)…
http://www.j-walk.com/ss/excel/odd/odd13.htm says 256.
http://msdn.microsoft.com/en-us/library/aa730921.aspx for newer versions.
That is about all I can think of. -
Jet Reports Historic Posts Though FT would seem to be around the 175th column… which should be within any limit. You're right, this is odd.
-
Jet Reports Historic Posts I did a quick test with some static data - hard coded values. I've attached the sheet.
For me the column replication stops at column HO. Do you see the same when you run it? -
Jet Reports Historic Posts It went out to IQ for me.
-
Jet Reports Historic Posts Interesting… Perhaps its a client side memory thing. Did if fully copy the columns out, or did it stop replicating at IQ?
What version of Excel and Jet are you running? -
Jet Reports Historic Posts For me, the correct column replication stops at HO, and the last cell is in IQ
-
Jet Reports Historic Posts For me, the correct column replication stops at HO, and the last cell is in IQ
Yes, at HO, I show Column Eleven, but there is only one column for it instead of 20.
IP is Twenty with a single column, and IQ is the last cell with data, showing Total.
I don't understand why it would stop replicating fully at HO. I would guess that it is an order of operations, where it first creates the 20 basic columns, then later creates the 20 subcolumns per column (1,2,3,…20 - then 1,1,1,1, …. 2,2,2,2,2,2) and at the point where it was unable to create the full 20 subcolumns due to space restrictions, it was left with only the previously created single column.
I'm running excel 2003, Jet version 5.2.9. -
Jet Reports Historic Posts Thanks for your help. What you are getting is the same as I am. I think I will do some more investigations on it and talk to support about it.
We're running Jet 7.1 so I presume if its a bug it will have to wait until a future release.
thanks, Mark
Please sign in to leave a comment.