Lubuntu 12.10 This kernel does not support a non-PAE CPU

Question

I'm trying to get the total number of columns so that i can set my range from column C to N column. I'm trying to go through each column and pull out the data i need into an array until i reach the last column with data in it.

I tried the below which works for one row, but none of the others i have.

IRange strategyname = foratworkbook.Worksheets["Strategy"].Cells["C4"].CurrentRegion;

C           D           E 
9.040%      10.910%     6.050%
4.920%      5.510%      3.430%
53.030%     64.400%     36.030%

Any Ideas? Thanks

Solution 1

It is possible to trick the apt-get installation script (preinst) of the new kernel images into believing they are to be installed on a PAE enabled System. Then it will install flawlessly (and if it is a Pentium-M (even one of those early ones that are missing the pae flag) then it will boot and run without errors).

To do so do the following:

• Install 12.04 Precise (maybe you have that already)
• Install the package "fake-pae" from this repository
• Do a normal distribution upgrade to 12.10 and enjoy the new Version :-)

As long as you have the fake-pae package installed there won't be any problems with kernel updates, these kernels run just fine on Pentium-M, even the early ones that do not announce their pae capability in their cpu flags. Just like the modified CD-boot images (the grub-trick) it is only a matter of circumventing these artificial installation restrictions, its not a problem with the kernel itself, you won't need custom built kernel images.

Solution 2

Try to install Lubuntu 12.04 32bit and then upgrade to 12.10

Inspired by this answer : How can I install on a non-PAE CPU? (error "Kernel requires features not present on the CPU: PAE")

Comments

[Kazimierz Jawor]

show a screen shot of your sheet data structure. which programming language you use? state it in question tags, please.

[Marc Howard]

Data structure added.

[Kazimierz Jawor]

where is cell C4, in C (GBP)?

[Kazimierz Jawor]

is there an empty line between C (GBP) and 9.040%?

[Marc Howard]

I've only put 3 columns just as an example. But it could be C:E or C:L ..

[Kazimierz Jawor]

.CurrentRegion will work if your range is continuous, without any row of column brake. If you have such a break you need to refer to your range differently. Best option is to find top-left cell and bottom-right cell of your range and next you could use the following structure .Range(cells(top-left cell), cells(bottom-right cell)). There are a lot of other solutions and possible ways to get your correct range.

[Marc Howard]

The range for the second piece of data is continuous but it seems to take data from the whole page instead of just that row. How am i supposed to know what the bottom right cell will be though? as it will always be expanding or contracting..?

[Kazimierz Jawor]

to give you any additional support I need to know precisely how your data is organised- you still didn't answer my questions from comments. So, is there any certain starting point like C4? etc... quick tip for now- use .End() property according to THIS

[Marc Howard]

The data is organised in columns, so i need to take the data from column C row 4 then column D row 4 and so on? until it reaches a column which is null. So the range would then give me C4:Q4 for example.

[Kazimierz Jawor]

in VBA you will use something like this (mix VBA-C# coding, just a kind of syntax): ...=foratworkbook.Worksheets["Strategy"].Range(Cells["C4"], foratworkbook.Worksheets["Strategy"].Cells["C4"].End(xltoRig‌​ht));. Try to adjust to your needs on your own.

[Marc Howard]

Thanks for the help. Only thing is i'm using the spreadsheet gear framework so that syntax doesn't fit. i'll try to work around it..

[bain]

possible duplicate of How can I install on a non-PAE CPU? (error "Kernel requires features not present on the CPU: PAE")

[Anton]

Ammar right, use sheet.UsedRange.Columns.Count and sheet.UsedRange.Rows.Count to get actual data.