zhouchaoyuan / excelpanel Goto Github PK

放大缩小表格如何实现呢?求助

Can you please tell how to access excelpanel's scroll event and detect up or down scrolling

当数据多到可以上下、左右可以滑动时表格会不对齐。
操作：
1、先上下滑动；
2、这时候左右滑动，右边内容区的某列表格不对其，在触摸滑动下，又对其了。

首先我发现notifyDataSetChanged这个方法好像不好用，增删改的时候调用刷新没反应。于是我就每次有修改或者删除的时候就setAddData这个方法，增加和修改都没问题，但是删除最后一行cell的时候就不能用这个方法了，因为cell长度为0，会抛出索引越界，这个删除最后一行cell有什么好方法吗？

demo 里面运行起来，有卡顿掉帧的感觉

使用了NestedScrollview嵌套了Viewpager,里面的excelPanel 就不能用了

<android.support.v4.widget.NestedScrollView xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:id="@+id/activity_main"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:fillViewport="true"
tools:context="cn.zhouchaoyuan.excelpaneldemo.MainActivity">

<LinearLayout
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical">

    <android.support.design.widget.TabLayout
        android:id="@+id/tab_layout"
        android:layout_width="match_parent"
        android:layout_height="50dp"
        android:background="@color/bg_color"
        app:tabIndicatorColor="@color/tab_indicator_color"
        app:tabMode="scrollable"
        app:tabTextColor="@color/white"></android.support.design.widget.TabLayout>

    <android.support.v4.view.ViewPager
        android:id="@+id/pager"
        android:layout_weight="1"
        android:layout_width="match_parent"
        android:layout_height="0dp"></android.support.v4.view.ViewPager>
</LinearLayout>

</android.support.v4.widget.NestedScrollView>

如图，左边顶部可以填充文字吗。

Is it possible to have merged cells like in Excel (see AB & CD cells in screenshot)?
I do not see this feature but it would help me a lot.

Have a nice day !

表格标题和内容列有时滚动不同步啊，还有左边列和内容也有不同步
有没什么办法解决

I have implemented your library its working fine but i need to access touch of whole excelpanel. I didn't get any method or solution? How can i access this

望前辈提供点思路

这样子观看效果很差

在cells区域的左右两侧各有一个progressBar,不知道哪来的 我都照着demo写完代码了 才发现这个问题
怎么解决
另外 左右拖动标题行 上下拖动左侧标题列时 内容应该同步拖动啊 是不是因为这个progressBar造成的

随便一个彩票软件都有走势那种效果，如何实现呢

hi,as this code is 2 years old. i want to know how i will use this code in the new android studio 3.6 version code?

比如是否显示左侧表头 是否允许上下滚动 是否允许左右滚动
这些功能你都实现了为什么不提供关闭它们的开关呢

有一个奇怪的现象,当数据量比较大的时候, 前面的数据滑动起来不算太卡,但是如果一直往下滑动到接近底部的地方,就会出现卡顿现象, 看了Monitors,发现内存并无太大起伏,但是CPU曲线当滑动到底部的时候就很次CPU,导致滑动卡顿, 请问这现象有没有办法解决.

Application hangs/jerks/freezes when the row size is increased from 20 to 40. Is there any optimizations? It jerks a lot

I have an excel panel, top side of it has employees and left side of it has hours, before opening excel panel customer will be able to give a range of hours and when opening excel panel the panel must be able to scroll to that position where the given hour range is starting.
excel panel has a method call scrollTo(int x, int y) . but its not working. I also tried scrollBy() and setVerticalScrollbarPosition() methods and they are not working as well.

Could you please write tutorial about this in english ? I wish to learn and code like this.

Hello,
Vertical scroll not working for whole panel(refer below GIF) as you describe in description GIF.
can you please tell me ASAP how can I do that ?
Thanks

I want to scroll the cell on the top along with the cell in left if it is scrolled left. Any Solutions?

How can i make it load more rows but not columns?

我的需求是这样的,顶部第一行第一列和最左边的第一列需要对齐,也就是不需要左上角的第一个空表格,请问我该如何使用?

如果左边Item的View是wrap_content或者match_parent，那么垂直方向的滑动就会变成单个RecyclerView在滑动。

出现上面的原因应该是键盘引起了页面滑动，导致改项数据重新刷新了，请问如何解决？

大神，求助。如果我需要折叠展开，需要怎么实现呢？

Error:A problem occurred configuring project ':app'.

Could not resolve all dependencies for configuration ':app:_debugApk'.
Exception thrown while executing model rule: PublishingPlugin.Rules#publishing(ExtensionContainer)
> org/gradle/api/internal/component/Usage

请问 上拉加载 如何实现？ 目前好像只有左右加载 而且我关闭监听是 左右拉动时 还会有progre 显示？
点击事件能不能监听一整行？
@zhouchaoyuan

Hello,
first, thank you very much for sharing your work here!

I have some serious performance problems on tablets where there are e.g. 20 columns and 10 rows.

Is this normal? Do other users also have this issue?
Is there something I can do about, or is it a principal problem with the large number of RecyclerViews?

Thanks!

由于你的compileSDK是24，我的工程是21，直接引用jcenter，编译的时候values的一些文件会资源找不到，
如果引入moudle将compile降到跟我工程都是21，那recycleview有一个bug，normalCell不会显示，不知道有没有人跟我一样遇到这个问题，目前我的做法是引入moudle，compile降到21，把recycleView保持是24，这样虽然会报版本冲突，但是勉强还能接受。

如果我需要折叠展开，需要怎么实现呢？

滑动过程中,按下屏幕怎么中止正在进行的滑动呢?

Hi,Can you please tell me how to stick to the future data only and not load any history data.My requirement is to get data from sqlite and show employee one month data here.Thank you in advance

【修复BUG】
类MajorRecyclerViewAdapter
复写函数onViewAttachedToWindow
添加语句ExcelPanel.fastScrollVertical.....
代码如下所示：
@OverRide
public void onViewAttachedToWindow(RecyclerView.ViewHolder holder) {
super.onViewAttachedToWindow(holder);
ExcelPanel.fastScrollVertical(amountAxisY, ((RecyclerViewViewHolder)holder).recyclerView);
}

小米9的设备上面顶部固定栏，分割线会无法显示出来，知道什么原因吗