Android App that can edit XLSM files?

[SusaninHouston]

I'm finally moving into the smartphone world and am looking for an Android app that will allow me to access or edit XLSM files. Several claim to handle XLSX files, but virtually everthing I will want to look at is XLSM.

Can this be done?

And if XLSX is the limit, what is the best Android app for large and complex files?

 

[Wurzel]

The filter activates or deactivates the visibility of rows in dependent on flags or markers that are set or not set like numbers or "X".
These flags are located in other fields on the excel-sheet.
The activation rules are quite complex and excel has the methods to activate or deactivate the visibility of rows, but the automatism to do it by simply set a flag that is prompted in a field, is only reachable by VBA (afaik).
I can post a part of the VBA-Code if U want, but I am not allowed to post the content of the excel-tables.
I hope this gobbledegook is helpful.

 

[J.Ty.]

I did a toy-size example. It consists of two columns of data, two flags and a place wehre filtered data is displayed.
In practice, it means that you have to store your data in one place, and the results are displayed elsewhere (perhaps on a different worksheet).

The first filter checks if the number in the second column is even and is activated by putting anything in cell B2, the other one lets you choose in B3 the letter in the first column, no letter means that everything is allowed.

You can download this example from http://www.mimuw.edu.pl/~jty/MrExcel/Wurzel.xlsx
(I have a problem with posting html screenshot for some reason.)

Would that be the kind of functionality you are looking for?

J.Ty.

 

[J.Ty.]

I have managed somehow to post the screenshot, although it seems to be broken.

J.Ty.


Excel 2010

	A	B	C	D	E	F	G	H	I
is even	x	a	b
letter	b	d
c	f
d
e
f

[TD="align: center"]1[/TD]
[TD="align: center"]Flags[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Data rows[/TD]
[TD="align: center"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: center"]Filtered data arows[/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]6[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]

Sheet1​

[TABLE="width: 85%"]
[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]F2[/TH]
[TD]=IF(AND(OR(ISBLANK($B$3),$B$3=D2),OR(ISBLANK($B$2),ISEVEN(E2))),1+F1,F1)[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]H2[/TH]
[TD]=IFERROR(INDEX(D$2:D$7,MATCH(ROW()-1,$F$2:$F$7,0)),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]I2[/TH]
[TD]=IFERROR(INDEX(E$2:E$7,MATCH(ROW()-1,$F$2:$F$7,0)),"")
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]

 

[Wurzel]

Ohh, I tested it, it is quite clever, thanks for all your effort.
There is just one problem.
The part D, E, F of your table is over 800 rows long in my table, and the second part (H, I) of your table has to be shown on the top of my table and can contain non or 3 rows or maybe 30 rows of the first Part (D, E, F)
and it is not helpfull to reserve all over 800 rows for the second part of the table just for the rows in H and I on the top, just for the case that all 800 rows are shown, you know what I mean?
I just want to see the activated rows, maybe 10, and don't want to let the rest, lets say 790 rows, as empty rows.
In my solution with VBA, I have 2 complete tables, one above the other, but the upper table is just shown with the activated rows, the rest is not visible, is deactivated, fadet out.
And I reckon, if I use your solution, i have to reserve all 800 rows in the top table and only, lets say, the first 10 are shown, the rest of the rows are empty, but visible.
But independently, I appreciate your effort to help me.

 

[J.Ty.]

OK, as far as I understand, you prefer to have a few (the exact number is not known beforehand) filtered data rows on top, and the unfiltered rows below. I did it. There is a line with "Data rows" indicating the location where the separation takes place.

I still have a problem with posting screenshots, so instead I post a link to my OneDrive here: https://onedrive.live.com/redir?res...294&authkey=!AFfoYGoqPLth2XM&ithint=file,xlsx

At this moment it becomes important how quickly your spreadhsheet on Android processes the filtering. I could only test it on WPS Office (my personal favourite) on an emulator. It was rather slow, but acceptable.

J.Ty.

 

[Wurzel]

Not exactly. let me explain what I actually have.
I have different sheets in one Workbook (I hope I use the right phrases, my native language is german).
In about 4 or 5 sheets I have tables with about 500 to 800 rows (with 12 or 16 filled columns) that has to be chosen in the way u already realise,
and these rows and only these I choose, must shown on the top of the sheet in full length (of all 12 or 14 columns), above the fully visible table. The rest should be invisible. Right after the last chosen row should begin the whole visable table. You know?
And after that, on another sheet, all chosen rows from all 5 sheets must be shown directly one above the other with there different correct head of the table, but only the chosen rows, not the rest of there tables.
I hope I raped the english language not to much and i was a bit understandable.

 

[Wurzel]

The execution speed on my tablet was nearly instantly btw.

 

[J.Ty.]

I think I understand, but am not completely sure.
I hope this is not against the forum rules: please describe it again in German.

J.Ty.

 

[J.Ty.]

I have made the next attempt. Please test it, both concerning the functionality and the speed on a tablet.
Here is the link: https://onedrive.live.com/redir?res...296&authkey=!ACc4BnJh8iO9JWc&ithint=file,xlsx

J.Ty.

 

[Wurzel]

Hi J.Ty.
I still proof and analyse it, but it already looks cool and a proper solution for my problem.
I will report it if I finished the analyse process and the conversion to my tables and sheets successfully.
Meanwhile thank you very much.
Bin wirklich sehr dankbar für die Mühe, muss nur genau verstehen wie es funktioniert, um es ab jetzt selber verwenden zu können !
Greets, you are the best!